This article about Microsoft’s new Waterfall Chart in Excel 2016 was written by Kasper Langmann, co-founder with Mikkel Sciegienny of, a relative newcomer to the Excel blogosphere. Kasper and Mikkel are very enthusiastic about Excel, they have written a number of tutorials on the, and they offer a comprehensive. Mikkel approached me to write about the new charts that Microsoft introduced in Excel 2016, and he agreed that we should write some posts together. In the first half of this post, Spreadsheeto will specifically talk about Microsoft’s new Waterfall Chart. I will follow up with a discussion of the extensive and flexible waterfall charts in Peltier Tech’s software. The Waterfall Chart in Excel 2016 In 2015, Microsoft released six new charts in an update for Excel 2016.

Customize a monthly budget template in Excel Although there are so many budget templates for downloading, you may still want to make a custom monthly budget template based on your needs. The following steps will walk you through customizing a monthly budget template in Excel.

This release was a direct response to user feedback and one of those new charts was the waterfall chart. The waterfall chart is a bar chart in which the bars are placed along the vertical axis at different levels according to whether they are an increase or decrease. Then totals are shown as bars of height from zero as they are affected by the increases and decreases. This is often useful for visualizing things like financial data where revenue can be shown as bars that shift upward vertically and expenses can be shown as bars that shift downward by contrast. As we dive into the details of how to create a waterfall chart, note that we will work with an example scenario in Excel 2016 for Windows.

Getting Started with a Waterfall Chart – Get the Data Right The first and foremost objective when setting out to create a waterfall chart is to make sure our data is in the correct format. Let’s take a look at a simple example of income statement data. It is important that our data is in this form where increases (income) and decreases (expenses) will be shown in the waterfall chart from left to right according to the data points from top to bottom in our table. Also, any totals (Total Revenue, Operating Income, and Net Income) will be shown in the chart as they appear in sequence in our data table. Note that Total Revenue, Operating Income, and Net Income are subtotals along the way that will be shown as cumulative totals in our waterfall chart.

This is set up to be a very intuitive progression as the chart presents revenue and expenses in the same logical fashion as our data table. This is an instrumental point for setting up our data. You get out of the waterfall chart what you put into it and this means knowing how to set up our data before creating the chart. Mdm solutions for windows and mac.

Inserting the Waterfall Chart Once our data table fits this layout, simply highlight the entire table (or one cell within the table), click on the ‘Waterfall and Stock Charts’ dropdown button Then select ‘Waterfall’ in the menu. Alternatively, click on the ‘See All Charts’ button at the bottom right of the Insert > Charts group Then find ‘Waterfall’ in the list of available charts and click OK.