Find & Replace in Charts

teknovision · Jun 14th 2004

Hi there!

I have about 15 charts in one Excel spreadsheet that I need to change the source data for, the master spreadsheet has been updated.

I cannot seem to do a Find & Replace, is there another way other than having to manually go through each charts source data?

Cheers for any help,

Phil

Dave Hawley · Jun 14th 2004

Hi Phil

One way would be to use something like =INDIRECT("'Master'!A1") to reference the source data range in each chart. Where A1 would house a source address like: 'Data'!A1:A100

The just change the address in range A1 of Data.

teknovision · Jun 14th 2004

More Detail

I think I forgot to mention that there are 15 charts generating data from 15 separate worksheets.. . Dave, from your example that would still mean that I would need to change source data right?

Cheers,

Phil

Find & Replace in Charts

Participate now!

Share