Pie Chart

[Guest]

I need help in Excel Sheets in making charts. For instance, if there are five people. Serial number 1-5. Next column is gender having values 'M' or 'F' (for male and female). Is it possible to make a pie chart depicting the ratio of men to women. This should be done by taking the values out of the columns(having only character values). This concept has to be applied to a bigger project in which the data is already present.

 

[Tushar Mehta]

Use the COUNTIF functions to calculate the number of men/women. Plot
these numbers (or a fraction calculated based on these totals).

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Jon Peltier]

Pivot tables can also count these items for you.

- Jon