How To Make A Population Pyramid In Google Sheets

Population Pyramid with Excel

28/11/2021 28/xi/2021 4 18681

Reading Time: three minutes

It is common to create a population pyramid in Excel, in order to stand for the distribution of its customers or employees.

Unfortunately, Excel doesn't have this template in the Nautical chart's ribbon. Merely you can create hands a population pyramid chart by post-obit these steps.

The data for a Population Pyramid

To learn how to describe a population pyramid chart, let's take this file with the information of Korea.

Step 1: Convert the Women's values with negative values

Before creating your chart, you must perform subtraction of one cavalcade with 0.

Women are generally on the left of a population pyramid and then this column must take negative values.

In a new column, write this formula

=0-C4

And copy this formula for the others cells

Step 2: Create a chart for your data

Since Excel 2013, Excel advise a selection of charts in part of your data.

Select your Information
Select Insert > Recommended chart

Select the third option

Select the best chart to display your data

Or, if you prefer to select this type of chart in the gallery, you must select

The bar chart carte
Then the 2-D Bar option (horizontal representation)

Then, you have created this chart but there is still work to do to have a perfect population pyramid chart.

Chart returns by the recommended chart tool

Step iii: Remove the first Women Series

Nosotros accept a nautical chart that has two columns for the women (a positive column and a negative). We must remove the positive column.

Select the chart
And select the carte Design > Select Data.

In the list of serial, unchecked the offset Women series

If you don't have unchecked the correct series, you lot tin't reopen the same dialogue box and select the correct serial this time 😉

Step 4: Format the bars of the chart

Yous can run across that in your chart, the bars are thin and get-go with respect to each other. Let's correct these 2 points

Double-click to any bars to display the Chart pane
Then select the Series options
Modify the Series Overlap to 100%
Change the Gap Width to 0%

The nautical chart becomes

Chart with no overlap between the series

Footstep 5: Opposite the chart

Next, we must reverse the vertical axis so that the everyman values are at the bottom.

Select the Vertical axis, from the pane, with the dropdown carte du jour

Select the vertical axis with the dropdown menu

Select the Axis Option icon
Check the option Categories in reverse gild

Step 6: Format the numbers

Here, nosotros have 2 deportment

Remove the negative sign for the values of the Women
Brandish the number the ages on the left side of the chart

Remove negative numbers

Select the horizontal Axis
So, select the Axis Selection icon
And the Number format selection
Here is the tricks, in the format Lawmaking, you lot write General;Full general (the delimitor is a semi-colon)