# The Waterfall Chart Total is Not Showing – 3 Solutions

the dataset below showcases a monthly transaction in positive and negative amounts.

Using the data above, a Waterfall Chart was created ( Insert > Charts >Waterfall Chart).

The Total amount is not displayed:

### Solution 1- Using the Double-click to Assign and Display Total in Waterfall Chart

To display the total, set the values as total.

Steps:

• Double-click the total amount in the Chart.
• In Format Data Point, selectÂ Series Options.
• Check Set as Total.

This is the output.

### Solution 2 – Selecting Context Menu Options to Show the Total in an Excel Waterfall Chart

Steps:

• Double-click the total amount.
• Right-click to display the Context Menu options.
• Select Set as Total.

This is the output.

### Solution 3 – Adding the Missing Total Amount to the Data SourceÂ

Find the total and include it in the Chart.

Steps:

## Related Articles

<< Go Back to Waterfall Chart in ExcelÂ |Â Excel ChartsÂ |Â Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Maruf Islam

MARUF ISLAM is an excellent marine engineer who loves working with Excel and diving into VBA programming. For him, programming is like a superhero tool that saves time when dealing with data, files, and the internet. His skills go beyond the basics, including ABACUS, AutoCAD, Rhinoceros, Maxsurf, and Hydromax. He got his B.Sc in Naval Architecture & Marine Engineering from BUET, and now he's switched gears, working as a content developer. In this role, he creates techy content... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF