Charts
 

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?
--
Sandi Gardner

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/so...art/index.html

--
Regards,

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

In article ,
says...
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?

Sandi,

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

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

----
Regards,
John Mansfield
http://www.pdbook.com

"Sandi" wrote:

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?
--
Sandi Gardner