How do I stop using data source no longer needed for charts?
 

HOW DO I DELETE AN AUTOMATIC LINK which is no longer there?
I have copied a chart from one workbook to create a new workbook. Now it
always says this wkbk contains automatic links to information in another
workbook.

Grace -

You can unlink a chart from its source data. This web page describes
several ways:

http://peltiertech.com/Excel/ChartsH...ChartData.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Grace wrote:

HOW DO I DELETE AN AUTOMATIC LINK which is no longer there?
I have copied a chart from one workbook to create a new workbook. Now it
always says this wkbk contains automatic links to information in another
workbook.

I tried this but must be doing something wrong cause after I make the series
#'s it still asked to update when I copy the chart into a new workbook.

"Jon Peltier" wrote:

Grace -

You can unlink a chart from its source data. This web page describes
several ways:

http://peltiertech.com/Excel/ChartsH...ChartData.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Grace wrote:

HOW DO I DELETE AN AUTOMATIC LINK which is no longer there?
I have copied a chart from one workbook to create a new workbook. Now it
always says this wkbk contains automatic links to information in another
workbook.

Do you have any text that's linked to a worksheet? Axis or chart title,
data label, textbox?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Grace wrote:

I tried this but must be doing something wrong cause after I make the series
#'s it still asked to update when I copy the chart into a new workbook.

"Jon Peltier" wrote:


Grace -

You can unlink a chart from its source data. This web page describes
several ways:

http://peltiertech.com/Excel/ChartsH...ChartData.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Grace wrote:


HOW DO I DELETE AN AUTOMATIC LINK which is no longer there?
I have copied a chart from one workbook to create a new workbook. Now it
always says this wkbk contains automatic links to information in another
workbook.