Aardvark

you would have to do the sum of the countries in a table, use countif then graph that

Okay will look into this thanks.

I can help you with this. Two questions- 1. What version of Excel? (2007?) 2. I'm assuming there is one row of data for each survey response, that one column is titled "Country", and that you want to count the number of rows and group them by country and then put that on a pie chart. Is that right?

Hi Dave, I'm using Excel 2007 Mac. I have one column labeled Country, and each row is a survey respondent. So I want to count all the rows that represent each country without eyeballing. There's got to be an Excel trick for this right?

There is indeed. Let me fire up my Mac and I can give you instructions.

Ok I have Excel 2004 for Mac so these instructions should be pretty close, if not exact.

1. Select the entire range of cells for your survey data, including the column headings

2. Go to Data > PivotTable report, which will bring up a wizard.

3. In the wizard, click next until you get to the final step, where it asks you where you want to put your PivotTable. Click "Layout".

4. Drag your "country" column into the "ROW" area.

5. Drag your "Country" column AGAIN into the "DATA" area.

6. Click OK to finish the wizard

(you may also have to click "Finish")

7. You should now have a table listing all the countries, along with the # of responses next to each.

let me know if you've made it this far

(assuming you've made it this far)

8. Click inside the new PivotTable, then go to Insert > Chart.

9. Choose the pie chart style, then click Finish. You should now have the chart you're looking for.

Let me know if you have any trouble!

OMG Dave you are an Excel God! It's funny because a friend of mine recently told me to learn pivot tables but I really had no idea what they were. This is incredible. Honestly I wouldn't have found instructions this clear on the internet. This is the coolest thing ever. Thanks for taking so much time today to help me out! You deserve an Aardvark trophy or something ;)

PivotTables rock, spread the love!