Messing around.
In the attached:
Sheet2: Chart and slicer at cell B2. Select the date(s) you want to see in the slicer.
Sheet1: Pivot table that the chart is based upon. That pivot table is based on the data in the first 5 columns of that sheet BUT not directly; that data has been through a Power Query whech feeds the pivot.

Attached Files

MSOfficeForums50114Worcester Bosch Boiler Data Log suss heating problems forum.xlsx (70.5 KB, 7 views)

Hi,

OMG awesome. I wish I knew how to do that.
I like the flame and motor displays.
THANK YOU THANK YOU THANK YOU



and now can this tweak be done ?


This post by you has missed an update I made before it appeared.


I need to see the graphs against a normal time progression on X axis, 1cm being e.g. 5 mins increment for each days graph. I can then overlay them in Photoshop and X matches. (Y also to be same progression, it already is)



With the observations on stopwatch getting plotted as e.g. 00:10 to 00:12 in same distance along X axis as 00:23 to 00:30, (2mins progression same as 7 mins on X axis disyance ) it disallows one being compared regards time flow to another.


I had edited post (perhaps you didnt see it) to ask for a standard timeline where e.g. 1cm was 5 mins, and the stop watch times get allotted the appropriate position, without times shown, just graph.


A friend says to do that the rows would have to have 1 second increments so 30mins observation period would be 30x60 = 1800 rows and the observations placed on the matching rows for the time so 1m30sec or 00:01:30 would be on the 90th row.
hate to think what a 5hr observation would be.


Is that what is needed ? or can Excel look at a time and place it on a standard time progression X axis ?



The rows, many not having entries for deg C, are then plotted on the graph so if graph is 200mm wide each row would be 0.11mm along the graph. Not sure if plots can be that close. Certainly the SW time would not appear, but is not necessary as the timeline would be 0 5 10 15 20 etc mins marked.


DBenz

Hi,

a friend has tried to get this to be on a standard timeline, as mentioned, and attached is the result.
I have had to get it into photoshop and draw in vertical lines every 5 mins.
I need though the flame on and motor on data also into the graph.
he says alter the formula for the temperature column to read flame on, I now see 1 and 0, but col H still has temperature.

Not sure how BCDE gets into HIJK
doing this will obviously remove the dots ferom the graph.


I also had to use photoshop to put lines between the dots !



Help !


DBenz

Attached Images

Worcester Bosch Boiler temperature v flame and motor data photoshop.jpg (129.5 KB, 10 views)

Attached Files

Copy of Worcester Bosch Boiler Data Log suss heating problems forum FLAMEon.xlsx (409.0 KB, 4 views)