Note that the only manually populated columns are the Series column and the Net Cash Flow columns. This are the values that should be shown in the PowerPoint Waterfall Chart.
In this tutorial, we are going to show how to edit one of our Data-Driven PowerPoint Bar Chart Templates, based on an initial set of values. In order to create this charts is necessary to create a Stacked Bar Chart and edit some of the series to create the effect of the waterfall. Waterfall Charts are not native charts provided by PowerPoint or Excel. The graphical representation clearly describes the cumulative effect of positive and negative amounts. The Bar Chart X Axis contains different series labels, and the Y Axis starts at a certain level and each series moving right starts reducing/increasing the value until it reaches a final value. Finally, the last bar represents the final value after applying each of the cashflows in order. For example, if the chart is describing business cash flow, it will represent each months net value, if the Waterfall Chart is representing how money has been spent in different areas of the company, the series will represent each area. The next series of bars describes the periods or the categories of the flows. The first bar describes the initial value of the flow (starting point). This kind of charts is usually used to describe cash flows fluctuations. Waterfall Charts are a special representation of Stacked Bar Charts that resembles a waterfall due to its decreasing/increasing values moving from left to right.