I am creating a sheet with demographics for my parish. I have a column with "M/F" and in the rows assigned to specific names, I have placed an M if that person is Male and an F if that person is Female. I would like to show the ratio between males and females in a pie chart. I don't know too much about spredsheet software. How can I go about showing these values/ratios in a pie chart?
MacBook, Mac OS X (10.5.6)
You can use the countif() function to count "M" and "F" in a different table, then graph that data:
the table "Data" contains the gender information which is summarized in the table "Summary"
Table summary cells are as follows:
B2=COUNTIF($'M/F', "="&LEFT(A2,1))
B3=COUNTIF($'M/F', "="&LEFT(A3,1))
To graph you select the range B2 to B3 (the data portion) of the Summary Table then select the Pie chart from the Graph tool
Thanks Wayne. You've done exactly what I wanted. However, I'm fuzzy on the steps.
Am I creating a new table or is there a table summary already in one of the menus?
Can you lead me through what you did step-by-step?
The Numbers User Guide, found under help, is surprisingly easy to work through and understand, so I'd suggest that as a first step. However, let me lead you through a couple of basics. 🙂
It's very simple to create a new table to summarize your main table, as Wayne did above. Click "Insert", then "Table", and you'll get to choose from several different kinds. Wayne's is Plain, with no headers. You might want a left header for your legend ("Male", "Female"). Then use the COUNTIF formula to point it to your column listing M of F for your congregation.
Once you've got your totals, just drag your pointer around the data you want to graph (the totals and the "Male"/"Female" legend), click the "Charts" icon at the top of the menu bar, and that should get you started. You'll get a box with things you can tweak (the "Inspector" window) to adjust the legend, the colors, etc.
Vince
You should create two tables using the Table Insert tool (like Vince said):
Then you can give the tables names by double clicking the name in the Sheets list (left):
Then you can enter the data (or copy and paste from your existing table). Then enter the formulas I provided previously, and graph. There is a user guide and lot's of Apple-provided movies (http://support.apple.com/videos/#productivitysoftware) that can help you get through the basics.
I hope this helps.
Wayne
Thank you both for your help. I was able to piece it together and eventually I got my pie chart. Seems like it should've been easier to do, but I really appreciate it. I will look at that link you put down Wayne. I probably need spreadsheet for dummies though...
Thanks again.
Well, there are such books. I bought one when I first got iWork:
http://www.dummies.com/store/product/iWork-09-For-Dummies.productCd-0470433728.h tml
However, althought not officially "for Dummies", I find I keep going back to this one for guidance. A much better book, IMHO, leading you step by step from the simple to the complex:
http://www.amazon.com/iWork-09-Missing-Josh-Clark/dp/0596157584/ref=sr_1_1?s=boo ks&ie=UTF8&qid=1317531973&sr=1-1
Congrats on getting your project to work, and I hope you'll come back if you have any other questions.
Vince
How do I show the value of Males and Females in a Pie Chart?
