Hi All,

I'm trying to make a chart of machine Uptime and DownTime, I only have start and end times. Here is some example data:

11/19/2015 01:48:21	1
11/19/2015 01:48:22	1
11/19/2015 01:48:22	0
11/19/2015 01:50:07	0
Where 1 = Uptime and 0 = downtime.

If I chart this data in excel using area chart this happens:

temp.png

The X-axis is giving every entry equal space on the graph, I need to be able to observe the length of time a machine was up or down just from looking at the graph. Also when it goes from 1 to 0 there is a slope and I need a step change as a machine can only be up or down, there is no in between.

This is mock up using paint of the sort of thing I'm trying to make:

temp2.png

Anyone have any ideas?

Cheers

Steve