Formatting Axis

  • Thread starter Thread starter jag
  • Start date Start date
J

jag

How do I format an axis on a chart so when choosing Auto it doesn't
default to minimum 0 but actually a number closer to the minimum
number in my selected range for the chart?
Thanks in advance
 
Hi,

Auto means Excel decides, and for certain types of charts that will always
be 0. So the answer is you can have it both ways Auto and not Auto at the
same time.

You can either manually enter the minimum or you can write VBA code to do it
for you.

If this helps, please click the Yes button

Cheers,
Shane Devenshire
 
Back
Top