Copying charts using relative referencing

Giganews Newsgroups
Subject: Copying charts using relative referencing
Posted by:  Ant (ant.sne…@virgin.net)
Date: Sat, 22 May 2004

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.

Replies