Charting Using Defined Names
 

I have a workbook that contains numerous charts. I am updating the chart
trends by manually editing the formula that define the trend data.

I would like to create defined names, and through VBA, update the definition
for the ranges.

HOW do I incorporate a defined name into the formula for the trend?

Charting Using Defined Names
 

You probably don't need VBA:

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
_______


"Posse John" wrote in message
...
I have a workbook that contains numerous charts. I am updating the chart
trends by manually editing the formula that define the trend data.

I would like to create defined names, and through VBA, update the
definition
for the ranges.

HOW do I incorporate a defined name into the formula for the trend?