Skip to Main Content
It looks like you're using Internet Explorer 11 or older. This website works best with modern browsers such as the latest versions of Chrome, Firefox, Safari, and Edge. If you continue with this browser, you may see unexpected results.

EGGS 221: Economic Geography

Population Pyramids

Graphics of current population pyramids by age and sex.

Population Pyramid Example

Here is a detailed tutorial on creating a population pyramid in MS Excel.  While this is not the only technique, keep in mind that most techniques for creating a population pyramid require converting one of your data series's values to negative values.

Population Pyramids in MS Excel

In order to make a population pyramid in MS Excel, you must essentially make a stacked histogram (bar chart) with horizontal bars and a single y-axis.

If you choose to use this method in MS Excel to make your population pyramid, you will need to make one of the data sets (male or female) negative so that the negative values are positioned to the left of the y-axis. You will, however, need to format your data labels on the y-axis so that the intervals are not presented as negative values.

About Us 

Chronicle of Higher Education

Renew Books Online

Suggestion Box

Library Fines

Giving to the Library

Request a Purchase

Open Computers

Student Employment

Andruss Library | 570-389-4205 |
©Copyright Bloomsburg University of Pennsylvania • 400 East Second Street, Bloomsburg PA 17815-1301 • 570.389.4000