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