Excel has created Y-axis increments of .14!

  • Thread starter Thread starter arhooley
  • Start date Start date
A

arhooley

The format for my data is 0:00, chart is plain old bar.

Lowest value = 0:01

Highest value = 1:26

Excel has created a Y-axis with minimum 0:00 (fine) and max 1:26
(huh?). In between are 6 major units with increments of .14.

How can I change this so the maximum value is, say, 1:30 and the
increments are .10? I've fiddled for half an hour with the Value Axis
format options, but nothing works.

Thanks.
 
Double-click the y-axis and in the resulting dialog box select the Scale
tab. In there, set the min. to 0, the max. to 1:30. I don't understand
how 0.1 interacts with what appears to be time, but set the major unit
to 0.1 In each case, ensure the checkbox next to the item you change is
*not* checked.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005
 
Thanks, Tushar, but that made it worse. I already fiddled with the
scale and the increments are always 14. Excel's auto sets are min 0,
max .06, major units .01 and minor units .002. My actual data spread is
0:27 to 1:16; these are runtimes for mainframe jobs. What shows on the
y-axis is as I said, minimum of 0 and max of 1.26. Setting your scale
just shrank everything down to what looked like miniature cigarette
butts with most of the plot area empty. Another Excel chart-maker
onsite can't figure it out, either. If we ever do, I'll post.
 
While XL shows all values in the Scale tab as decimal values, it accepts
time values. If your runtimes are mm:ss, use 0:mm:ss in setting the
max/min/major unit values. If you only specify xx:yy XL assumes it is
hours:minutes.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005
 
Back
Top