Modify Series "Refers To" in XL07

[Jbentley]

Hi,

In XL00 & 03 I could open the script editor and do a find & replace to modify series value references for all charts in a sheet.

This was very useful when developing templates and then charting a variety of metrics.

Is there a way to 'find and replace' embedded chart references in XL07?

Preferrably non VBA, but can use code if need be....

[Andy Pope]

A free utility
http://peltiertech.com/WordPress/how...ries-formulas/

[Jbentley]

Thanks Andy!
That worked a treat and saved me a ton of time.
Couldn't get the utility to work with more than one selected chart at a time, which is a pity, but overall a fanastic improvement on manual series editing.

Cheers!