Boundarys on x-axis

  • Thread starter Thread starter Ruth
  • Start date Start date
R

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?
 
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 -

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/
_______
 
Back
Top