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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reversing Dates Sequence along X axis in a chart 3
Chart Dates Difficult to Set 1
Formatting number in Data Table 2
Unevenly spaced x axis on chart 1
How can I add a 3rd axis to my chart? 3
Chart of Times 3
How to draw a graph with the X axis as a time line of date. 4
simple bar chart, help please. 2

Back
Top