Double click the axis, and on the Scale tab, enter the values you want in
the min, max, and major unit boxes. Use a time format of h:mm or h:mm:ss to
enter the values, and Excel will convert them to the decimal equivalents for
you.

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


"RV" wrote in message
...
Thank you David. I changed to custom hh and getting 7:12 or 2:24 instead
of
7:00 and 2:00. Is there any way around it?
--
RV


"David Biddulph" wrote:

Format Axis/ Number/ Custom:
hh
--
David Biddulph

"RV" wrote in message
...
I am trying to use the following hours to display on the X axis labels
in a
chart. The chart is displaying hours and minutes. How can the hours
only
be
displayed on (X) asix labels?

Date/Time 1:00 2:00 3:00 4:00 5:00 6:00 7:00 8:00 9:00 10:00 11:00
12:00
13:00 14:00 15:00 16:00 17:00 18:00 19:00 20:00 21:00 22:00 23:00 0:00

--
RV