Chart & Visualization Issues

Fix Waterfall Chart Missing in Excel for Microsoft 365 Business

Khadija Khan Oct 10, 2026 872 views

Question details

The user is unable to find the Waterfall chart option under the Insert Chart menu in Excel.

How to Fix Missing Waterfall Chart in Excel for Microsoft 365

Product: Excel for Microsoft 365 Apps for business
Device & OS: not provided
Scenario: Attempting to create a Waterfall chart to visualize sequential positive and negative changes in data.
Observed behavior: The Waterfall chart option is completely missing from the Insert > Chart section, even after installing the latest software updates.

Before you start

Ensure your dataset is organized in a simple tabular layout, typically with category names in the first column and their corresponding positive or negative numerical values in the second column.

Solution 1Recommended

Use the Dedicated Waterfall or Stock Chart Menu

Instead of relying on the 'Recommended Charts' section, navigate to the specific chart icon designed for Waterfall charts.

In some updates of Microsoft 365 Business, advanced charts like Waterfall are separated from standard column or pie charts and given their own specific dropdown menu in the ribbon.

Select your source data

Highlight the entire data range you want to visualize, making sure to include both the category labels and the positive/negative numerical values.

Navigate to the Insert tab

Click on the 'Insert' tab located in the top ribbon of the Excel window.

Locate the specific chart icon

In the 'Charts' group, look for the 'Insert Waterfall, Funnel, Stock, Surface, or Radar Chart' icon.

Select the Waterfall chart

Click the dropdown arrow next to the icon and select 'Waterfall' to generate the chart.

Use the Dedicated Waterfall or Stock Chart Menu

Subtotal Setup: Once the chart is inserted, you can double-click specific data points (like the final total) and check 'Set as total' in the formatting pane to anchor them to the horizontal axis.

Solution 2

Verify Microsoft 365 Update Channel

Check your Microsoft 365 installation channel, as some business channels delay the rollout of newer features.

Solution 3

Validate Data Suitability

Ensure your selected data contains valid formatting for a Waterfall chart.

Create Waterfall Charts Easily

Use WPS Spreadsheet for Advanced Data Visualization

If your Excel version limits access to specific chart types, WPS Spreadsheet provides a reliable, full-featured alternative. It includes native support for Waterfall charts, allowing you to seamlessly visualize sequential data changes without dealing with update channel restrictions.

1. Open your data in WPS Spreadsheet: Launch WPS Office, open the Spreadsheet app, and load your existing dataset.
2. Select your data range: Highlight the categories and numerical values you want to include in your visualization.
3. Insert the Waterfall chart: Go to the 'Insert' tab, click on 'Chart', select 'Waterfall' from the list of available chart types, and click 'OK'.

Easily insert Waterfall and other advanced charts with a few clicksHighly compatible with Microsoft Excel (.xlsx, .xls) formatsFree to use with a lightweight, fast-loading interfaceFamiliar layout requiring zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why is the Waterfall chart option greyed out in my Excel ribbon?

The option may be greyed out if your current data selection is invalid, contains merged cells, or if you are editing a file saved in an older compatibility mode (.xls) instead of the modern .xlsx format.

Are Waterfall charts available in Excel 2013 or earlier versions?

No, native Waterfall charts were introduced in Excel 2016 and Microsoft 365. For older versions, you must manually build them using stacked column charts and making the bottom segments transparent.

How do I make a specific bar act as a total in a Waterfall chart?

Click once on the chart to select all bars, then click a second time on the specific bar you want to be the total. Right-click that individual bar and select 'Set as Total' from the context menu.

Excel & Data Problems