Waterfall Charts In Excel. Create a waterfall chart select your data. Click insert insert waterfall or stock chart waterfall.
Convert the stacked chart into a waterfall chart click the base series right click then select format data series click fill in the menu and no fill in the drop down menu for colors. In a waterfall chart the columns are distinguished by different colors so that you can quickly view positive and negative numbers. Click insert insert waterfall or stock chart waterfall.
Create a waterfall chart select your data.
Create waterfall chart in excel 2016 and later versions. A waterfall chart is used for showing the overall effect by introducing positive or negatives steps. Create waterfall chart in excel 2016 and later versions. The easiest way to assemble a waterfall chart in excel is to use a premade template.
