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