I have already copied the sheets, but then you have to go into each chart as
it still refers back to the original sheet by name. I was looking for a way
to make it automaticaly refer to the sheet it is on.

"Jon Peltier" wrote:

Copy the sheet with the charts and data, then change the data on the copied
sheet.

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


"Keith" wrote in message
...
I have created a worksheet with about 10 charts on it. I want to replicate
it
over a further 11 worksheets (one for each month), but when I do the
charts
always refer back to the original worksheet and I have to chabe each
chart.

Is there a way around this?