# Excel Waterfall Chart Total Not Showing (3 Easy Solutions)

Get FREE Advanced Excel Exercises with Solutions!

In Office 2016Â and onward versions, Excel offers the Waterfall Chart in its Charts section. Waterfall Charts are effective in depicting positive and negative values. Also, users face an issue known as Excel Waterfall Chart total not showing every now and then while working with Waterfall Charts in Excel.

Letâ€™s say we have a monthly transaction in positive and negative amounts as shown in the image below.

Using the data, we inserted a Waterfall Chart by going through Insert > Waterfall Chart (in the Charts section). However, Excel labels the Total amount in certain color but doesnâ€™t show it as it is supposed to.

In this article, we demonstrate the use of Double-click and the Context Menu to resolve the Excel Chart total not showing issue.

## Excel Waterfall Chart Total Not Showing: 3 Suitable Solutions

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

The Excel Waterfall Chart is not displaying the total in its data points because Excel hasnâ€™t assigned it as the total. To display the total, users need to set the specific values as the total. After setting the total value, the Waterfall Chart will show the total amount in its assigned color.

Steps: Double-click on the total amount in the Chart to fetch the Format Data Point side window. After that, tick the Set as Total option under Series Options.

ðŸ”º After setting the amount as total, Excel automatically displays the total in its respective color in the Waterfall Chart as shown in the picture below.

Read More: How to Create a Waterfall Chart in Excel

### Solution 2: Selecting Context Menu Options to Show Total in Excel Waterfall Chart

Right-clicking on any individual amount offers execution of certain options from the Context Menu.

Steps: Select an individual amount (i.e., the total amount) with 2 consecutive clicks, then right-click to display the Context Menu options. Select the Set as Total option to show the total in the Waterfall Chart.

ðŸ”º The final depiction will be the same as represented in the image below.

### Solution 3: Adding the Missing Total Amount in the Data Source Range

A very silly but common mistake that users make is that they donâ€™t find or include the total amount in the Waterfall Chart Data Source. To resolve the issue, users just have to find the total and then include the total amount in the Chartâ€™s data source. The below image showcases the instance.

Steps: Find the total amount using the SUM function, then follow any above describe solutions (i.e., Solution 1 or Solution 2) to display the total in the Waterfall Chart.

## Conclusion

This article explores the probable reasons and solutions for the Excel Waterfall Chart total not showing issue. We hope these above methods clarify your understanding regarding the issue and resolve it. Comment if you have further inquiries or have anything to add.

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Maruf Islam

My self, Maruf Islam, an engineer and Excel & VBA Content developer on Exceldemy. I enjoy solving problems, finding workable solutions, and most of the part I really like to take on challenges. On Exceldemy I write articles discussing various way outs of Microsoft Excel's stuck ons.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF