Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question
    
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. –  reannual Sep 20 '13 at 7:48
add comment

2 Answers

up vote 3 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

share|improve this answer
    
Works in Excel, too (at least 2007). –  Gelatin Aug 2 '10 at 2:18
    
Thank you! It worked perfectly! –  Ryan Aug 2 '10 at 3:54
add comment

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.

share|improve this answer
    
Right. I guess the issue is more that there isn't a second set of values. –  Ryan Aug 1 '10 at 22:55
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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