| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
|
#3
|
|||
|
|||
|
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. |
|
#4
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel data query locks source file | Excel Discussion (Misc queries) | |||
| Insert excel data source into word doc using currency symbols | Excel Worksheet Functions | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
| Formulas in source data | Charts and Charting in Excel | |||
| Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel | |||
Linear Mode
