#1   Report Post  
Posted to microsoft.public.excel.charting
Andrew Hansen
 
Posts: n/a
Default how do redirect

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
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default how do redirect

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
_______

"Andrew Hansen" wrote in message
...
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Redirect formulas to a new sheet in workbook PA New Users to Excel 1 February 11th 06 10:59 PM
redirect from worksheet PeterAtherton Excel Discussion (Misc queries) 0 July 29th 05 12:06 AM


All times are GMT +1. The time now is 08:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"