# Excel Population Pyramid

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on October 30, 2023

This tutorial will demonstrate how to create a Population Pyramid in Excel.

## How to Create a Population Pyramid Chart in Excel

A Population Pyramid Chart is useful when visually showing subsets within a population for specific groups. In this case, we want to show the % of the population that is Male and Female for specific age groups.

We’ll start with a dataset that gives information about a population. As discussed, we’ll be working with data that shows the population of males vs females in age groups as seen below. You can also follow along with data I’m using in this example by downloading the report: Population Pyramid Download

### Sum the Total

Create a Total Row to Sum the Total Population, Total Males, and Total Females by using the formula:

=SUM(), where the numbers in the parenthesis are the first and last number in the series

### Calculate Percentage that is Male & Female

1. To Calculate % Male, insert formula =0-100*(C10/\$C\$31)

2. To Calculate % Female, insert formula =100*(D10/\$D\$31)

3. Drag these formulas down and you’ll see the results similar to below.

### Copying Information to New Worksheet

1. Copy (Ctrl + C) the Age Group and paste (Ctrl + V) to another tab

Copy (Ctrl + C) % Male and % Female and go to new tab.

2. Right Click

3. Select Paste Values

### Create Horizonal Bar Graph

1. Highlight table
2. Click Insert in ribbon
3. Click Horizontal 2D Bar

You should see a graph that looks like below. But we still need to clean up some formatting.

### Moving Axis

1. Right Click on Y Axis (Age Groups)
2. Click on Format Axis

3. Click on Labels

4. Select Distance from Axis

5. Select Low

1. Right Click on one of the Series
2. Select Format Data Series

3. Change the Series Overlap to 100%

4. Change the Gap Width to 0%

Update X Axis

1. Right Click on the X Axis
2. Select Format Axis

3. Click on Number

4. Select Custom

5. Under Format Code type 0;0

### Adding an Outline to the Bars (Optional)

1. Select Data Series
2. Click Format
3. Select Shape Outline and pick the color of your outline.

Use this method for both sets of data to make it look more visually pleasing.

### Final Population Pyramid Chart

After adding Axis Titles (How to add Axis Labels) we now have a finished pyramid chart that shows the population of female vs male.