devo_clubber
New Member
- Joined
- Jul 5, 2005
- Messages
- 7
Hi,
I am trying to copy out a worksheet to a new workbook. This worksheet includes a pivotchart and a pivotable, where the pivottable is the charts datasource.
When i copy the sheet to a “New” book, the chart is no longer linked to the pivotchart and it remains static.
As part of my cloning code I then run this to link the two again:
ActiveChart.SetSourceData Source:=Range("MyReport'!$D$7:$F$14")
which works.
I've a few different reports out there and wanted an automatic method to find out what the sourcedata for the original chart was, Then i could just apply this to the copychart automatically
So I guess I am asking for a getsourcedata command, but cannot find one.
I am working in compatibility mode, but I get the same outcome no matter which mode i work in.
Any ideas?
Cheers
Steve
I am trying to copy out a worksheet to a new workbook. This worksheet includes a pivotchart and a pivotable, where the pivottable is the charts datasource.
When i copy the sheet to a “New” book, the chart is no longer linked to the pivotchart and it remains static.
As part of my cloning code I then run this to link the two again:
ActiveChart.SetSourceData Source:=Range("MyReport'!$D$7:$F$14")
which works.
I've a few different reports out there and wanted an automatic method to find out what the sourcedata for the original chart was, Then i could just apply this to the copychart automatically
So I guess I am asking for a getsourcedata command, but cannot find one.
I am working in compatibility mode, but I get the same outcome no matter which mode i work in.
Any ideas?
Cheers
Steve