Up to Excel 2016, if you wanted to create advanced and special charts, your best option was Jon Peltier. He created great Excel charting add-ins. My favorite is the advanced edition of his charting utility. Now there are still many things and fine-tuning that you can only do if you have that add-In but with Excel 2016, quite a few new charting options are available.
It’s been a long time coming and I’m guessing the biggest wish that users had when it comes to charting. And now, in Excel 2016 you will be able to create your own waterfall charts with one click.
Every time you have data that is distributed, as the Schools results by courses are bellow.
You can show that distribution with a Box & Whisker Chart.
Brilliant right? But the last one is even greater.
Showing data over many hierarchies is never easy and up to now, not many options were available in Excel but now, for just a few levels of hierarchy, a Treemap is a perfect chart for that.
But it gets even better.
This is my favorite charting option in Excel 2016. Able to show much more levels, here is Sunburst.
Now this really takes any Data Analyst or Dashboard designer one step closer to eternal happiness 🙂
(as simple as Copy and Paste) This is our sample data. First we ...
This is what happens when someone has too much time and Excel ...
Just so we know where this is heading, this is the end result And ...