Remapping Chart Source Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top