Scale Limits

[LiAD]

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]

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]

Perfect

Thanks

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/



.