Six New Charts Excel 2016

Visualizations are very effective when we want to represent our data with a Chart. In Excel we were able to work with the existing Charts that were available in order to visualize our data. Now, in Excel 2016 we have six more charts available, that will be described below.

We can choose to insert Hierarchy Charts such as Treemap or Sunburst, or we can insert Statistical Charts such as Histogram or Box And Whisker. All you have to do is to follow the steps described below.

First we must select the data that we want to represent with a chart and then select the Insert tab and to locate the area of ribbon named Charts as shown in the image below.

Insert Charts

In order to see the six new Charts that are available in Microsoft Excel 2016, we can either press the Recommended Charts button as shown below, or we can select the bottom right arrow which is located at the Charts area.

Recommended Charts

One way or the other, the Insert Chart dialog box appears as shown in the image below. On this dialog box, we activate the All Charts tab in order to see all the available Charts but especially the new Charts that are available in Microsoft Excel 2016.

From the left of the Insert Chart dialog box, we select the Chart that we want to visualize our data in our Workbook. In the image below, I have selected the Stock Chart. We can use this Chart to show the trend of a stock’s performance over time. We use this Chart when we have three series of price values: High, Low and Close.

08

In the image below, I have selected the Treemap Chart. We can use this Chart to compare values across hierarch levels. We show proportions within hierarchical levels as rectangles. We use this Chart when the data is organized hierarchically and has fewer categories.

Tree Map Chart

In the image below, I have selected the Sunburst Chart. We can use this Chart to compare values across hierarch levels. We show proportions within hierarchical levels as rings. We use this Chart when the data is organized hierarchically and has many categories.

Sunburst Chart

In the image below, I have selected the Histogram Chart. We can use this Chart to show the distribution of the data grouped into bins.

Histogram Chart

In the image below, I have selected the Box And Whisker Chart. We can use this Chart to display variation within a set of data. We use this Chart when there are multiple data sets which relate to each other in some way.

Box And Whisker Chart

In the image below, I have selected the Waterfall Chart. We can use this Chart to show cumulative effect of a series of positive and negative values. We use this Chart when we have data representing inflows and outflows such as financial data.

Waterfall Chart

Now with Excel 2016, we have a lot of options when it comes for us to visualize our data with Charts.

Below you can check out the video describing the Six New Charts in Microsoft Excel 2016.

About officesmart

MVP: Honored with the MVP (Most Valuable Professional) for OFFICE SYSTEM title for the years 2011, 2012, 2013, 2014 and 2015 by Microsoft, for my contribution and commitment to the technical communities worldwide. Microsoft Master Specialist: This certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system

Posted on December 22, 2015, in Excel 365 English, Microsoft Office 365 ProPlus English and tagged , , , , , , , , , , , , , , . Bookmark the permalink. Comments Off on Six New Charts Excel 2016.

Comments are closed.