VBA copied chart keeps on pointing to original data, VBA relinking charts to nesource data

[dastr]

Dear all,

I have a chart linked to a source data on sheet "Pattern". I want to copy and paste the chart and the table on multiple sheets. I have managed so far to create the multiple sheets in VBA but when I copy and paste the table and charts on the newly created worksheets, I either have all the newly pasted charts linking to the original data
(table) on worksheet "Pattern" or I paste the tables but not the charts.

Can someone help? Ideally I would like to paste a chart and a table on a new worksheet (say WS "English") and have the chart on WS English being linked to the table on the same worksheet?

Here I am attaching the example.
Thanks in advance.

Please Login or Register  to view this content.

[dastr]

I have also pasted the code, thank you very much!

[AB33]

dasr,
I did not want to ignore you, but I am not familiar with charts. I have tried this code, but does not work. I hope others would help you.

Please Login or Register  to view this content.

[dastr]

thanks for trying and the quick response.

[Sean Thomas]

Hi, try this

Please Login or Register  to view this content.

[dastr]

thanks Sean!!

Hi, try this

Please Login or Register  to view this content.