Today, I will be showing you what those charts look like in Excel. And if you are impressed enough to want try them, all you need is Excel 2016. Better if you have the O365 subscription pack one, I think those ones get pushed new updates first.
This lets you use rectangular bars of varying height and width to visualize performance or values of different entities.
It's a lot like Pie chart and Doughnut chart, main difference is that it automatically sorts the data to be visually represented in descending order clockwise.
It is for showing frequency distribution. Those of us with some statistical background will be at home with it.
4. Box & Whisker
This is also a statistician's tool. It is for showing the spread of values for the different quartiles in the data.
This is an accountant's staple. It shows incremental effect of connected data points.
If you are into sales you will be familiar with funnels. How many leads you need to get a sale? Conversion rates? With a funnel chart you can visually depict each level of your sales activities and their conversion rates.
And those are the new chart types in Excel.
You can access them natively from the chart menu.