Let us learn How To Create Waterfall Chart in Excel.
This kind of chart looks like a waterfall and that's the reason why it has been called as Waterfall Chart.
In this tutorial, let us see in detail how to create a waterfall chart in excel.
Here in this example, I have got sales data for 6 months like shown.
Step 1: First, I will be creating dummy row under this sales data and put the formula in cell D8 as = C7+C8, which actually gives the cumulative count of sales
Step 2: Drag this formula to the right side till the Total column, to apply the same formula.