I imagine that this is a relatively simple thing to do, but I'm not too skilled when it comes to using excel. I'm conducting a public survey which involves 7 multiple choice questions and I'm using excel to record and interpret this data. In the top row I list the number of questions (1-7) and in the left-hand column the survey numbers. What I would like to be able to do is to create a pie chart for each question that depicts the percentage of how frequently a number appears in each question column. For example, question one has five potential multiple choice answers, 1-5. Let's say the answers for a given number of surveys were 4, 3, 2, 2, 4, 1, 2, 5, 3, 2. I would like to be able to have a pie chart that is divided into 5 sections that show the frequency that each number is listed in a percentage format. In that example obviously 2 is the most common number and would have the highest percentage. I have attached an image of my current spreadsheet design with some example numbers under question one to show how I plan to format things. Please let me know how to go about creating such a pie chart for each question, and also if you have any recommendations for a better way I could design this spreadsheet for ease of use.
Thanks!
