Graph data series formulas: How to global-change all sheet reference to formula
 

2007 up to date

Regular sheet formulas can be searched/replaced easily.

That said, How can I global-change all Chart data sheet references in the respective formulas?

TIA EagleOne

Graph data series formulas: How to global-change all sheet reference to formula
 

This utility works for most changes you will need to make:
http://peltiertech.com/Excel/Charts/ChgSrsFmla.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


wrote in message
...
2007 up to date

Regular sheet formulas can be searched/replaced easily.

That said, How can I global-change all Chart data sheet references in the
respective formulas?

TIA EagleOne