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