Organize and Clean your Population Dataġ. It will be the file where you’ll build your population pyramid. The data will be entered into a new excel document.ħ. Click the icon and select Excel as your Download Format. In the upper left you’ll see a download icon (circled in red above). The generated report will look like this:Ħ. This is what the selection column looks like:ĥ. Under ‘Report’ click ‘Population by Age’ and then choose ‘Five Year Age Groups.’Ĥ.

In the column on the left, select the country of your choice under ‘Select by Country/Area.’ I chose Guatemala for this example.ģ.

Census Bureau’s International Database.Ģ. Get the Population Data for your Countryġ. Where I say “click” you might need to double click.This guide is based on using Microsoft Excel 2016.

Making a population pyramid, or age-sex distribution graph, in Excel has never been easier than with this step-by-step guide that takes you all the way from gathering the needed demographic data to the finished product – a graphically-accurate (and beautiful!) population pyramid.

How to Build a Population Pyramid in Excel: Step-by-Step Guide

Building a histogram chart excel 2013