Remapping Chart Source Data

[Guest]

I have tab Chart1 with 30 charts on it all mapped to data on tab Sheet1. I
have tab Sheet2 with data formatted in the exact same manner and would like
to duplicate the charts forming tab Chart2. Find/Replace function does not
work in this manner and I am unsure how to fix this without drilling into
each chart and changing them all manually (a grueling process). I was hoping
someone might be of assistance...

Thanks in advance for your help,

Jason

 

[Guest]

Not sure why you would want two identical sheets, but could you save your
file with a different name and then have TWO identical files? Then
copy/paste the two sheets from one into the other?

Bruce

 

[Debra Dalgleish]

Jon Peltier has instructions for remapping the series in a chart:

http://www.peltiertech.com/Excel/Charts/ChgSrsFmla.html

At the bottom of the page, there's a sample file you can download, to
make the process easier.