Dabulughod
New Member
- Joined
- Apr 14, 2002
- Messages
- 3
I haven't been able to create a pivot chart that contains 3 items, either each column of data separately in the form of a stacked bar chart, or aggregated as an average.
Is there some limitation to pivot charts? Also, I haven't been able to create a pivot table with 3 data items either: I can do 2, and when I add the 3rd, it treats it as a new category.
Here's what sample data looks like. I'll break the page on "room" and each category will be "student". Then, I'll want to show all rooms' student average.
Room, Student, Score 1, Score 2, Score 3
301, A, 20, 25, 30
301, B, 15, -10, 10
301, C, 25, 10, 10
401, X, 10, 10, 25
401, Y, 15, -15, 5
401, Z, 10, 40, 30
Is there some limitation to pivot charts? Also, I haven't been able to create a pivot table with 3 data items either: I can do 2, and when I add the 3rd, it treats it as a new category.
Here's what sample data looks like. I'll break the page on "room" and each category will be "student". Then, I'll want to show all rooms' student average.
Room, Student, Score 1, Score 2, Score 3
301, A, 20, 25, 30
301, B, 15, -10, 10
301, C, 25, 10, 10
401, X, 10, 10, 25
401, Y, 15, -15, 5
401, Z, 10, 40, 30