How to Create a Waterfall Chart in Excel?

Enter your data in two columns: categories in one column and values in the next

Include starting value, increases, decreases, and ending value

Select the data range

Go to the Insert tab

Click the Waterfall Chart icon

Choose Waterfall

Adjust the chart title if needed

Right-click a bar and select Set as Total for starting and ending values

Format colors, labels, and axes as needed

Resize or move the chart if necessary

Suggested for You

Trending Today