besttemplatess

Excel 2010 Waterfall Chart Template. A waterfall chart (also known as a cascade chart or a bridge chart) is a special kind of chart that illustrates how positive or negative values in a data series contribute to the total.in other words, it's an ideal way to visualize a starting value, the positive and negative changes made to that value, and the resulting end value. Firstly, make five columns, time, base, decrease, increase, and net cash flow, as shown below.

Firstly, make five columns, time, base, decrease, increase, and net cash flow, as shown below. All you need to do is edit the labels, the delta values, and place an x in the pillars column if you want to display an intermediate value. If you want to quickly and easily to create a waterfall chart without formulas, you can try kutools for excel’s horizontal waterfall chart feature, which create a horizontal waterfall chart only needs several clicks.