victorsales
New Member
- Joined
- Nov 6, 2012
- Messages
- 13
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!
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!