Yes. Microsoft documents a built-in Waterfall chart in Excel 2016 and later listed editions. The practical workflow is to prepare ordered categories and numeric changes, select the range, choose Insert > Waterfall > Waterfall, mark cumulative points as totals, and reconcile the result to the source calculation.
A waterfall chart shows how successive increases and decreases move a running total from a starting value to an ending value. Microsoft’s support page does not list Excel for the web in its applicability section, so do not assume that the same ribbon and formatting workflow is available there. Menu names can also vary by platform and version.
This guide focuses on the calculation behind the chart as well as the Excel steps. It uses a modeled cost example, separates changes from totals, and includes practical checks for data maintenance. The chart itself is a visual display, not a system of record or an approval workflow.
Define the metric and sign convention before entering data
A positive number has no universal meaning in a waterfall chart. For a cost chart, a positive change might mean more cost. For a revenue chart, it might mean more revenue. Before entering values, agree on the metric, unit, starting value, reporting period, meaning of positive and negative changes, and status of the ending value.
In this example, the metric is project cost in USD. Positive values increase cost and negative values reduce it. The ending number is a modeled cost under these assumptions, not an actual incurred cost unless it has been confirmed against accounting records.
A waterfall chart is interpretable only when the metric, unit, period, and meaning of positive and negative changes are explicit.
Prepare one ordered change per row
For a basic chart, use a category and a numeric value for each sequential point. The starting and ending rows represent cumulative totals. The middle rows represent changes. Keep every value in the same unit and reporting period, and order the rows according to the question the chart must answer.
- Baseline cost: 1,000 USD, starting total.
- Unplanned labor: 100 USD, change.
- Automation savings: -400 USD, change.
- Equipment failure: 200 USD, change.
- Modeled ending cost: 900 USD, ending total.
Reconcile the example before charting: 1,000 + 100 – 400 + 200 = 900. The ending value is not another movement to add to the running total. In a source table, you may use a proposed explanatory field such as row_type with values such as total and change, but Excel does not require that field. The chart setting that anchors a point is applied separately through Set as total.
Choose the data grain deliberately. An executive summary may use one aggregated row per cost driver. An investigation may need separate event-level movements. Do not combine unrelated changes under a vague label, and do not mix budget, actuals, and forecast adjustments without defining their relationship.
Order is part of the analysis. Chronological order may explain what happened over time; category order may explain responsibility; variance ranking may emphasize the largest drivers. The same movements can produce the same ending value while telling a different visual story when reordered.
Microsoft’s chart data selection guidance covers selecting and arranging worksheet data. It does not prescribe a business-specific source schema.
Insert the chart and anchor totals or subtotals
Select the category and value range, including the starting and ending rows. In a supported listed Excel edition, choose Insert > Waterfall > Waterfall. Microsoft also documents creating the chart through the All Charts tab in Recommended Charts.
Excel initially interprets plotted values as sequential changes. A baseline, subtotal, or ending value may therefore appear to float. If a point represents a cumulative value, select that individual data point, open Format Data Point, and enable Set as total. Repeat for each subtotal or total that should start at the horizontal axis. Selecting the entire series opens Format Data Series, which is not the point-level control for this setting.
If a value floats unexpectedly, first decide whether it is genuinely a cumulative total or an incremental change. Correct the chart setting only after confirming that meaning. A misclassified total can make the visual result appear plausible while double-counting the source calculation.
Format the chart for interpretation
Give the chart a specific title and include the unit in the title or nearby context. Add data labels when they help readers see the size of each movement. Microsoft identifies the standard waterfall legend categories as Increase, Decrease, and Total. Use a legend when readers need help interpreting the colors, and keep the visual meaning consistent with the sign convention.
Connector lines show how the endpoint of one column connects to the starting point of the next. Keep them when the running sequence is central to the explanation. If they create clutter, Microsoft documents hiding them through Format Data Series by clearing Show connector lines. Review the chart at its intended display size because labels can obscure small or negative movements.
Formatting cannot repair an incorrect value, sign, unit, row order, or total classification. For general chart labels and editing guidance, see Microsoft’s guide to creating and editing Excel charts.
Keep the row order tied to an explicit analytical question. If the chart is meant to explain chronology, do not reorder movements only to make the largest bars appear first. If it is meant to explain variance drivers, state that ranking rule in the surrounding text.
Reconcile the chart before sharing it
Use an independent calculation rather than relying on the visual shape of the columns. The required relationship is: ending value equals starting value plus every signed change. Check the source range as well as the chart, because an omitted row, duplicate row, text-formatted number, or incorrect range can produce a misleading result.
- The starting value plus every signed change equals the ending value.
- All values use the same unit, scenario, and reporting period.
- Positive and negative signs match the approved metric definition.
- Every cumulative subtotal and final value is marked as a total.
- Category order is intentional and labels identify the movements clearly.
- There are no accidental duplicates, omitted rows, blanks, or text-formatted values.
- The metric owner confirms what the ending value represents.
For financial or executive reporting, ask the responsible finance or project owner to reconcile the final number to the underlying approved record. Preserve source transactions, approvals, reasons for changes, and prior versions separately when those records matter. The chart does not provide that audit trail by itself.
Maintain changing data without treating the chart as a data system
For a manually maintained workbook, update the source range, confirm that the chart includes the intended rows, and repeat the reconciliation after every change. Microsoft’s cited chart instructions document chart creation and formatting. They do not establish automatic synchronization with a particular project-management product, an approval workflow, or a transaction history.
If a team designs a separate governed preparation process, keep raw observations, reported chart rows, and aggregated summaries as distinct entities. One chart row might represent one ordered movement in a scenario and reporting period, while several source events may be deliberately aggregated into it. Keep source identifiers and approval information outside the chart presentation.
The following is an illustrative proposed row schema, not a required Excel or ClickUp field set:
{
"run_id": "forecast-q4-run-2026-10-01",
"scenario_id": "forecast-q4",
"reporting_period": "2026-10",
"sequence_number": 2,
"change_type": "change",
"category": "Unplanned labor",
"change_value": 100,
"unit": "USD",
"row_type": "change",
"source_record_id": "example-source-002"
}At the declared chart-row grain, a proposed identity should include the run, scenario, reporting period, sequence number, and change type. If multiple source records can contribute to one row, retain a separate aggregation mapping rather than reusing the chart-row key for raw observations. A database-backed process should enforce the identity with a unique constraint or transactional upsert when concurrent writers are possible. A lookup followed by an insert is not race-safe.
Deterministic rules are appropriate for required-field checks, numeric parsing, sign validation, unit consistency, arithmetic reconciliation, and duplicate detection. AI is not required for those tasks. It might suggest a category from free-text notes, but a person should approve any suggestion that could change financial interpretation. Assign a source-data owner to resolve missing identifiers or conflicting classifications.
Waterfall charts, Gantt views, and templates solve different problems
Explain movement in a value
Use it to show how sequential increases and decreases bridge a starting number to an ending number, such as a modeled cost variance.
Plan work over time
Use it to organize dates, phases, dependencies, and task progress. It does not show a running total of financial or operational changes.
ClickUp’s Waterfall Management template is documented as a project-management workspace. Its Waterfall Project Management template is documented as a project-management List template. The Gantt Timeline template supports timeline and task planning. The reviewed pages do not document any of these templates as an Excel waterfall-chart generator.
Choose by output: use an Excel waterfall chart to explain sequential changes in a numeric total, and use a project or Gantt view to plan phases, dates, dependencies, or task progress. For help structuring ClickUp task workflows rather than creating the Excel chart, see ClickUp setup and automation support.
Common questions about waterfall charts in Excel
Which Excel versions have a built-in Waterfall chart?
Microsoft lists Excel 2016 and later editions on its Waterfall chart support page, including listed desktop and mobile editions. The reviewed page does not list Excel for the web, so it does not confirm that the same workflow is available there. Older versions may require a different or manually constructed chart method.
Why is my total column floating?
Excel may be treating the point as a sequential change. Confirm that it represents a cumulative value, select that individual data point, and enable Set as total.
Should savings be entered as negative values?
Only when savings decrease the metric being charted. In the cost example, savings are negative because they reduce cost. Define the sign convention for the metric rather than applying that rule universally.
Can a chart contain multiple subtotals?
Yes. Mark each cumulative subtotal point individually as a total, then check each subtotal against its independent source calculation.
Why does the ending value not reconcile?
Check for a reversed sign, a missing or duplicated change, a cumulative total treated as another change, inconsistent units, text-formatted values, or a chart range that omits an intended row. Recalculate independently and ask the metric owner to resolve any ambiguity.