Pasting charts to other worksheets

[prrls05]

Hi All,

I have a simple problem. I have many worksheets which all contain data in the first four columns. I want to be able to create a chart (a scatter chart) in the first worksheet which plots the data on that worksheet and then format it how I want it to look. This I can do.

Next, I want to copy and paste that graph into all the other worksheets, but have the pasted graphs display the data in that worksheet.

As it stands, in Excel 2010, all the pasted graphs keep showing the data in the original worksheet irrespective of which worksheet I now have them in. This seems to be different to older versions of Excel and is very annoying and has to be changed by hand which is very time consuming.

How can I make charts that don't have the worksheet name in the cell reference, or how can I paste a chart so that is updates the references to the same row and column but in the new worksheet?

I know I could copy and paste the entire worksheet and then manually copy the new data into that copy of the worksheet - but that is not a real solution to this problem.

Thanks,

David

 

[Steve=True]

Hi prrls05,

Welcome to the forums.

This works the same in Excel 2007.

My work around is to make a copy of the worksheet by right clicking on the worksheet tab and making a copy of it. NOT copying the data within the sheet, but copy the whole sheet from the worksheet tab.

Hope this helps.

Steve=True
www.exceldashboardtemplates.com

 

[Steve=True]

Here is a more detailed description of what I described:

http://www.exceldashboardtemplates.com/?p=807


Steve=True