Boundarys on x-axis

[Ruth]

I am constructing a bar chart and would like to be able to
change my x-axis to a value axis.
Unfortunately for what I am doing I have to use a bar
chart but need times along the x-axis. Is there anyway to
do this?

 

[Don Guillett]

try changing to a category

 

[bob]

Have you tried converting your time values to text and
labelling the x axix with these.

 

[Ruth]

If I change to text it still leaves it with the number
that it has automatically generated. If I change it to
time I get the time format but they are all 00:00

 

[Ruth]

I have tried this and it still won't let me have times

 

[Jon Peltier]

Ruth -

Did you select any cells to use as X values? If not, Excel just uses 1,
2, 3, etc., and an integer corresponds to midnight on that number day,
or 0:00.

To include X categories, right click on the series, select Source Data,
click on the Series tab, select the series, then click in the Category
(X) Axis Labels box and select the cells with your mouse.

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