Radu, how to you create a population pyramid chart in Excel?
This is a question that I received a while ago from one of the cool people I met during one of my Excel courses that I deliver in Romania.
Great question, let’s see how.
First things first, what is a population pyramid chart?
Well, it’s a chart that shows you how old or how young a country is by showing how the population is split into age groups.
Yeah, I know, bla bla, here is how it looks like:
There is no chart template for this one, al least not yet. We can however use our ninja excel charting skills to create one.
With a bar chart and some tweaks, it shouldn’t be very hard to do.
Check out the video bellow:
If you like my video, I won’t mind if you hid the like button. 🙂
While researching for this article, I found some very interesting demographics data on a website that you can see bellow.
Try for yourself
Here is the document I’ve used, if you want to try for yourself.
Learn Excel / Google Sheets
If you want to learn more about Excel and Google Sheets, take a look at my Udemy courses.