0 Replies Latest reply: Jun 20, 2013 4:10 PM by Shruthi Anantharamaiah RSS

    Include Chart in Pivot table

      I have certain number of students who gave their responses to specific questions, and I need to display the total number of responses as a color coded chart within the pivot table. Here is the sample of how I need it. Could someone help me with this?

      The color code for each response is as below:

      Response

      Color Code

      Excellent

      Green

      Good

      Yellow

      Average

      Red

       

      Required Pivot table with Chart

      Questions              Total No.Students       Responses

      Question1                             25               chart1.JPG(say 5 of them answered average, 8 good and the rest answered average)

      Question 2                            15               chart2.JPG