Hi,

Worksheet has first column time, second is gas boiler temperature, third is gas flame Indicator on or off
TIME TEMP FLAME INDICATOR
00:00:00 45 Off
00:00:08 44 Off
00:00:15 44 ON
00:00:17 45 ON
00:00:19 46 ON
00:00:21 47 ON
00:00:23 48 ON
00:00:27 49 ON
00:00:45 50 Off
00:00:47 49 Off
00:00:49 48 Off
00:00:52 47 Off
00:01:02 47 ON


00:01:05 48 ON

using scatter with line, I have X as time and Y as temp, I need to also have on X the On or Off as a coloured area, or somehow show on and off zones.
On and Off as cell values dont get recognised in a graph, needs to be numerical I think.
How do I do this ON and OFF thing ? On as green and off as blue areas for example

as below


Started here as new thread as suggested brought over from here:-
https://www.msofficeforums.com/excel...nto-graph.html

Thanks

DBenz

Make another column where each On =1 and each Off = 0. Make your chart a combo with this data as column type with gap width = 0

Attached Files

OnOff.xlsx (15.6 KB, 10 views)

Hi,
I have followed that through creating a chart from your numbers and can see the stages involved now and achieved your result.

many thanks

DBenz