Duplicate RowLabel data range between two pivottable

[moroandrea]

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.

Can you help?

Thanks
Andrea

[Aussiebear]

Any reason why you cannot have two names for the defined range? Data1, Data2, and then use Data1 for 1st pivot table & Data2 for the 2nd.

[moroandrea]

Well I can use two different name, but I'm not able to see how I would be able to duplicate the two series across the tables.

Can you please clarify your thoughts?

[moroandrea]

Hello all


Any idea or support is more than welcome.

Thanks
Andrea