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.

Hi,

You will find suggestions here
http://peltiertech.com/Excel/ChartsH...ChartData.html

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"StephanieH" wrote in message
...
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.