Excel 2016 introduces new chart and graph options including histogram, box and whisker, and waterfall

2 min. read

Published onAugust 8, 2015

published onAugust 8, 2015

Share this article

Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more

Data visualization has become easier and easier with the advent of computers and increased access to data. Excel has been the default for crunching numbers across industries but there have been a few core data visualizations which have been missing. In Excel 2016, Microsoft has introduced six new graph types to help people get more done without leaving Excel.

These six chart types are very commonly used in statistical analysis like the box and whisker plot and histograms. Other commonly used charts are waterfall, Pareto, Treemap, and Sunburst, and these are all now available in Excel 2016. None of these chart types are particularly ground breaking or complex, but it they have been oddly missing from Excel for such a long time. To help walk people through the new chart types, Microsoft is breaking each one out for a blog post, currently they’ve onlydone the waterfall chartfor now.

The waterfall chart is great for visualizing gains and losses alongside totals. The easiest way to demonstrate this can be seen in financial balance sheets. The waterfall chart separates gains and losses by color and by representing the bars as moving up or down from the previous bar. If you have created a new chart in Excel 2016, the chart can be viewed from the Excel mobile app on Windows, but nothing can be changed because the new chart comes in as a single object. Gograb the preview of Office 2016and try out these data visualizations for yourself.

Radu Tyrsina

Radu Tyrsina has been a Windows fan ever since he got his first PC, a Pentium III (a monster at that time).

For most of the kids of his age, the Internet was an amazing way to play and communicate with others, but he was deeply impressed by the flow of information and how easily you can find anything on the web.

Prior to founding Windows Report, this particular curiosity about digital content enabled him to grow a number of sites that helped hundreds of millions reach faster the answer they’re looking for.

User forum

0 messages

Sort by:LatestOldestMost Votes

Comment*

Name*

Email*

Commenting as.Not you?

Save information for future comments

Comment

Radu Tyrsina

With KB5043178 to Release Preview Channel, Microsoft advises Windows 11 users to plug in when the battery is low#

Copilot in Outlook will generate personalized themes for you to customize the app#

Microsoft will raise the price of its 365 Suite to include AI capabilities#

Death Stranding Director’s Cut is now Xbox X|S at a huge discount#

Outlook will let users create custom account icons so they can tell their accounts apart easier#

Excel 2016 introduces new chart and graph options including histogram, box and whisker, and waterfall#

With KB5043178 to Release Preview Channel, Microsoft advises Windows 11 users to plug in when the battery is low

Copilot in Outlook will generate personalized themes for you to customize the app

Microsoft will raise the price of its 365 Suite to include AI capabilities

Death Stranding Director’s Cut is now Xbox X|S at a huge discount

Outlook will let users create custom account icons so they can tell their accounts apart easier

Excel 2016 introduces new chart and graph options including histogram, box and whisker, and waterfall