how do redirect

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey people i have 48 graphs with external data sources and i would like to
know how i can rediect them to a new address other the editting all of the
series???

thanks
Gus
 
If the new external data sources have the same worksheet names and data in
the same cells, then you can use Edit menu > Links to redirect the links to
the new workbooks. If not, you will have to edit the chart or series source
data.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using a Cell Value to Adjust a Data Series for a Plot 2
Timer not working 1
2 stacked, one discrete 1
graph column line graph with two axes 1
Graph with 2 X axis - data series display limit? 2
Layering Chart Types 4
Insert multiple .dat files into one pdf without losing color of their graphs 0
Data disappears when I edit the chart. 1

Back
Top