Hi,

I am wondering if anyone knows how to find and replace on Excel charts??

For example I have the following

'Sheet1' Worksheet on Workbook 1
'Results' Worksheet on Workbook 1

'Sheet 2' Worksheet on Workbook 2
'Results' Worksheet on Workbook 2

I have copied a chart from 'Sheet 1' on Workbook 1 to 'Sheet 2' on Workbook 2.

How can I replace the references on the Chart to 'Sheet 1' on Workbook 1 to 'Sheet 2' Workbook 2?

I have about 25 charts I am looking to do this for so I am looking on tips that would allow me to do this quickly...Possibly a macro which works.

Many thanks in advance.

Sagar