Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: pivot charts with 3 data items

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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}

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •