Copying and pasting charts in different worksheets

[pittopitto]

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

[oldchippy]

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