The columns (vertical bars) are going to be pretty narrow eventually, as the
number of time points increases.

In a column chart, you only get the time values that are listed, because
they are treated as labels, not as numerical values.

Here's a different approach, which will look pretty much the same. Create an
XY chart of the data, which will give you control over the X values You will
get points at Y=1 for the points where Y=1, and at Y=0 for the points where
Y=0, and nothing for any other times. When setting the X axis scale, enter
the times in time format, for example, enter 0:00:00 for minimum and 0:02:00
for major unit (if 2 minutes is appropriate for that of course).

Then double click on the series of points. On the Y Error Bars tab, choose
the negative icon, and choose a percentage of 100%; on the Patterns tab,
choose None for Marker and Line to hide the data points themselves. Finally
double click on the error bars, and choose a line color and thickness that
you like, and choose the line effect that does not have the end caps.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Vlado Sveda" wrote in message
...
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