Survey Results in Excel Pie Chart
Posted on 2011-10-23
I have online Survey from 10 question, and I exported the results into Excel spreadsheet.
What I need is to create Pie Chart for the 10 questions and for each question the answers is :
2) Very Good
I want to calculate the average answer of each question and show it in pie chart.
first question , 7 answer was Very good + 2 Good + 1 Fair
I need to insert a bar with the question sentence with it's average answer.
How I can do that?
Thanks for any help,,