Waterfall Charts In Excel. A waterfall chart is used for showing the overall effect by introducing positive or negatives steps. Transform the column graph into a waterfall chart click on the base series to select them right click and choose the format data series option from the context menu.
Click insert insert waterfall or stock chart waterfall. Create a waterfall chart select your data. The first and last value columns start on the horizontal axis and the intermediate values are floating columns as below screenshot shown.
A waterfall chart is used for showing the overall effect by introducing positive or negatives steps.
Include the data label in your selection for it to be recognized automatically by excel. Repeat the same steps for the line section. Select no fill in the fill section and no line in the border section. All you need to do is to enter your data into the table and the excel waterfall chart will automatically reflect the changes.
