moroandrea
08-13-2011, 02:34 PM
Hi There,
As a pivotchart cannot represent two views of the same data source unless two pivot tables exist on the spreadsheet, I've created the two object in my file.
However, as the data range I'm interested in is the same for the two charts, I was wondering if it exists an easy way to select the same range in the rowlabel field.
I've tried many different approach, but for one reason or another I get always a runtime error.
In the last attempt, I got a Type mismatch error when trying to access to the Visible property of the individual PivotItem.
And yes, I tried to disable the auto order as suggested by many post around the net, which in many case resulted to be the problem.
I'm using excel 2007, which I'm not sure is the cause of the problems.:banghead:
Can you help?
Thanks
Andrea
As a pivotchart cannot represent two views of the same data source unless two pivot tables exist on the spreadsheet, I've created the two object in my file.
However, as the data range I'm interested in is the same for the two charts, I was wondering if it exists an easy way to select the same range in the rowlabel field.
I've tried many different approach, but for one reason or another I get always a runtime error.
In the last attempt, I got a Type mismatch error when trying to access to the Visible property of the individual PivotItem.
And yes, I tried to disable the auto order as suggested by many post around the net, which in many case resulted to be the problem.
I'm using excel 2007, which I'm not sure is the cause of the problems.:banghead:
Can you help?
Thanks
Andrea