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:
Required Pivot table with Chart
Questions Total No.Students Responses
Question1 25 (say 5 of them answered average, 8 good and the rest answered average)