Pie Chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
Back
Top