Adjust scales automatically

  • Thread starter Thread starter Nicole
  • Start date Start date
N

Nicole

Hi,

How can I arrange it so that the x and y axis scales
automatically adjust to different data within the same
series?

Eg say I make a chart that has the x axis (A1:A10) going
from 1 to ten. If I paste in an x axis range going from
100 to 1000 how can i get the scale to adjust
automatically?

Thanks for help,

N
 
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
 
Back
Top