Hello,
I have several worksheets, with the same structure. I added a new chart in one worksheet and copied it. I then pasted the chart in another same structure worksheet hoping that the series would update with the new data. What happens instead is the chart is 'linked' to the old worksheet.
Is there another way to copy/paste the chart in different worksheet quickly and avoid to update manually the data series??
Many Thanks
Pitto
Here's a workaround, you could try using the camera tool but you have to select the cells behind the chart for it to copy the chart
http://www.j-walk.com/ss/excel/odd/odd04.htm
oldchippy
-------------
If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks