• 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.

Step 3: Now select the entire data from B6 to I8, from the right corner with the quick analysis tool (Ctrl+Q), Insert a Stacked chart like shown below.

Step 4: Now in the chart, We need to now move the red series to bottom and keep the blue series on top, to do that right click and select the option select data.

Step 5: Select the Dummy series and click the up arrow button to move the dummy series up in the order.

Step 6: By doing this, you will observe that the red series in the chart has gone to down from the top portion. Right click on the red/dummy series and fill it with white color to make it transparent.