We need a little more detail. 1. Are you modifying all the charts to use
the same new range or does each chart use a different new range? Is the
data compact, that is, if you choose the chart wizard and look at the Data
Range tab does the Data Range box contain a simple reference like
=Sheet1!$B$2:$E$7?

Thanks,
Shane

"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