• Home
• Multi-Sector
• Agriculture
• Communications
• Crime
• Education
• Environment
• Finance
• Gender
• Governance
• Health
• Industry
• Inf. Technology
• Labour
• National Accounts
• Population
• Trade
• Transportation
• Urban/Rural
• Water/Sanitation

• Authors
• Contact Us
• Data Issues
• Disclaimer
• Software/Tools
• Training

A number of web sites given instructions on building population pyramids with Excel. Googling "population pyramids excel" will bring up a selection. A small number of the sites is listed below.  Note that there is little difference in the process of creating pyramids for the different versions of Excel although pyramids developed in Excel for Apple need a bit of tweaking. The pyramids require data in five-year cohorts by sex. Suitable data at the national, regional and global levels can be downloaded from the World Bank's HNP database (only to 2010) at http://databank.worldbank.org/ddp/home.do , from the UN Population Division (1950 to 2050) at http://esa.un.org/unpp/ using the "detailed data" selection. The US Cenus Bureau provides information (1995-2050) at  http://www.census.gov/ipc/www/idb/informationGateway.php using Data Access option and the Age Groups tab.

The Department of Agricultural, Developmental and Environmental Economics at Ohio State University provides a step-by-step set of instructions for creating population pyramids at http://aede.osu.edu/class/aede597.01/gonzalez/pyramid/  .

The University of Vermont also provides a step-by-step method for Excel, with perhaps more detailed instructions, at  http://www.uvm.edu/~agri99/spring2004/Population_Pyramids_in_Excel.html .

McMaster University provides a pdf download with detailed instructions for preparing population pyramids at http://www.learnlink.mcmaster.ca/BScN/Courses/N3VV3/content/Population_Pyramid_How_To.pdf .