pivot charts with 3 data items

[Dabulughod]

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

 

[Mark W.]

To begin you'd better organize your data into 1st Normal Form (1NF) as shown below...

{"Room"," Student","Test Nbr","Score"
;301," A",1,20
;301," A",2,25
;301," A",3,30
;301," B",1,15
;301," B",2,-10
;301," B",3,10
;301," C",1,25
;301," C",2,10
;301," C",3,10
;401," X",1,10
;401," X",2,10
;401," X",3,25
;401," Y",1,15
;401," Y",2,-15
;401," Y",3,5
;401," Z",1,10
;401," Z",2,40
;401," Z",3,30}