G
Guest
I have a worksheet that contains one chart and and the chart's source data in
rows and columns in that sheet. If I select the worksheet and then move it
to another workbook, the copied chart's source data still references the
worksheet in the original workbook.
For example, in Book1!Sheet1, the chart source data is 'Sheet1'!$A$1:$B$6.
When I copy the sheet to Book1, the chart source data is
'[Book1]Sheet1'!$A!1:$B!6.
Is there a way to have the source data in the copy reference the new
workbook or do I need to programmatically adjust the source data after
copying the sheet?
rows and columns in that sheet. If I select the worksheet and then move it
to another workbook, the copied chart's source data still references the
worksheet in the original workbook.
For example, in Book1!Sheet1, the chart source data is 'Sheet1'!$A$1:$B$6.
When I copy the sheet to Book1, the chart source data is
'[Book1]Sheet1'!$A!1:$B!6.
Is there a way to have the source data in the copy reference the new
workbook or do I need to programmatically adjust the source data after
copying the sheet?