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

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

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

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

It appears that the actual data for the hours is charted, not the actual
hours. I can not change the scale to display the hours. I hope I have
described the situation better.
Day Max Hours Actual Hours Data
1 147 14:00 0.583333333333333
2 148 15:00 0.625
3 166 14:00 0.583333333333333
4 182 19:00 0.791666666666667
5 219 16:00 0.666666666666667
6 170 15:00 0.791666666666667
7 156 15:00 0.625
--
RV


"Jon Peltier" wrote:

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

0.58333333333 is how Excel stores 14:00; 14:00 is how Excel displays
0.58333333333 using a number format of "H:MM".

What kind of chart have you made? If the times are on the X axis of a line
chart, they may not work the way you expect, because a line chart does not
use values, only labels.

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


"RV" wrote in message
...
It appears that the actual data for the hours is charted, not the actual
hours. I can not change the scale to display the hours. I hope I have
described the situation better.
Day Max Hours Actual Hours Data
1 147 14:00 0.583333333333333
2 148 15:00 0.625
3 166 14:00 0.583333333333333
4 182 19:00 0.791666666666667
5 219 16:00 0.666666666666667
6 170 15:00 0.791666666666667
7 156 15:00 0.625
--
RV


"Jon Peltier" wrote:

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