Prev: TODAY() in an IF AND function
Next: Does a formula exist that will lookup on ALL tabs, not just one.
From: Sanford Lefkowitz on 9 Apr 2010 15:39
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
From: Jon Peltier on 11 Apr 2010 14:56
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
-------
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
 | 
Pages: 1
Prev: TODAY() in an IF AND function
Next: Does a formula exist that will lookup on ALL tabs, not just one.