• Dp

How To Create Waterfall Chart in MS Excel

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.