Creating a population pyramid
A population pyramid is a chart that shows population distribution by age and gender. Age is typically distributed using five-year age groups. The youngest groups are located at the base and the oldest groups at the top. Population pyramids can indicate how slow or fast the population ages, and can also be used to forecast how the population will change in the future.
In this recipe, we will create British Columbia's population pyramid from 1986 to 2041.
Getting ready
To follow this recipe, open B05527_02 – STARTER.twbx. Use the worksheet called Population Pyramid, and connect to the BC Population Projection data source.
How to do it...
The following are the steps to create a population pyramid:
From Dimensions, drag Age Bracket to the Rows shelf.
Hover over the Age Bracket column header until you see a sort icon, and click on the sort icon. Click on the sort icon twice to sort the Age Bracket values descending.
Right-click on Total value for Age Bracket and select...
