Autoadjusting Y axis minimum

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want the axis to adjust to 2/3 of the lowest value in my
chart. How do I get my minimum to change? When I set it
to auto it just starts at 0.
 
You have to do it programmatically. Jon Peltier has shared code on the
subject. Search google.com's archives of the XL newsgroups. For a
readymade solution check the AutoChart Manager add-in available from my
web site.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
You must log in or register to reply here.

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

Horizontal axis to the bottom 1
move y-axis to the left of x-axis "0" 2
Make Y-axis values correspond to x- axis value 1
X-axis labeling 1
Formatting 'X' Axis -- 2 fundamental differences 7
How to plot chart where X axis values START >1 1
How do I put words as the Y axis values? 0
X Y (Scatter) Chart EXCEL 2007 1

Back
Top