Copying charts using relative referencing

[Ant]

I have created a spreadsheet with several imbedded charts. The sheet name
is “Jan” I now need to copy the worksheet to 11 other sheets “Feb”, “Mar”
etc, however when I do this the charts still get the data from the “Jan”
sheet. Is there a way of copying the charts relatively so that when on the
“Feb” sheet they pick up the data from the “Feb” sheet. I know I can go
into source data and re link them but with 8 complex charts X 12 worksheets
I am guessing there must be a quicker way. Any suggestions appreciated.

 

[Earl Kiosterud]

Ant,

It's probably too late for this, but if you copy the entire sheet, the chart
remains linked to its own sheet.

A macro could do it, but my not be worth the trouble for you if this is a
one-tie thing.