Previous Topic Next Topic

Create new sheets in Excel based on dates and creating charts

Closed
alars Posts 2 Registration date Wednesday September 18, 2013 Status Member Last seen September 24, 2013 - Sep 18, 2013 at 05:09 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Sep 24, 2013 at 11:29 AM
Hello,

I have excel file with aircraft engine data (date, time, EGT & CHT for 6 cylinders, fuel flow and manifold pressure), eg 16 columns and about 6000 lines.

Example of two lines:
06.16.2012 14:42:36 1360 1398 1402 1395 1385 1347 301 291 281 288 280 200 164 235
06.16.2012 14:42:48 1361 1397 1402 1396 1385 1347 302 292 282 289 280 201 164 235


How can I automate the action:
separate every day's flight data (using dates from the first column) and put them on separate sheets (also renaming them) and then create a line chart for all of them?


1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Sep 23, 2013 at 11:49 AM
Hi Alars,

Have you considered the autofilter option? Filter on a specific date, select the filtered data and hit the create graph button. Select you desired graph type and hit finish.

Best regards,
Trowa
0
alars Posts 2 Registration date Wednesday September 18, 2013 Status Member Last seen September 24, 2013
Sep 24, 2013 at 09:03 AM
Yes I've tried that but since there are ca 80 different dates which means 80 different charts then I thoughed maybe there is a way to automate the action.
0
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Sep 24, 2013 at 11:29 AM
In that case, can you upload your workbook to a site like www.speedyshare.com or ge.tt with at least one graph. This way I know what you are aiming for.
0

Similar discussions

Why can't I bridge connect?
ryno -
Qiqi -

15 responses
How do I change a base location on Instagram?
rebelkids -
38nancy -

8 responses
Hi Guys how to create an account for facebook with my company em
Ramu -
Ahmadzai -

2 responses