Waterfall Charts In Excel. Create waterfall chart in excel 2016 and later versions. Include the data label in your selection for it to be recognized automatically by excel.
Click on the fill line icon. 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. Click the waterfall chart to create your chart.
All you need to do is to enter your data into the table and the excel waterfall chart will automatically reflect the changes.
A microsoft excel template is especially convenient if you don t have a lot of experience making waterfall charts. Start with selecting your data in excel. 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. For example the quantity of an item in an inventory changes over a period of time.
