Bar chart help wanted !

[Vlado Sveda]

Hello to everybody !

I have this kind of data:
TIME VALUE
0:00:00 0
0:00:34 1
0:00:35 1
0:01:00 0
0:01:30 0
0:01:33 1
0:01:55 1
0:01:59 0
0:02:00 0
0:02:10 1
0:02:15 1
0:03:00 0
0:03:05 0
0:03:07 1
0:03:55 1
0:08:00 0

and I need to create bar chart that would have a bar of the hight equal to 1
at each time value where the "value" in table (Y-axis) equals one (and also
between "one"s values). In all other time values the Y value is zero !

Excel bar chart seems to omit all values that are not in the dataset ! I
need to include also those time values that are not explicitly listed in the
table - all those should be zero by default - e.g. 0:00:36 will be zero,
0:00:37 will also be zero until 0:01:33 where there will be again value of 1.

Is it possible to make this kind of chart in Excel ?

Thanks in advance

Vlado

 

[Jim Jackson]

The chart will only pick up data input into the range of cells involved. You
will need to include all the time values in the dataset that you wish to
appear on the chart.