Tag Archives: Charting in Excel

EXCEL 2016 Offers New Chart Types

If you have ever examined Excel’s charting tools, you may be wondering what other chart types could there be as previous versions of Excel offered eleven chart types.  These included Column, Line, Pie, Bar, Area, X Y (Scatter), Stock, Surface, Doughnut, Bubble, and Radar.

Microsoft’s newest version, EXCEL 2016, brings with it some new and modern chart types to help you better illustrate data that you include in your worksheets.  These charts are also available in PowerPoint 2016 and are:

TREEMAP:   A Treemap chart displays hierarchically structured data. The data appears as rectangles that contain other rectangles. A set of rectangles on the same level in the hierarchy equal a column or an expression. Individual rectangles on the same level equal a category in a column. For example, a rectangle that represents a type of food found in a grocery store (Dairy)  may contain other rectangles that represent products in that category.

See Treemap chart below.









WATERFALL:  As explained by Microsoft, “Waterfall charts are ideal for showing how you have arrived at a net value, by breaking down the cumulative effect of positive and negative contributions. This is very helpful for many different scenarios, from visualizing financial statements to navigating data about population, births and deaths”.

PARETO:  A Pareto chart contains both bars and a line graph. Individual values are represented by bars. The cumulative total is represented by the line.

HISTOGRAM:. A Histogram chart displays numerical data in bins. The bins are represented by bars. It’s used for continuous data.

BOX and WHISKER:  A Box and Whisker chart, as explained by Microsoft, is “A box and whisker chart shows distribution of data into quartiles, highlighting the mean and outliers. The boxes may have lines extending vertically called ‘whiskers’. These lines indicate variability outside the upper and lower quartiles, and any point outside those lines or whiskers is considered an outlier.”

SUNBURST:  A Sunburst chart is a pie chart that shows relational datasets. The inner rings of the chart relate to the outer rings.   It’s a hierarchal chart with the inner rings at the top of the hierarchy.

For more information from Microsoft regarding the creation and use and to view samples of these new chart types, click the following link:

New Chart Types in Excel 2016

Interested in learning Excel 2016?  Please contact Angela Nino, lead faculty in the Business Office Systems & Support Department at Richland College.  (anino@dcccd.edu or call 972-238-6215) The BOSS department is a Microsoft Authorized Testing Center; if Excel certification is important to you, keep in mind that you will be able to both learn to use Excel 2016 and attempt the Microsoft Excel 2016 Certification exam with us!