Tornado chart is useful for those who want to analyze their data for better decision making. It’s a useful tool for sensitivity analysis, but you can use it for comparison purpose as well.It’s like a two-sided bar chart (looks like a tornado) where we have two data bars opposite to each other. It makes it […]
Let’s say, with your extreme efforts you have formatted a chart and then you realize that you have more charts to format.Applying the same formatting to all the charts is a tedious task, the same thing again and again.It’s a pain.The good news is: there is a super quick solution to your pain. All you […]
Pivot tables are close to my heart. I love to use them. But apart from this, there is one thing which I love to use.That’s ==> Pivot ChartYes, a pivot chart.And, do you know a pivot chart is the easiest way to create a dynamic chart.Today, in this post, I’d like to share with you […]
If you one of those people who hate to use a pie chart in Excel then there is an alternate for you.Waffle ChartA set of grids (squares of equal area) which represents the entire chart. It is also called a square pie chart.In the below example, we have a dynamic waffle chart which you can […]
To analyze population data we can create a Population Pyramid in Excel. Here I have listed 3 different ways to create an Excel Pyramid Chart. All the three methods are simple to use & you can choose anyone which you think is a perfect fit for you.