How do I edit replace source data links for a chart?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LK - 08 Oct 2007 20:56 GMT

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 to this Message

Jon Peltier - 09 Oct 2007 19:19 GMT

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
_______

>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
[quoted text clipped - 3 lines]
> the source data without going into each chart and doing it by hand?
> Thanks!

Reply to this Message