Stacked column graph to show downtimes

[WMF777]

Hi there, and thank you for your time!

So, this is my situation:

I've been tasked with creating a chart to show downtime for a piece of equipment through log on and off times. I figure, if I can get a stacked column graph to plot time on and time off in alternating bars, then the area in between plot points is downtime. However, I can't seem to get the graph to alternate values from the two columns. Is this possible? It seems like it would be easy, but there must be something I don't understand. Just in case this is a confusing description, what I'd like to do is this

Time On| Time Off

To a stacked column something like this

Time Off
Time On
Time Off
Time On
etc.


Thanks so much for any help you can provide.

[Andy Pope]

From the second data point onwards you need to plot the difference in time not the actual time.

If you are still stuck post workbook example