Data Visualization: In Excel 2016

You can now select a specific cell range to serve as custom labels for data points, which is particularly helpful for scatterplots. Best Practices for Excel 2016 Turn Raw Data into a Clear, Interactive Dashboard in Excel

Displays the frequency distribution of data within specified "bins".

Similar to a Treemap but uses concentric rings to show hierarchical relationships, even when some levels have blank cells. Core Visualization Features Data Visualization in Excel 2016

Highlights data distribution, quartiles, mean, and outliers; commonly used in statistical analysis.

A sorted histogram that includes a cumulative percentage line, useful for identifying the most significant factors in a data set. You can now select a specific cell range

Excel 2016 added six modern charts to handle financial, statistical, and hierarchical data more effectively:

Data visualization in introduced several major updates designed to help users tell richer stories with their data, including six completely new chart types and streamlined customization menus. New Chart Types in Excel 2016 New Chart Types in Excel 2016 Excel analyzes

Excel analyzes your selected data and suggests the most effective chart types for that specific information.