Removing links from charts

Lee Attlesey · May 21st, 2002, 04:53 AM

I have recently created a report which links data from various pivot tables (in the same workbook).

From this I created a couple of charts to visualise the data in the same worksheet. I have created a macro to copy the worksheet containing my report into a new book and to change the linked cells from a formula to a value.

However I still have a third chart which links directly back to a pivot table in the origional workbook and I'm always asked if I want to update the chart when opening the new workbook.

Is there any way I can remove the link to the chart like in cells, i.e. copy and paste as value?

sen_edp · May 21st, 2002, 05:28 AM

I found this in internet

Why not take a picture of the chart (Shift+Edit / Copy Picture) , paste the
picture somewhere and delete the live chart (or re-use it for some other
data).

Bill Manville
MVP - Microsoft Excel
Oxford, England

does it helps ?

Lee Attlesey · May 21st, 2002, 07:32 AM

Yes that will come in use, thanks Andreas.

May 21st, 2002, 05:28 AM	#2
sen_edp Board Regular Join Date: Mar 2002 Location: Hellas Posts: 553	I found this in internet Why not take a picture of the chart (Shift+Edit / Copy Picture) , paste the picture somewhere and delete the live chart (or re-use it for some other data). Bill Manville MVP - Microsoft Excel Oxford, England does it helps ? __________________ Best Regards Andreas

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 21st, 2002, 04:53 AM	#1
Lee Attlesey New Member Join Date: May 2002 Location: Cambridge, UK Posts: 22	I have recently created a report which links data from various pivot tables (in the same workbook). From this I created a couple of charts to visualise the data in the same worksheet. I have created a macro to copy the worksheet containing my report into a new book and to change the linked cells from a formula to a value. However I still have a third chart which links directly back to a pivot table in the origional workbook and I'm always asked if I want to update the chart when opening the new workbook. Is there any way I can remove the link to the chart like in cells, i.e. copy and paste as value?

May 21st, 2002, 07:32 AM	#3
Lee Attlesey New Member Join Date: May 2002 Location: Cambridge, UK Posts: 22	Yes that will come in use, thanks Andreas.