Skip to main content

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.

Subject Librarians

Information Literacy Instruction

Off-Campus Access

Interlibrary Loan

Chronicle of Higher Education

Reserves/Fair Use

Ask Us

Research Consultations

Renew Books Online

Request a Purchase

Group Study Rooms

Open Computers

About Us 

Library Fines

PA Resident Cards

Suggestion Box


Giving to the Library

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