If you’ve been playing around with Power BI like me, you’ve already seen the Treemap chart. Here I’m using the Sunburst chart to analyze the receivers of a few different teams by player and position. So if you wanted to view how individual accounts contribute to their parent accounts in a balance sheet, the Sunburst chart could be a really interesting way to visualize that type of data. The Sunburst chart is good for viewing hierarchical data. Pretty cool!Ī Waterfall chart could be really useful for monitoring changes in inventory or for viewing balance sheet data. Using this chart I can see how each play in the drive led to the total yards gained on the play. For instance, below I have a Waterfall chart that shows the play stats from the New England Patriots first drive in their conference championship game against the Indianapolis Colts which resulted in a touchdown. The neat thing about Waterfall chart is that it allows us to see how the small pieces of a whole contribute to the total.

The Waterfall Chart was just added to Power BI so you’ve probably already had a look at that visualization. You also have control over the chart formatting through some options specific to the Box & Whisker chart type. In the below chart, I pulled in some data from NFL.com with Power Query and performed some analysis on the yards per game for the top four running backs from last season. The Box & Whisker chart is a really nice visualization for getting a quick look at the distribution of data including outliers, mean, range and quartiles, for example. In order to use these charts, you’ll need to create them on top of data that is not in a pivot table (at least for the time being). Now one thing to be aware of with these new chart types is that if you attempt to create this chart on top of some data in a pivot table, you’ll get a warning like the one seen here. But to be honest, if you’re a data & visualizations nerd like me, you’re probably pretty excited! The Office 2016 Public Preview is now available for download ! Included in the preview of Excel 2016 are a handful of new chart types and since I’m a huge fan of awesome data visualizations, I thought I’d take a few moments to play around with them and share my experience with you so you can have a better idea of what to expect in the next version of Excel.

Excel box and whisker 2016