Charts

[Sandi]

I have a chart that I would like for the y-axis to scale automatically when
new numbers is entered into the series. How do I set this up?

 

[Tushar Mehta]

The default setting will cause XL to automatically scale the axis. To
control the min/max values it is necessary to use VBA code. For a
readymade solution see
AutoChart Manager
http://www.tushar-mehta.com/excel/software/autochart/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[John Mansfield]

Sandi,

In addition to Tushar's add-in, you can find an example of the VBA code used
to set the axis here:

http://www.pdbook.com/index.php/excel/tie_y_axes/