To calculate the total for the Male Population, select cell C3 and type the equation: =SUM(C4:C24) Hit enter on your keyboard.To calculate the total for Both Sexes, select cell B3 and type the following equation: =SUM(B4:B24) Hit enter on your keyboard.Calculate the total for all three population groups. Insert a new row under the headings that will become row 3 and include the Total for each population group.
You’ll be left with four columns: Age Group Both Sexes Population Male Population Female Population.Ĥ. You may need to re-type the ages 5-9 and 10-14.ģ. In the ‘Number’ tab, select ‘Text’ from the list on the left and click OK. 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ġ.
How to Build a Population Pyramid in Excel: Step-by-Step Guide