How to set scale of y axis for time
Simply type in the times in time format, such as 0:10:00 instead of
0.00694444
Excel will change the values to General format, but accepts inputs as times.
I think I heard that Excel 2007 would not accept time inputs in this way.
--
David Biddulph
Meenie wrote:
I have Excel 2003 and am having trouble with the y axis scale for
minutes. the times I'm showing in my clustered column chart range
from 30 seconds to 6 minutes and 34 seconds.
I copied a scale from another chart and had to fiddle with it a bit
to get it to show the right scale.
The scale I copied was:
Minumum: 0
Max: 0.166666
Major Unit: 0.02083333
Minor Unit: 0.00694444
I had to change it (by some major trial and error) to:
Min: 0
Max: 0.2866666
Major Unit: 0.0308333
Minor Unit: 0.00694444
Can you tell me how to figure this out so I can set it the way I want
next time?
thanks Meenie
|