You don't need to have lots of evenly spaced (small) time intervals if the data are plotted on on an xy-scatter plot. This isn't possible with pivot tables so another way is possible with a standard excel table(s).
Also when plotting several days' data it's going to be very difficult to discern flame and motor statuses if the days all overlap.
So the attached is only to show how things might work in principle:
Your raw data stacked on top of each other on Sheet1
A Power Query table on Sheet3 which is filtered by a slicer on Sheet4
A chart on Sheet4
Choose a date(s) from the slicer to observe changes in the chart.
The chart has major gridlines every hour and minor ones every 5 minutes.
To show how easy it is to add further plots, you'll notice that when you choose 12/12/22 that another series appears; this is data from Sheet3!G340:H351.
Excel's default automatic x-axis limits aren't very good here so there's a little macro which sets them when you change the date(s) you're viewing (this needs a little more work). This macro is triggered by the Calculate event of Sheet3 which calls the macro Macro3.
I see there are SW times and GMT times which will have to be aligned - all to GMT or all to SW. You can tell me more about that.
|