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

[EagleOne]

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

 

[Jon Peltier]

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

- Jon