Creating a histogram in excel 2016 how to#

To do this: Highlight cells A4 and A5, right click, and select Format Cells. For the cells with ages ‘5-9′ and ’10-14’, you may need to change the cell category to Text. Delete the word ‘years’ from all of the age range cells in column A (cells A3 through A23). Type in new name.) Add a new row 1 above the headings and in cell A1 write the country name.Ģ. (Rename by right clicking on ‘Sheet1’ and selecting Rename so the text ‘Sheet1’ is highlighted. 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.

Creating a histogram in excel 2016 how to#

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