Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Make a Gender Pie Chart in Excel (2 Easy Ways)

Today we will discuss how to make a gender pie chart in Excel. A male-female pie chart or a gender pie chart illustrates a proportional numerical relationship between men and women by dividing a circle into segments. A gender pie chart shows the qualitative data or frequency distribution of males and females for a certain instance. These charts are very useful for different sociological surveys, reports, and infographics.

Overview of Making a Gender Pie Chart in Excel


Download Practice Book

You can download this practice book while going through this article.


2 Suitable Methods to Make a Gender Pie Chart in Excel

In this article, we will demonstrate with examples how we can make pie charts to show gender distribution in Excel. We can create a gender pie chart showing the percentage or ratio of male and female using the Percentage option from the Number group in Excel. Also, we can make a gender pie chart using the COUNTIF function for certain scenarios.


Method 1: Using Percentage of Numbers to Make a Gender Pie Chart in Excel

In this method, we will initially calculate the percentage of males and females in the dataset. This chart will help to understand the relative proportion of male and female for a certain instance. Here in the worksheet, the number of males and females in some departments of a university, along with their establishment year, is given. Initially, we will find out what percentage of the people are males and what percentage of members are females. Then, we will create a gender pie chart with the data. Simply follow the steps below:

Steps:

  • To begin, select the cell where you want to put the percentage of males. We are selecting cell G5.

Selecting a Particular Cell

  • Secondly, enter the formula in the cell:
=SUM(C5:C14)/SUM(C5:D14)

Entering SUM function into the Selected Cell

  • Then, press Enter, and you will see the proportion of males in the total number of people. Here in this dataset, the ratio of males to the total number of people is 0.53233831.

Putting the Value of Ratio in a Cell

  • Similarly, enter the formula in cell H5:
=SUM(D5:D14)/SUM(C5:D14)

Entering a Formula with SUM function into the Selected Cell

  • Then, press Enter, and you will get the proportions of females in the total number of people.

Putting the Value of Ratio in a Cell

  • Now, select cell G5:H5.

Selecting a Range of Cells for Percentage Conversion

  • Then, go to the Number group and see the options.

Navigating to the Number Group

  • After that, from the menu bar, select Percentage.

Selecting the Percentage Option from the Number Group

  • Then you will see the percentage of males and females in the total number of people in cells G5 and H5 respectively.

Getting the Percentage Value to Make a Gender Pie Chart in Excel

  • After that, select cell G4:H5 and go to the Insert.

Selecting the Insert Tab to Make a Gender Pie Chart in Excel

  • Then, look for the Pie Chart icon in the Charts group and click on it.

Selecting the Pie Chart Option to Make a Gender Pie Chart in Excel

  • Moreover, you will see different types of available pie charts. You can choose any pie chart from there. We are selecting one from the 2D Pie.

Selecting a Suitable Pie Chart

  • Now, you will see the gender pie chart showing the distribution of males and females.

Making a Gender Pie Chart in Excel

  • Subsequently, you can change the title of the pie chart and add a suitable title. Click on the Chart Title and add any title of your choice.

Changing the Title of the Gender Pie Chart

  • Then, to see the percentage of males and females inside the pie chart, click on the plus (+) icon and select Data Labels.

Selecting Data Labels to Show Percentage in Gender Pie Chart in Excel

  • Finally, you will see the gender pie chart showing the percentage of males and females in the dataset.

Creating a Gender Pie Chart in Excel

Read More: How to Show Percentage in Excel Pie Chart (3 Ways)


Method 2: Applying COUNTIF Function to Make a Gender Pie Chart in Excel

In this method, we will use the COUNTIF function to calculate the exact number of males and females in a dataset and make a gender pie chart from it. This will allow the users to have an edge in Excel to make a gender pie chart. Here in the worksheet, we have the names, ages, departments, and genders of multiple students of a university. We want to make a gender pie chart from the dataset. Just follow the steps below.

Steps:

  • To begin, select the cell where you want to put the number of males. We are selecting cell G5.

Selecting a Particular Cell

  • then, enter the formula into the cell:
=COUNTIF(E5:E14,"Male")

Entering a Formula into the Selected Cell

  • After that, press Enter, and you will see the number of males in the dataset.

Putting the Value in a Cell

  • Similarly, select cell H5 and enter the formula:
=COUNTIF(E5:E14,"Female")

Entering COUNTIF function into the Selected Cell

  • Then, press Enter to see the number of females in the dataset.

Putting the Value in a Cell

  • After that, select cell G4:H5.

Selecting a Range of Cells to Make a Gender Pie Chart in Excel

  • Then, go to the Insert.

Selecting the Insert Tab to Make a Gender Pie Chart in Excel

  • Subsequently, look for the Pie Chart icon in the Charts group and click on it.

Selecting the Pie Chart Option to Make a Gender Pie Chart in Excel

  • Then, select a suitable pie chart from the available options. We are selecting one from the 2D Pie.

Selecting a Suitable Pie Chart to Make a Gender Pie Chart in Excel

  • Next, you will see the gender pie chart showing the distribution of males and females.

Making a Gender Pie Chart in Excel

  • Now, change the title of the chart by clicking on the Chart Title.

Changing the Title of the Gender Pie Chart

  • Then, to see the exact number of males and females inside the pie chart, click on the plus (+) icon and select Data Labels.

Selecting Data Labels to Show the Exact Numbers in Gender Pie Chart in Excel

  • Finally, you will see the gender pie chart showing the number of males and females of the dataset.

Creating a Gender Pie Chart in Excel

Read More: How to Make a Pie Chart in Excel [Video Tutorial]


Conclusion

In this article, we have talked in detail about how to make a gender pie chart in Excel. This article will allow users to use Excel more efficiently and effectively. If you have any questions regarding this essay, feel free to let us know in the comments. Also, if you want to see more Excel content like this, please visit our website, Exceldemy.com and unlock a great resource for Excel-related content.


Related Articles

Md. Abu Sina Ibne Albaruni

Md. Abu Sina Ibne Albaruni

This is Abu Sina, a fresh Engineering Graduate and currently an Excel and VBA content developer at SOFTEKO. I did my bachelor’s in Mechanical Engineering from BUET. My passion is to build new skills, gather experience and apply them to optimize and balance various trade-offs for a better future. Besides, I am fond of travelling, hanging out with friends, and watching movies.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo