+91-8826547882

Population Pyramid Chart in Excel

populationpyramid

Population Pyramids are one of the most basic charts used in demography to show the age and sex structure of population. This article will show you how to create population pyramid chart in Excel 2010.

Click here to download the template

Preparing the data:
Create the table in your excel worksheet in the appropriate or desired age groups or desired regions for both the sexes as per your chart requirement.

Population_pyramid_in_excel2013

Now calculate the percentage of male and female, corresponding to desired regions and groups.

Populationpyramidsecond

Enter the Formula in the cell F5 (Male Population / Total Population) * -100, negative sign I have used in the formula to place the males in the left side of the graph (=C5/$D$21*-100).
In the same way enter the formula for female group percentage calculations (=D5/$D$21*100). We have not used negative sign here to place the bar on the right hand side.

Now drag the formula to the other cells.

Creating the Pyramid:
Select the Range (F4:H19), click on Insert Tab > select Bar Chart in Charts Panel > click on 2-D stacked bar chart.

Population_pyramid_three

The Chart by default will be created on the worksheet, now you can edit it.

Population_pyramid_four

To move the vertical axis to the very left hand side of the chart. Select the vertical axis > right click on it > Click Format axis > select axis labels Low.

Population_pyramid_chart_five

Now your population pyramid is ready to print (rest of the formatting you can do as per your requirements).

Populationpyramidsix

Note : Sample data in the table we have used is from wikipedia.
http://en.wikipedia.org/wiki/Demographics_of_India

May 16, 2014

0 Responses on Population Pyramid Chart in Excel"

Leave a Message

© copyright www.excelcrazy.com. All rights reserved. Design and Development by www.creativebrainweb.com