Excel Charts - How to copy the charts to a new range within the same worksheet?

[victorsales]

Hi All,

I have an excel file with financial information that shows the divisions' monthly performance (actuals, budget and variances, 100 rows : 40 columns).

The file contains 20 identical worksheets but each one is related to a different division.

Built inside every worksheet I have 12 charts linked to the financial data acting as a dashboard.

I was asked now to convert for every division all £ into € and create charts linked to the new range, so effectively having two sets of charts 12 in £ and 12 in €.

The Euro section which starts on row 125~225 is already linked to the £ above times the ex rate and works.

Now I would like to copy and paste the 12 charts from above to the new range but the charts keep their reference to the £ section. I want to avoid having to re-link everything manually.

I have googled around and there are instructions on how to copy the tabs and rename them but it doesn't solve my problem as I need the charts within the same worksheet. I want to avoid having 40 worksheets in the file.

Any ideas on how to copy the charts to the new range will be really appreciated.

Thanks for your help!