Home // Blog & Excel Tips // New graphs in Excel 2016

Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. How do you take all the formatting from chart (see 1 below) and PASTE it onto another chart (2)? Guess and then see how it can be done with 'See Answer'

 
2. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.

 

New graphs in Excel 2016

Comments Closed
Uncategorised

One of the most overlooked sections in Excel has been the charting section. As the various versions have been released we have seen new tools for pivot tables, filters, conditional formatting and formula’s. But charts have stayed the same. The look has changed and where the options are, are moved around regularly but no new charts have appeared for years. However, this looks like it is changing with new charts in Excel 2016.

Learn: Excel Dashboards and Management reports

Table of contents

As per the Microsoft Site a number of new charts will be available in Excel 2016. Some of these charts you can already build with some workarounds and clever tricks, but others are not so easy. Below what some of them look like. For more information of their uses refer to the Microsoft site

Waterfall Chart For Excel 2016+

waterfall chart excel 2016

Sunburst Chart

sunburst chart excel 2016

Treemap Chart

treemap chart excel 2016

Box and Whisker Chart

box and whisker chart excel 2016

Parento Chart

parento chart

Histogram Chart

histogram

Related

Excel Dashboards Course

Excel charts and graphs online course

Excel waterfall chart template

Change the invert if negative colour in Excel charts