Think-Cell Waterfall Chart: How It Works and When to Use It

A think-cell waterfall chart is a PowerPoint chart that shows how a sequence of positive and negative changes moves a starting value to an ending value. Use it to explain a financial or operational bridge—such as how revenue changes, costs, or business drivers combine to produce a final result—rather than to compare unrelated categories.

What a think-cell waterfall chart shows

A waterfall chart, sometimes called a bridge chart, combines two kinds of columns. Total columns begin at the baseline and represent complete values, such as opening profit or closing profit. Change columns float between cumulative levels: a positive change moves the running total up, while a negative change moves it down. Connector lines, where shown, help the reader follow the running level from one step to the next.

For example, an operating-profit bridge might begin at 500, then show a 120 increase from price, an 80 increase from volume, a 60 decrease from discounts, and a 90 decrease from costs. The arithmetic is 500 + 120 + 80 − 60 − 90 = 550. The final total should therefore be 550. The middle columns explain the movement; they are not separate values that should all be added as if they were independent totals.

Think-cell is a commercial add-in for creating and updating business charts in PowerPoint. Its waterfall chart is useful when a presentation needs a clearly formatted bridge and the ability to adjust the chart as the underlying figures change. It is not a different accounting method: the chart visualizes values and relationships that need to be defined correctly before they are plotted.

How the chart works

The chart keeps a running balance. Starting from the opening total, it adds or subtracts each change in sequence. A change column is positioned at the level reached by the preceding steps, so its height represents the size of that particular change, not the full running balance. The final total is the accumulated result, not simply the height of the last change column.

This distinction is the reason waterfall charts can be more explanatory than a set of ordinary bars. A regular column chart generally anchors each value to a common baseline. A waterfall instead emphasizes movement from one state to the next. It can make the contribution of individual drivers visible, but only if the categories, signs, and total columns are set up consistently.

In practical terms, the chart’s categories describe the steps, and the values describe the changes or totals associated with those steps. A decrease is usually entered as a negative change when the measure itself is increasing or decreasing. For example, if the measure is profit, a cost that reduces profit is shown as a negative impact. The same business event could need a different sign if the chart is measuring expenses instead, so define what an increase means before entering the data.

Creating one in PowerPoint

The exact controls can vary slightly with the think-cell release and PowerPoint platform, but the general workflow is to insert a waterfall from the think-cell chart elements, place it on the slide, and populate its datasheet. Check the current think-cell interface or help documentation if a control is named or arranged differently in your installation.

Prepare the story first. Write down the opening value, the changes in the order you want to explain them, and the ending value. Check that the changes reconcile to the ending total.
In PowerPoint, open the think-cell tab and choose the waterfall chart from its chart or Elements controls. Place the chart on the slide where it should appear.
Enter or paste the category labels and corresponding values in the chart’s datasheet. Use concise labels such as Opening profit, Price, Volume, Costs, and Closing profit. Follow the datasheet’s displayed layout rather than assuming it matches a worksheet template from another chart type.
Identify which columns are totals and which are changes. Think-cell provides controls for treating a column as a total; use the appropriate total setting for the opening value, closing value, and any intermediate subtotal that should restart from the baseline. Confirm the resulting positions visually.
Format labels, number display, colors, and spacing for readability. Then compare the displayed ending figure with the source calculation before presenting or distributing the slide.

Think-cell charts are designed to be edited in PowerPoint, with chart data handled through the associated datasheet. Depending on the workflow and version, data may also be supplied from Excel. If you update source values, check that the slide reflects the intended figures and that any manually entered annotations still make sense.

Choosing the right steps and totals

The order of the steps affects the explanation, even when the final arithmetic is unchanged. A revenue bridge might group related drivers together; a profit bridge might show revenue effects before cost effects. Choose an order that follows the logic of the business question, and use labels that tell the audience what each movement means without requiring a spoken explanation.

Use totals for complete balances. Opening balance, closing balance, and meaningful subtotals are typical total columns.
Use change columns for drivers. Price, volume, mix, hiring, foreign exchange, and one-time items can be shown as movements if they explain the difference between balances.
Keep units consistent. Do not mix dollars, percentages, headcount, or thousands and millions without clearly indicating the scale or providing a defensible conversion.
Decide how to handle rounding. Rounded displayed values may not add exactly even when the underlying figures reconcile. Use consistent precision and explain any material rounding difference.

A useful test is whether a reader can trace the chart from its first total to its last and understand why each step moves in the direction shown. If categories are too numerous, combine minor drivers into a clearly named residual category rather than making every bar too small to read. Do not hide a material difference inside a vague category such as Other without explaining what it contains.

Design and labeling choices

