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.
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.
Andruss Library | 570-389-4205 | email@example.com
©Copyright Bloomsburg University of Pennsylvania • 400 East Second Street, Bloomsburg PA 17815-1301 • 570.389.4000