A population pyramid is a type of chart used in demographic analysis for specific markets or whole economies to show a distribution of a population by age and gender at some point in time.
In the example below, age groups are points (points on an axis), males and females the series (differently colored items of a legend), and time and other parameters are filters (one particular time point is selected instead of selecting a time range). Usually, you will find males and females represented as bars extending in opposite directions from zero as in the image below.
Follow these steps to create your own population pyramid. This example is based on the OECD's Labor Force Statistics (LFS) By Sex and Age table, originally published here. (Need this dataset, too? Talk to your system administrator!)
- Create a new dashboard or a new section in your existing dashboard.
- Select the general chart icon (represented with bars).
- Select a dataset that contains the necessary data (population information by age and gender).
- Click cog icon to go into advanced mode.
- Select the dimensions you want to filter for (e.g., country, region, geo, location etc.) and set them as filters by selecting “F”, F for Filter.
- Select one gender (e.g., male) and set it as a series by selecting “S” for Series in the blue square.
- To add the other gender (Women in this example) on the opposite side of the population pyramid, add a calculation Women = (0 - Women) by clicking the Add calculation button, using the formula builder to enter the formula builder options, and clicking Save:
Const(when you click Const, the value 0.00 will be pre-filled for you)
women (select women in the field above)
To add age, open that dimension on the left, click P to set ages as Points, and select each age/age bracket you want to visualize on the right.
- From the time dimension, choose the mode Individual Members to pick the time period for your chart, and then choose F to make it the Filter.
Choose which indicator you want to visualize. In this example, we will choose 'Population' (or another indicator, it's up to a dataset) from the series dimension. Make sure F for Filter is selected.
- To ensure both men and women appear on the same primary axis, switch to the Appearance tab > Series dimension and for each series in select the Primary button.
- Last (required) step: from Appearance > General, choose the Pyramid chart type and you will see instantly the rendering of your new demographic pyramid.
All set! Your population pyramid chart is ready! Click Save.
You may want to customize the appearance a bit. For example, you can adjust the data precision or add a footnote from General, insert a legend from Plot Area, customize the colors for each gender from Series, and more.
- We strongly recommend showing the legend and verifying that your series for Men and Women appear in the legend in the same order as the bars on the graph.
- If they do not, in the Dimension Filter tab, open the dimension Sex and click and drag one of the genders to switch its position. Preview it in the Appearance tab in case you need to adjust the colors.
When you're satisfied with your pyramid, Save.
TIP! You may want to consider parameterizing your new chart - by country and/or series, for example - so that a user who views a dashboard can choose a different country or another indicator from the dataset.