Color can reinforce meaning, but it should not carry the whole explanation. Many presentations distinguish increases, decreases, and totals with separate colors. Apply that logic consistently across the chart and any related slides. If color meanings vary—for example, green means positive in one chart but a business unit in another—add direct labels or a legend so the encoding is unambiguous.

Show units in the title, axis, or labels: for example, USD millions, percentage points, or units sold. Avoid calling a percentage-point movement a percent change unless that is what the data represent. Label the opening and ending totals clearly, and consider showing values on the change columns when exact contributions matter. If labels collide, reduce unnecessary decimal places or shorten category names before shrinking text until it is hard to read.

For a chart in a presentation, the central question is not whether every available formatting option has been used. It is whether the audience can see the starting point, the important drivers, and the ending point at normal slide size. A quick review in slideshow view can reveal unreadable labels or weak contrast that are less obvious while editing.

Common problems and how to check them

The most common error is a sign mistake. If a cost is meant to reduce profit but appears as a positive change, the chart may still look polished while telling the opposite story. Verify the sign of every driver against the metric being measured. A second frequent problem is treating an intermediate movement as a total, or failing to mark a subtotal that should return to the baseline. That changes the visual meaning of the column, even if the number itself is correct.

The ending value does not reconcile: Recheck the source values, signs, omitted drivers, and rounding. Confirm that opening value plus all changes equals the intended closing value.
A column appears to start at zero unexpectedly: Check whether it has been designated as a total rather than a floating change, or vice versa.
The bridge is hard to follow: Reorder categories into a sensible sequence, clarify labels, and remove immaterial steps or group them transparently.
The bars look right but the story is wrong: Check units, whether values are changes versus balances, and whether a label implies causation that the data do not establish.
Values change but the slide does not tell the same story: Refresh or review the chart data, then check manually placed text, footnotes, and callouts for stale figures.

Also be cautious with negative starting balances, reversals, and subtotal conventions. They can be represented, but the audience may need a clear axis, labels, or a short note to understand the baseline and direction. When the calculation is complicated, reconcile it in the source data first instead of relying on the visual to expose every accounting assumption.

Think-cell compared with PowerPoint and Excel

Think-cell is intended for creating presentation charts within PowerPoint and offers a dedicated chart-building workflow. Microsoft PowerPoint also has built-in chart tools, while Excel for Microsoft 365 on Windows includes a native waterfall chart option under Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Waterfall. Exact ribbon wording can vary by release.

Excel can be convenient when the analysis already lives in a workbook or when the chart will be explored alongside a table. A think-cell chart may be preferable when the primary deliverable is a carefully formatted PowerPoint slide and the team uses think-cell’s presentation workflow. PowerPoint’s built-in charts are another option when the required formatting and editing needs are straightforward or an organization does not license the add-in.

These options are not interchangeable in every detail. Formatting behavior, data editing, templates, compatibility, and collaboration depend on the product and version. If a recipient needs to edit the chart, check what they will need installed and whether the delivered file retains the expected editability. On Mac or in PowerPoint for the web, available controls and the workflow may differ from Microsoft 365 for Windows; consult the current product documentation rather than assuming every Windows feature is identical.

Licensing and practical considerations

Think-cell is licensed software, so access depends on the organization’s subscription or license arrangements. Pricing and included features can change, and organizations may negotiate different terms; check think-cell’s current official pricing or ask the organization’s software administrator for the applicable cost. Do not assume that having PowerPoint or Microsoft 365 automatically includes a think-cell license.

Before choosing it for a team, consider more than the chart itself. Relevant questions include whether users can install the add-in, whether their PowerPoint platform is supported for the features they need, how templates are maintained, and whether colleagues who receive presentations can edit the charts. A small team making occasional bridges may find a built-in chart sufficient, while a group producing many standardized slides may value a dedicated add-in workflow.

Frequently Asked Questions

Is a think-cell waterfall chart the same as a bridge chart?
Usually, yes. Bridge chart is another common name for a waterfall chart because the intermediate columns visually connect an opening value to a closing value through a series of changes.

Can think-cell waterfall charts show subtotals?
Yes. A subtotal can be represented as a total column when the chart’s data and total-column settings are configured for that purpose. Check that the subtotal is calculated from the intended preceding steps.

Can I make a waterfall chart in Excel instead?
Yes. Excel for Microsoft 365 on Windows has a built-in Waterfall chart type on the Insert tab. It is a separate workflow from think-cell, so the available formatting and editing controls are not necessarily identical.

Why does my waterfall chart end at the wrong value?
Check that each increase and decrease has the correct sign, all relevant changes are included, and total columns are designated correctly. Then compare the chart’s final value with the independently calculated ending balance.

Do I need think-cell installed to edit a think-cell chart?
Editing capabilities depend on how the chart was created, the software available to the recipient, and the current product and platform versions. Confirm the requirements with think-cell’s documentation or your organization’s administrator before sharing an editable presentation.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.