Select a cell someplace and then use one of the built-in functions.
Hopefully the COUNTIF function is one of the built-in ones. (not at my Mac right now so cannot be more definite)
Find the cells with Males & Females, you will have to do two different Countif statements and then use the answers to build the Pie Chart.
My spreadsheet consists mainly of columns of choices of yes or no/ male/female etc..
In my first column is gender, so male or female as an option which I used a "pop up menu" to enter all responses. I want to find out the total ammount male and females there are within my column and make a pie chart out of it. Can numbers do that?
I've been trying to find the answer or thinking about the formula for hours now,
I look forward to your wise replies