please help !

  • Thread starter Thread starter chico
  • Start date Start date
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!!!
 
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

How do I create a chart out of a list, instead of number values? 3
different makers in one chart 1
Pie Chart 2
How do I create stacked columns in xcel rather than side-by-side 1
IIF in a report Footer 3
Pie Chart will only Display one slice - 100% 1
Cluster AND Stacked Bar chart 1
Query Problem 2

Back
Top