Dynamic Scaling
 

Is is possible to programmatically scale a chart? Basically I want to force
the chart's extents to be related to the extremities of my data.

Thanks,

Cody

Cody -

Here's how to use VBA to link your axis scale parameters to a set of
worksheet cells:

http://peltiertech.com/Excel/Charts/...nkToSheet.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Cody wrote:

Is is possible to programmatically scale a chart? Basically I want to force
the chart's extents to be related to the extremities of my data.

Thanks,

Cody