I'm in Excel 2000
Is it possible to remove the links from a chart?
I have a workbook with several charts on the first sheet. Those charts are
based on data located in other sheets of that workbook. I want to copy the
sheet with the charts to a new workbook, but I do not want the copied charts
to update. Basically, I only want a snapshot of what we're looking at today
in my new workbook.
I've tried selecting the chart and choosing Copy, Paste Special, Formats,
but that does not remove the links.
Andy Pope - 24 Jul 2007 14:42 GMT
Hi,
You will find suggestions here
http://peltiertech.com/Excel/ChartsHowTo/DelinkChartData.html
Cheers
Andy

Signature
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
> I'm in Excel 2000
>
[quoted text clipped - 12 lines]
> I've tried selecting the chart and choosing Copy, Paste Special, Formats,
> but that does not remove the links.