| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I edit replace source data links for a chart?
I changed the name of a document which was connected as link to some charts
in another spreadsheet. Now the charts are blank becasue they are looking for the spreadsheet with the name that does not exist anymore. How do I change the source data without going into each chart and doing it by hand? Thanks! |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I edit replace source data links for a chart?
You could try Edit menu Links, if another workbook has the right structure
(i.e., same sheet names and data ranges as the missing file). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "LK" wrote in message ... I changed the name of a document which was connected as link to some charts in another spreadsheet. Now the charts are blank becasue they are looking for the spreadsheet with the name that does not exist anymore. How do I change the source data without going into each chart and doing it by hand? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I view and edit the source code for a Chart in Excel 2003? | Charts and Charting in Excel | |||
| How do you link chart source data when you copy the chart? | Charts and Charting in Excel | |||
| Edit Links: Changing links on a protected worksheet | Excel Discussion (Misc queries) | |||
| Using Find & Replace to edit cell references in links | Excel Discussion (Misc queries) | |||
| How do I automatically update chart source data links for moved fi | Charts and Charting in Excel | |||
Linear Mode
