Can a combined graph be made of this data ?

[DBenz]

Hi,
I am with four SIMPLE data sets, TIME against Temperature, see attached, one per sheet, and wish to see the plots on one graph, how is this done ?

I didnt know if all data had to be on one sheet for such.

Furthermore I have two columns as ON or OFF, the ON time being in colour, so a line parallel to time X axis with gaps is envisaged, should the data be 0 and 1 or YES and NO or ON and OFF ?

Time along X, Temperature on Y
the ON OFF to be a gappy line parallel to X,
Different colour lines for each Sheets temperatures and data.


I also have some data for the evo home systems 'seen' temperature and target it was aiming at. I need to add these in using photoshop, The Y axis must have a second set of values 14deg C to 28C to do so, hence use photoshop as this otherwise is getting to be mental overload !
Though I see one can have a second set of values on the right hand side Y axis, so it is possible.

I was unable to monitor the achieved temperatures whilst standing at boiler anyway., so at best I have achieved room temperature at start and end of the session.

I need a standard timeline along X axis , same value progression for all sheets. and the time values take up their appropriate positions on that timeline, as opposed to each entry has its time and each are 1 unit apart, that would give a false graph line as it could see 5 entries 10 secs between them take up same width as 5 with 6 minutes between them !


The Y axis must have the same spacing between degrees Centigrade for all graphs, if they have to be created separately.





As such then I can overlay them in Photoshop and axes all match.


Could someone create the graph with the attached excel2013 data and post result for opening in Excel 2013. That way perhaps I can see how its made, and indicate the steps taken, method etc.


If its easier to make one graph per sheet/day, I then use photoshop to set them over each other. Axes must as said match for all.


The ON OFF data is one area I havent a clue on, as at start of post.


Columns to take data from are:-
Time SW (stop watch) (00:00:00 format)
Boiler temp 56 57 58 65 etc
Flame ON OFF
Motor ON OFF


I have a boiler that has a mind of its own, one day room takes 6 hrs to attain 22deg C, another day its far quicker, due to temps of 85 max on boiler and not the inadequate 65 max.
Yet I am told Boiler is fine.

My attempt to see what is going on.

here is the data


Cheers


DBenz