Variable size of chart

[Derek Locke]

I would like to write some VBA code that can use a chart, and control the
range of the source data from the code, so avoid manually changing anything.
Is this possible?

 

[Jon Peltier]

You don't necessarily need code if you make use of dynamic names as the
chart series data:

http://peltiertech.com/Excel/Charts/DynamicColumnChart1.html
http://peltiertech.com/Excel/Charts/Dynamics.html

- Jon

 

[Derek Locke]

Many thanks - Derek Locke

You don't necessarily need code if you make use of dynamic names as the
chart series data:

http://peltiertech.com/Excel/Charts/DynamicColumnChart1.html
http://peltiertech.com/Excel/Charts/Dynamics.html

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