Scale Limits

LiAD · Mar 26, 2010

Hi,

Is it possible to drive the max and mins of a y-axs on a chart from cells S6
and S7 of the same worksheet?

This way it updates with changes to data without showing everything.

Thanks
LiAD

Jon Peltier · Mar 27, 2010

You need a little VBA for this. Here's how:

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

- Jon

LiAD · Mar 29, 2010

Perfect

Thanks

Jon Peltier said:
You need a little VBA for this. Here's how:

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

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

.