You can do it the hard way: Copy a sheet of data, change the data, copy a
chart, and change the chart's links.

Or you can do it the easy way: Copy a sheet with data and chart, change the
data, and watch the chart automatically update.

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


"Robert H" wrote in message
oups.com...
I have a macro that copies elements of a Template worksheet to create
new sheets. The new sheets are for the most part identical except that
the data values are different. I need to copy a chart that is on the
template sheet to the other sheets and have it pick up the same
sources, just with the new sheetname. Just copying the chart and
pasting results in a chart referring back to the template sheet.

Any Ideas where I should start?

Thanks
Robert