Transferring chart data from one worksheet to another

D

DaddyO

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
 
J

Jon Peltier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embed the same Excel multiple times 0
how to copy XY charts into new worksheet? 1
Create a chart from a table in word thats dynamic 0
How to copy files from Onedrive account to another 2
Automatically sending multiple parts of text from one word doc to another - is possible. 0
how to copy sheet with charts without link to original data 6
Modify a value in a dependent worksheet and then update back to thesource worksheet. 3
Syncing between source worksheet and dependent worksheets 0

Top