You could try this utility, which alters the series formula:

http://peltiertech.com/Excel/Charts/XYAreaChart2.html

If the chart's data is contained on the same sheet that the chart is
embedded in, the easiest way to make another chart like it with different
data is to copy the entire sheet, then change the data on the copy of the
sheet. The chart will update as the data is changed.

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


"EBB" wrote in message
...
Is there a way to access the code (VBA?) for a Chart created in Excel
2003? I
have generated a complicated Chart or graph which I want to then "Copy"
and
modify to make several more which access different spreadsheets. It is
cumbersome to click in the Toggle box for the data ranges for X and Y.
Instead, I was hoping there might be a way to use Search and Replace to
change the text describing the data ranges.