software

I am trying to have the data on the y-axis appear exactly as it does in my
source. I would like it to say 1:00 AM, 2:00 AM, 3:00 AM, etc. It keeps
appearing with random numbers (12:57AM, 1:24 AM, 3:17 AM. How can I change
this?

Diane:

Take a look at your Y Axis Format Axis menu. Go to Scale tab. What is your
major interval? Excel treats time as a fraction of a day, so 1 hour is
actually (1/24), 3 hours is (3/24), etc.

To get your intervals to show in 1, 2 or 3 hour increments, calculate the
decimal equivalent for the hourly interval you want. For 2 hours, it would
be (2/24 = 0.083333); for 3 hours it would be (3/24 = 0.125).

....Kelly

quot;Dianequot; gt; wrote in message
...
gt;I am trying to have the data on the y-axis appear exactly as it does in my
gt; source. I would like it to say 1:00 AM, 2:00 AM, 3:00 AM, etc. It keeps
gt; appearing with random numbers (12:57AM, 1:24 AM, 3:17 AM. How can I change
gt; this?
Even easier, to get an even hourly increment, enter it in hh:mm or hh:mm:ss
format. Excel does the conversion for you. (Next time you open the dialog is
will be in decimal format.)

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
peltiertech.com/Excel/ExcelUserConf06.html
_______quot;Kelly O'Dayquot; gt; wrote in message
...
gt; Diane:
gt;
gt; Take a look at your Y Axis Format Axis menu. Go to Scale tab. What is your
gt; major interval? Excel treats time as a fraction of a day, so 1 hour is
gt; actually (1/24), 3 hours is (3/24), etc.
gt;
gt; To get your intervals to show in 1, 2 or 3 hour increments, calculate the
gt; decimal equivalent for the hourly interval you want. For 2 hours, it would
gt; be (2/24 = 0.083333); for 3 hours it would be (3/24 = 0.125).
gt;
gt; ...Kelly
gt;
gt;
gt;
gt;
gt; quot;Dianequot; gt; wrote in message
gt; ...
gt;gt;I am trying to have the data on the y-axis appear exactly as it does in my
gt;gt; source. I would like it to say 1:00 AM, 2:00 AM, 3:00 AM, etc. It keeps
gt;gt; appearing with random numbers (12:57AM, 1:24 AM, 3:17 AM. How can I
gt;gt; change
gt;gt; this?
gt;
gt;