that's great, very useful. thank you

"Jon Peltier" wrote:

I've built a small utility that manages simple changes for you. To change a
column, change (for example) $A$ to B. If you just change A to B, it may
also change the letter A in a sheet name.

http://peltiertech.com/Excel/Charts/ChgSrsFmla.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Tuxla" wrote in message
...
Hi
I have over 30 charts where I need to change the source data and it's
taking
ages doing it manually, especially as each chart has 3 or 4 series. Is
there
an easy way of doing this, please?
I've tried find and replace, but that doesn;t work
Thanks