Thread: Graph data series formulas: How to global-change all sheet reference to formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
  
Posts: 6,582
Default 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


Reply With QuoteReply With Quote