|
||||||||||||||||||||
|
|||||||||||||||||||||
|
|||||||
 |
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
06-16-2005, 04:05 PM
|
|||
|
|||
|
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
06-17-2005, 08:05 PM
|
|||
|
|||
|
Re: How do I stop using data source no longer needed for charts?
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
06-20-2005, 11:05 AM
|
|||
|
|||
|
Re: How do I stop using data source no longer needed for charts?
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
06-21-2005, 03:05 PM
|
|||
|
|||
|
Re: How do I stop using data source no longer needed for charts?
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. >>
|
|
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
