How to plot population pyramids in Excel
Population pyramids are back-to-back horizontal histograms.
First need a frequency table with the population split into age group and gender.
These frequencies are then expressed as percentages of the total population by gender.
If percentages are not calculated beforehand use EXCEL to do this. The formulae for Excel are given below.
The percentages for males are negative so when the graph is plotted the columns for males will be plotted
on the left hand side of zero on the horizantal axis.
Add 2D clustered bar graph.
Select A1:A12 hold down the Ctrl key select D1:E12 select the Insert tab then Bar and Clustered Bar
-20.00 -10.00 0.00 10.00 20.00
0-9
10-19
20-29
30-39
40-49
50-59
60-69
70-79
80-89
90-99
100-109
Perce ntage Male
Perce ntage Female
