Home Â» How to Create a Population Pyramid in Excel

# How to Create a Population Pyramid in Excel

AÂ population pyramidÂ is a graph that shows the age and gender distribution of a given population. Itâ€™s useful for understanding the composition of a population and the trend in population growth.

This tutorial explains how to create the following population pyramid in Excel:

### Example: Population Pyramid in Excel

Use the following steps to create a population pyramid in Excel.

Step 1: Input the data.

First, input the population counts (by age bracket) for males and females in separate columns:

Step 2: Calculate the percentages.

Next, use the following formulas to calculate the percentages for both males and females:

Step 3: Insert a 2-D Stacked Bar Chart.

Next, highlight cells D2:E:11. In theÂ ChartsÂ group within theÂ InsertÂ tab, click on the option that says 2-D stacked bar chart:

The following chart will automatically appear:

Step 4: Modify the appearance of the population pyramid.

Lastly, we will modify the appearance of the population pyramid to make it look better.

Remove the gap width.

• Right click any bar on the chart. Then clickÂ Format Data Seriesâ€¦
• ChangeÂ Gap WidthÂ to 0%.

Add a black border to each bar.

• Click the paint bucket icon.
• Click Border. Then clickÂ Solid line.
• Change theÂ ColorÂ to black.

Display the x-axis labels as positive numbers.

• Right click on the x-axis. Then clickÂ Format Axisâ€¦
• Click Number.
• Under Format Code, typeÂ 0.0;[Black]0.0Â and clickÂ Add.

Move the vertical axis to the left-hand side of the chart.

• Right click on the y-axis. Then clickÂ Format Axisâ€¦
• ClickÂ Labels. SetÂ Label PositionÂ toÂ Low.

Change the title of the graph and the colors as needed. Also click on any of the vertical grid lines and click delete.

The final result should look like this: