Dynamic Scaling

[Guest]

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]

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/
_______