Transferring chart data from one worksheet to another

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

Guest

I am copying and pasting data and charts from one worksheet to another. I
then do a find and replace on the data to change one of my variables.
However, the charts do not update to the new worksheet, but rather keep the
previous worksheet data (ex. 1st worksheet is CFBG, new worksheet is MKTG.
Source data stays =CFBG!$B$1 when I want it to change to =MKTG!$B$1).
I have 10 more worksheets to go. Any ideas how I can quickly change the
source data from one worksheet to another? I tried the Find and Replace but
couldn't get it to work.
Also, Paste Special won't work.
Thanks
 
You have to copy the charts and data in one operation. If you copy a chart
separately, it maintains its link to the original data.

- Jon
 
Back
Top