Microsoft Excel 2016 – How to show data more vividly with 6 New Chart Types

Visualizations are important to effective data analysis and compelling storytelling.

In Excel 2016 six new chart types have been added — Treemap, Sunburst, Histogram, Pareto (sorted histogram), Box & Whisker, Waterfall and Funnel —all with the same rich formatting options that you’re familiar with.

With these and Excel’s other classic charts, you can create some of the most commonly used data visualizations for displaying financial or hierarchal information, or for revealing statistical properties in your data.

To see all the new charts

On the ribbon, click the Insert tab.

Click Recommended Charts > All Charts.

To see specific new charts:

On the ribbon, click the Insert tab, then click one of the following chart icons (hover cursor over icon to see description):

Click Insert Hierarchy Chart to see Treemap or Sunburst chart.

Click Insert Waterfall or Stock Chart for Waterfall chart.

Click Insert Statistical Chart for Histogram, Pareto, or Box and Whisker chart.

 

Note: Funnel charts are ONLY available to Office 365 subscribers WITH the Office 365 version of Office 2016 installed (NOT the standalone version of Office 2016) Funnel charts show values across multiple stages in a process. Typically, the values decrease gradually, allowing the bars to resemble a funnel.