Uncategorized

Waterfall chart excel 2016 mac

Now we can make any formatting changes we want just as we would with any other chart in Excel. The waterfall chart is a really nice addition to the family of charts offered in Excel As we have seen here, it provides a cascading visualization of data that includes increases and decreases while allowing us to see the cumulative effects on the running total in a very intuitive fashion. For the right kind of data, the waterfall chart can really bring things to life by providing an at-a-glance representation that anyone can appreciate.

The new charts in Excel can be used in a variety of scenarios. To learn more about all of them check out our guide here. Before you begin your charting adventure, you should definitely read this comprehensive piece on what to do and what not to do when creating charts. This article is written by Kasper Langmann from Spreadsheeto.

If you like it, you should check out his free Excel training.

Peltier Tech Charts for Excel Waterfall Charts

Many years ago, Peltier Tech introduced a tutorial that showed you how to make your own waterfall charts in Excel, the slow hard way. You can even read the latest edition of the Excel Waterfall Charts Bridge Charts , which is only a few years old. Over the years it has been upgraded to run in newer versions of Excel, and to run in Excel for Mac. It has been continually enhanced, several varieties of waterfall charts have been introduced beside it, and thousands of users now depend on it.

How to Create Waterfall Charts in Excel - or Bridge Charts

When the program encounters a blank in the data column, it knows to calculate a total for that category. If the totals in your input data are wrong, the chart Microsoft creates is also wrong. When you click OK, the program inserts a worksheet with links to the data as well as columns of formulas that make sure the plot comes out right, plus a chart. Alternatively, you could have the program construct these formulas in the original worksheet. There is a checkbox and list box next to the output range, so that you can modify some of the options selected in the dialog.

The waterfall chart looks like on of the charts below. The second waterfall chart treats the first value in the input data as a change in value, in this case, as the first increase in revenue, coming from sales. These charts are regular Excel charts, so you can reformat them, resize them, copy and paste them wherever you want. You need to be careful, however, because if you format away some of the hidden magic that makes them work as waterfall charts, you may break them and have to rebuild them. I can format the colors of the Microsoft waterfall chart, and I can change the maximum and minimum of the vertical axis, but I am unable to modify the major tick spacing of the vertical axis.

One of them is a Rotated Waterfall Chart. Most people prefer the regular orientation, but some customers asked for a rotated version, so here it is. There is also a Stacked Waterfall chart. The Stacked Waterfall handles this situation by replacing a multicolored stacked bar with a single bar that merely shows the net for that category.

Another type of waterfall is the Dual Waterfall Chart, which allows you to compare two sets of data. The data set below shows the same data for two years.


  1. mac night to remember lipstick;
  2. The New Waterfall Chart in Excel 2016;
  3. The New Waterfall Chart in Excel - Peltier Tech Blog!
  4. alien skin exposure 7 mac!
  5. sd card doesnt show on mac.
  6. Create a Waterfall Chart With Excel 2016.

The Dual Waterfall shows one set of data as filled bars, the other as transparent bars with a thick outline, so you can compare performance item by item across two sets of data. This is yet another way to track the cumulative effects of intermediate factors on a value or set of values. Wednesday, October 19th, under Chart Types. In the Peltier Tech stacked waterfall and split bar waterfall, all the bars are split into the same number of constituents.

Hello I would like to ask a question about stacked waterfall chart. When a stack has values with mixed signs, what my program does is omit the individual bars, and instead draw a single bar showing the net change sum of increases minus sum of decreases.

Create a Waterfall Chart With Excel | Free Microsoft Excel Tutorials

There is another chart in my add-in, called a split bar waterfall. If all the values have the same sign, then the bars are all stacked upward or downward. If the values have mixed signs, the bar is split, and the positive values are stacked upward in the left half of the stack, and the negative values are stacked downward in the right half of the stack. Excellent article! I was looking for info.

Question Info

Thank you. But you can see how to do this with the regular waterfall chart in Excel Waterfall Charts Bridge Charts , and maybe you can figure out how to extend it to stacked waterfall charts. You can also set totals by right-clicking on a data point and picking Set as Total from the shortcut menu. Connector lines connect the end of each column to the beginning of the next column, helping show the flow of the data in the chart. To hide the connector lines, right-click a data series to open the Format Data Series task pane, and uncheck the Show connector lines box.

The chart legend groups the different types of data points in the chart: Increase , Decrease , and Total.

Native waterfall charts in PowerPoint for Mac

Clicking a legend entry highlights all the columns that make up that group on the chart. On the Insert tab on the ribbon, click Waterfall icon and select Waterfall.

The Waterfall Chart in Excel 2016

Use the Chart Design and Format tabs to customize the look of your chart. If you don't see these tabs, click anywhere in the Waterfall chart to display them on the ribbon. To read more about the waterfall chart and its uses, see this blog post on the waterfall chart by the Excel team. You may also be interested learning more about the other new chart types described in this blog post. Import and analyze data. Create a waterfall chart Select your data.


  • Was this information helpful?.
  • mac n cheese with bacon.
  • cisco vpn client mac os x 10.9 download.
  • Data used to create the example waterfall chart above. Here's how you create a waterfall chart in Excel for Mac: Select your data. Expand your Office skills. Get new features first.