ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   how do redirect (https://www.excelbanter.com/charts-charting-excel/79976-how-do-redirect.html)

Andrew Hansen

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

Jon Peltier

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





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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com