copying charts from one Excel file to another

[Anchundan]

I've just copied a lot of data from one excel sheet, to another, in a new workbook. The charts didn't copy across, so I used the arrow in the drawing toolbar to select them all (there are 51), copied, and pasted to my new workbook.

All looks good, however, every single chart has a link back to the original workbook, which I didn't want. So now it asks me if I want to update the information every time I open this new file.

Each chart is an X-Y type, with two data series, located in exactly the same cells as the original workbook.

Is there a quick way to remove all these links back to the original workbook?

Here is an example :

Series 1 - X Values : ='E:\Work\MPI\MPI 2006-12-09\[Weight and Buoyancy7.xls]Buoyancy'!$C$35:$C$43

should be :

Series 1 - X values : ='Buoyancy'!$C$35:$C$43

I'd hate to change all this manually - it would take me hours!

 

[Anchundan]

Unfortunately, that hasn't worked. All I see now is the formulas in all the cells. But the charts remain the same.

If I want to change the source data x and y values in the charts, I still have to manually click each chart, go to Source Data, click on each series, and change the X Values nad Y Values here.

 

[Anchundan]

That works perfectly - thanks!