Creating a pie-chart that depicts the percentage of how frequently a number appears

[vinestone]

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!

 

[63falcondude]

Delete

 

[63falcondude]

I would make 2 more columns off to the right or on another sheet.

	...	K	L
1		Q1 Answers	Frequency
2		1	1
3		2	4
4		3	2
5		4	2
6		5	2

<tbody>
</tbody>

L2 =COUNTIF(C:C,K2)

Now, highlight L1:L6, Insert Pie Chart​