setting scale on chart automatically

[Sanford Lefkowitz]

I am having users select a time series (line) chart from a drop down menu. (I
have a bunch of data on a separate page. The drop down menu pulls in the
requested data to a defined range and draws the chart). Frequently, the scale
on the Y axis that Excel chooses is highly sub-optimal. I don't want the user
to have to manually adjust the axes. Is there any way I can specify the scale
on the axes without manual adjustments?

Thanks

 

[Jon Peltier]

You could use VBA:

Link Chart Axis Scale Parameters to Values in Cells (VBA)
http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html

Use formulas to put "nice" scaling values into the cells monitored by
the macro.

- Jon