Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.
Worth $20, Absolutely Free
We all agree on one thing that:
Charts are one of the best ways to compare data for different groups and time periods. A chart also helps a user to understand the data quickly.
Let’s get bit specific.
A Pyramid chart is one of those advanced Excel charts which can help you to present data in a specific way.
Yes, specific way.
Take an example of presenting population of different age groups and comparing both the genders with each other.
Yes, a population pyramid chart is a specific and targeted chart to present population data for better insights.
You know what? I have found 3, yes three different ways to make a population pyramid chart in Excel. And today, in this post, I’d like to share with you exact steps which you need to create it.
Important Note: Female population should be in negative so that we can create a two sided bar chart.
Congratulations! your pyramid chart is ready.
Here you have used a simple bar chart in which we got two different sides by using male data in positive numbers and female data in the negative numbers.
And, then you have changed the female negative numbers into positive by using custom formatting.
Check this out == > Tornado Chart
You can also create a pyramid chart by using conditional formatting. Just follow these simple steps.
You have just applied conditional formatting data bars in the cell using data captured in it. Data bars will change when there is a change in data.
Check this out == > Funnel Chart
I am a big fan of REPT function and the best thing is you can use it to create simple population pyramid.
Here are the steps.
Your pyramid chart is ready to use.
Here you have REPT function to repeat "|" as per the number you have in corresponding cell.
Click here to download this animated template.
You might be wondering that a pyramid chart is just for population data but the truth is you can use for all kind of data.
Whenever you need compare different data points for two different time periods pyramid chart is best to use, for example, sales data for different products for two years.
I hope this charting tip will help you to get better in Excel.
Now tell me one thing. Have you ever used a pyramid chart? Or, do you any other way to create it? Please share with me in the comment section, I’d love to hear from you.
And, please don’t forget to share it with your friends.