setting scale on chart automatically
 

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

setting scale on chart automatically
 

You could use VBA:

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

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

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
774-275-0064
http://peltiertech.com/


On 4/9/2010 3:39 PM, Sanford Lefkowitz wrote:
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