Question

How we can make a population pyramid

Answer 1

Simple Steps to Create a Population Pyramid Chart using Bar Chart

Before we create this chart we need to prepare data. 

A table with the total population, female population in negative values and male population in positive values.



Note: Column for total population is not compulsory but make sure to have female population in negative.

First of all, we need to insert a bar chart. For this, select age group, female and male data columns and insert a bar chart from Insert Tab ➜ Charts ➜ 2D Bar ➜ Clustered Bar.Now we have a chart like below and further, we need to do some customization in it to make a population pyramid.



From here, we need to make vertical axis in reverse order and from this, go to Format Axis ➜ Axis Options ➜ Axis Position ➜ tick mark “Category in Reverse Order”.



After that, go to Format Axis ➜ Axis Options ➜ Labels ➜ change label position to "Low".



Next, we need to change series overlap to 100% and gap width to 0%. For this, go to Format Axis ➜ Series Option.



In the end, we need to convert negative data labels for female data bar into positive. For this, select data labels and go to Format Data Labels ➜ Label Options ➜ Number select custom from category and add to the “#,##0.00;#,##0.00” format.



Congratulations! our pyramid chart is ready to rock.