How to Create a Population Pyramid Chart in Tableau
Updated: Sep 4, 2020
Population pyramid is chart that shows population distribution by age and gender. Age is typically distributed in bins of 5 or 10 year gap – can vary based on use case. With the youngest groups located at the base and oldest groups at the top of pyramid.
This chart is created the same way you create a divergent bar chart. With few additional steps.
In this post, I will be using the sample data in the snapshot below to show you how to create a population pyramid chart.
Once you’ve connected to the data or your own data,
Drag dimension Age to the rows shelf
Drag measure fields Female & Male to the columns shelf
Next reverse the axis of the first chart by right clicking on the axis >>Edit Axis… >> under Scale check Reversed.
Executing this and sorting Age in descending order I have.
Next, I will create a calculated field ‘Place holder’ to help me label the Age groups in between the two charts.
The detail of this place holder is a zero.
Dragging this calculation ‘Place holder’ to the columns shelves right between SUM(Female) and SUM(Male).
Adding labels by dragging the dimension Age to the text shelf under ‘Place holder’ chart and aligning the text to middle-center.
Un-checking all headers in the view.
Formatting the view;
I hope this was helpful to you. To receive more of the Tableau tips and tricks, kindly subscribe to the mailing list.
Thank you for reading.