Variable size of chart
 

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?

Variable size of chart
 

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

http://peltiertech.com/Excel/Charts/...umnChart1.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
_______


"Derek Locke" <Derek wrote in message
...
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?

Variable size of chart
 

Many thanks - Derek Locke

"Jon Peltier" wrote:

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

http://peltiertech.com/Excel/Charts/...umnChart1.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
_______


"Derek Locke" <Derek wrote in message
...
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?