Changing chart reference to active sheet when copied

Hi all,

I hope someone can help. I am copying all information stored in sheet MasterReport to new tabs by macro. Everything is transfered. But unfortunately I have charts which are still referencing to the original sheet. Please, could someone tell me how code can change the reference of the chart to the active sheet. Also the chart title (referenced to a cell) should change to the active sheet. I have tried the macro recorder but unfortunately the created code destroys the stacked column charts.

I have attached a sample file containing the code in Modul 1.

Many thanks,

fxmu

Many many many thanks! This is great!

fxmu