Excel Unplugged

New Charts in Excel 2016

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.

Waterfall Chart

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.

New Charts in Excel 2016

New Charts in Excel 2016

Box & Whisker Chart

Every time you have data that is distributed, as the Schools results by courses are bellow.

 

New Charts in Excel 2016

You can show that distribution with a Box & Whisker Chart.

New Charts in Excel 2016

New Charts in Excel 2016

Brilliant right? But the last one is even greater.

Treemap

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.

New Charts in Excel 2016

New Charts in Excel 2016

New Charts in Excel 2016

But it gets even better.

Sunburst

This is my favorite charting option in Excel 2016. Able to show much more levels, here is Sunburst.

New Charts in Excel 2016

New Charts in Excel 2016

Now this really takes any Data Analyst or Dashboard designer one step closer to eternal happiness 🙂

Learn more

Check out our YouTube channel and subscribe for more amazing Excel tricks!

Follow us on LinkedIn.

Check out our brand new R Academy!