Variable size of chart

Derek Locke · Nov 23, 2007

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 · Nov 23, 2007

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 · Nov 24, 2007

Many thanks - Derek Locke

Jon Peltier said:
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
_______