Charting Duration of Events

[Nugget]

Hello,
I am trying to chart some data that contains events that last for a random duration. Lets say I have some data like this (for 20 seconds):
seconds, value
0 OFF
1 OFF
2 OFF
3 ON
4 ON
5 ON
6 OFF
7 OFF
8 ON
9 ON
10 ON
11 ON
12 ON
13 OFF
14 OFF
15 OFF
16 ON
17 ON
18 ON
19 ON
20 ON
It is kind of like a gantt chart but I need all of the events on a single line.
The ASCII art lis like this (the underscores would be spaces):
___||||||___|||||||||||||||_______|||||||||||||
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

I know there must be a way, but I'm not seeing it.

 

[SteveO59L]

Use an if statement to convert the "Ons" to 1 nad "Offs" to 0. Then you will have some numeric data to plot

 

[Nugget]

Yes I did that, that will let me create a line chart, but I need/want a bar chart. I tried chaning the width of the line but it also changes the "zero" values on the line. I would go through and change each indiviual data points, but I have over 665,000 data points to do with this.

 

[SteveO59L]

Right-click on the chart and change the chart type

 

[Nugget]

Thanks, but that doesn't work.