Scale Limits
 

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

Scale Limits
 

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/...nkToSheet.html

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


On 3/26/2010 10:09 AM, LiAD wrote:
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

Scale Limits
 

Perfect

Thanks

"Jon Peltier" wrote:

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/...nkToSheet.html

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


On 3/26/2010 10:09 AM, LiAD wrote:
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
.