Dynamic Scaling

Cody · Jul 11, 2005

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

Jon Peltier · Jul 11, 2005

Cody -

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

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

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