I distributed a survey online and received the answers in an Excel spreadsheet. I would like to make a pie chart out of some of the closed option answers. For example, one of the questions was gender. Is there a way I can create a pie chart that shows the percentage of male vs. female?

Given 30 male and 20 female responses, the pie chart would be cut 60/40, with each part appropriately labeled.

EXAMPLE

male
male
female
male
female
female
male
male
male
female

I would like that to create a pie chart cut 60/40.

  • Just to provide some context: What you want is a frequency distribution. While spreadsheets can deliver this with a few extra steps (as detailed in Bavi_H's response), statistics software (spss, sas, etc.) produce these sorts of descriptive statistics at the click of a button. Just something to consider, if you need to do a lot of this sort of work. – brokkr Sep 20 '13 at 7:48
up vote 4 down vote accepted

You'll first need to count the number of male and female entries, then make a pie chart out of that data.

In OpenOffice.org Calc I was able to use the COUNTIF function to count the entries, then select the counts and make a pie chart from that. It should be similar in Excel.

enter image description here

  • Works in Excel, too (at least 2007). – Gelatin Aug 2 '10 at 2:18

If you choose your x and y values and create a pie chart using the graph option and selecting pie chart, Excel should do the rest for you.

  • Right. I guess the issue is more that there isn't a second set of values. – Ryan Aug 1 '10 at 22:55

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.