Now click in the data and choose Insert, Hierarchy Chart, TreemapĪnother way to display this type of data is with a Sunburst chart. A Treemap can’t be created directly from a PivotTable so you will have to copy as values to another location. Suppose you have PivotTable data based on car sales. This is a brand new chart type and a great way to visualize hierarchies of data. See How to create a waterfall chart with Excel 2010 Some formatting is needed but most of the work is done. With Excel 2016 you click in the data and choose Insert, Waterfall from the Waterfall and Stock Chart button.

Suppose you have the following data and wish to display it in a Waterfall Chart: The bars appear to fly or float between the start and end columns giving the impression of a waterfall or a bridge. Recap: A Waterfall Chart, sometimes called a ‘flying brick chart’ is a way of visualizing a series of positive and negative data such as monthly cash flows. It would have involved a lengthy work around using formulas, recolouring bars, white boxs and adjusting the scale. On the Insert tab there are several new Chart Types available only in Excel 2016.īeing able to create a Waterfall chart with one click will amaze anyone who has attempted to create such a chart in previous versions of Excel. ‘Tell Me’ remembers what you have asked and further actions to try.

Type what action you would like to take and you get some useful tips to help you get started. ‘Tell Me what you want to do’ on the Home ribbon is now available across Office 2016. There is also a new Get & Transform section for creating and working with queries. They can be located on the Insert and Data tabs and include several new chart types, a Power Maps tool and a Forecast Sheet feature. The main changes between Excel 20 are associated with the Business Intelligence (BI) features. To learn more about that, please take a look at our Excel courses. We have compared the different versions of Excel and come up with a quick overview of What’s New in Excel 2016. With Excel at the core of many businesses, it would help to have all of the new features explained.

With the launch of Office 2016 in the Autumn of 2015, you may be wondering about the new features in 2016 and what’s changed.

Excel sunburst chart in 2013