please help !

C

chico

I have a table with two columns. First is people names and second is gender
(M,F).
I am trying to make a pie witch will show me what is the precentage of males
and females from total number of peoples (650).
please help!!!
 
A

Andy Pope

Hi,

You need to summarize the data and then create a pie chart of that.

=COUNTIF(B1:B650,"m")
=COUNTIF(B1:B650,"f")

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup value in table from value in report query 13
Layered charts 2
How do I create a chart out of a list, instead of number values? 3
Create query that sums up categorical data 2
IIF in a report Footer 3
COUNTIF Question 12
display total in stacked column chart 3
Demographics 6

Top