An easy way to changing refrence on several charts
 

How do I change referencec/range in a quick way on several chartssheets i a
woorkbook

An easy way to changing refrence on several charts
 

I designed this utility to work on embedded charts. Perhaps you could adapt
it to chart sheets.

http://peltiertech.com/Excel/Charts/ChgSrsFmla.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Henning" wrote in message
...
How do I change referencec/range in a quick way on several chartssheets i
a
woorkbook

An easy way to changing refrence on several charts
 

Tried your ChgSrsFmla and seem to be the solution I am looking for. However I
am not a VBA expert and do not know how to adabt it to work with all
Chartssheets in woorkbook

"Jon Peltier" skrev:

I designed this utility to work on embedded charts. Perhaps you could adapt
it to chart sheets.

http://peltiertech.com/Excel/Charts/ChgSrsFmla.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Henning" wrote in message
...
How do I change referencec/range in a quick way on several chartssheets i
a
woorkbook