New Excel 2016 Chart Types

excel-2016-200x110

Microsoft continues to innovate one of my favorite tools, Excel. I love charts and they just added six new types!

b3bfff05-380e-4dd9-b49b-7a2bfd128870
Treemap provides a hierarchical view of the data

fe924f0b-bdff-4cb8-bb45-7680e33715d2
Waterfall shows a running total, both positive and negative

d5436121-4026-4a6e-a2c0-880707fe0a05
Pareto is used to highlight your largest factor in a data set

7e7f26cb-e563-4b73-956d-fd0625472cdf
Histogram is used to show frequency data

96be2fcc-a80d-486c-8575-0ccad1fe0ca8
Box and Whisker shows distribution of data and highlights outliers

eb234cf8-1004-49bc-bfee-a50602ac492a
Sunburst shows hierarchical data via rings

Which one is your new favorite chart?

~ GW

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s