andycondor
New Member
- Joined
- Mar 23, 2013
- Messages
- 25
Hello all,
I've got different sheets with data with many columns in each sheet. For my pivot table, I'm after only 2 columns from each sheet:
sheet1:
REGION and OPEN_DATE
sheet2:
REGION and CLOSED_DATE
I've used Pivot Wizard to consolidate ranges, and that works... Shows me Open and Closed values by Region.
My problem is, if original tables get bigger, it does not in the graph, seems like they are linked to specific cells. If I do same by selecting just one table, then it is dynamic. Now, if I select complete tables in both sheets, it does work in terms of following table size, but I cannot get my graph to show same results.
What am I doing wrong in here?
I've got different sheets with data with many columns in each sheet. For my pivot table, I'm after only 2 columns from each sheet:
sheet1:
REGION and OPEN_DATE
sheet2:
REGION and CLOSED_DATE
I've used Pivot Wizard to consolidate ranges, and that works... Shows me Open and Closed values by Region.
My problem is, if original tables get bigger, it does not in the graph, seems like they are linked to specific cells. If I do same by selecting just one table, then it is dynamic. Now, if I select complete tables in both sheets, it does work in terms of following table size, but I cannot get my graph to show same results.
What am I doing wrong in here?
