top of page
  • Bernard K

How to Create a Population Pyramid Chart in Tableau

Updated: May 17, 2021

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.


Black & white.jpg

About Me

More About the Author

Bernard K

Analytics Consultant | 3X Tableau Certified

Bernard is a data analytics consultant helping businesses reveal the true power of their data and bring clarity to their reporting dashboards. He loves building things and sharing knowledge on how to build dashboards that drive better outcomes.

Let’s discuss your data challenges! Let’s work together!

bottom of page