Excel Waterfall Chart: Can You Add an Axis Break?

No: Microsoft Excel for Microsoft 365 does not provide a built-in axis-break control for a native waterfall chart. You can format the value axis or add a clearly labeled visual break as an annotation, but neither makes Excel compress an omitted range; for a genuine scale change, use a different, explicitly explained presentation.

What an axis break would mean

An axis break is a mark showing that part of a numeric scale has been skipped. For example, an axis might show values from 0 to 10, then resume at 90, with a pair of zigzag marks indicating the omitted interval. This can make smaller differences easier to see when values span a very wide range, but it also changes how viewers interpret distances and bar lengths.

A waterfall chart shows how sequential increases and decreases move a running total from a starting value to an ending value. Each change is drawn relative to the preceding total, rather than as an independent bar from zero. That makes a scale break especially consequential: it can make a change appear larger or smaller than it is, and can obscure the relationship between a step and the running balance.

Excel’s native waterfall chart can distinguish increases, decreases, and totals, but it has no setting that inserts a discontinuity into its value axis. Adding a zigzag with a drawing tool may suggest a break to the reader, but it does not alter the plotted values or remove a section of the axis.

What Excel can format in a native waterfall

Excel can change the appearance and scale of the chart without creating an axis break. For example, you can select the value axis, open Format Axis, and adjust available axis options such as bounds or number formatting. These controls can help focus attention on a useful range, but setting a minimum above zero crops the view; it does not create a proper break, and portions of bars may be hidden.

Other useful adjustments include changing the chart title, colors, data labels, and gap width, and identifying important columns as totals. To mark a column as a total, select its data point, right-click it, and choose Set as Total. In Excel for Microsoft 365 on Windows, the axis options appear in the Format Axis pane after you select the value axis. The exact pane layout can vary with the selected chart element and Excel build.

These adjustments are often enough when the problem is simply that small changes are hard to distinguish. If the chart is unreadable because a few unusually large values dominate the scale, first check whether those values are genuine, whether the chart is showing the intended measure, and whether the categories can be separated into meaningful groups. A scale alteration should not conceal an important part of the story.

How to add a visual break symbol

If you need to signal a discontinuity for a presentation or report, you can place a small break mark beside the axis as a manual annotation. This is a drawing, not an Excel chart feature. It should be accompanied by a clear note that identifies the omitted range and explains the scale, so readers do not mistake the picture for an uninterrupted axis.

Select the chart and use Insert > Shapes to choose a line shape. Draw two short diagonal lines across or beside the value axis where you want to indicate the gap.
Add a text box near the mark stating the omitted interval, such as Values from 20 to 80 omitted. Use Insert > Text Box if you need a separate note.
Check the chart at its final display size. Make sure the break mark is visible, does not cover a data label, and is not mistaken for a connector or gridline.
Recheck the annotation if you resize the chart, change its axis bounds, or update the underlying data. A manually placed mark may no longer line up with the scale it describes.

Use this approach only when the discontinuity is deliberate, defensible, and easy to understand. A decorative zigzag with no explanation can imply that Excel has skipped a known interval when the actual chart still plots a continuous scale. For a chart that will be refreshed frequently, manual marks also create extra maintenance: they do not automatically track changes in the data or axis.

Build and check the waterfall before changing its presentation

A well-structured chart may solve the readability problem without a break. Put the step names in one column and the corresponding changes in another, then select the data and choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Waterfall. Excel creates a chart from the selected categories and values. Review the starting and ending figures, and use Set as Total for any intermediate subtotal or other column that should begin at the baseline rather than continue the running movement.

For instance, a department might start at 100, gain 8, lose 5, gain 4, and end at 107. The small changes are visible because they are close in scale to the starting amount. If the same chart includes a one-off adjustment of 900, the axis may expand so much that changes of 4 or 5 become hard to see. Before adding any visual break, check that 900 is a change in the same units and belongs in the same sequence. It might instead be a total mistakenly entered as a change, or an item that deserves its own explanation.

Useful checks include confirming that increases and decreases have the correct signs, that a starting balance is not being treated as an ordinary change, and that totals are marked correctly. A chart can look plausible while communicating the wrong running total if one category is misclassified. Labels and a short source note can help readers verify what the steps represent.

Alternatives when the scale range is too wide

Choose an alternative based on what the reader needs to compare. A break is not always the clearest answer, and changing chart types can change the question the graphic answers.

Split the story into two labeled charts. Show the full sequence in one chart and a focused view of a meaningful subset in another. State the scope and scale of each view, and avoid presenting the focused chart as if it showed the complete range.
Separate exceptional items. If one adjustment is unusual and has a different business meaning, explain it in a callout or show it in a companion chart. Do this only when the separation preserves the logic of the reconciliation.
Use a table alongside the chart. A table can show exact changes and running totals even when the visual scale makes small steps difficult to compare. It is often a better choice when numerical precision matters more than a quick visual impression.
Use a different chart for a different comparison. A line chart may suit a time series of balances; a bar chart may suit comparisons between independent amounts. Neither is automatically a replacement for a waterfall when the point is to explain how sequential changes create a total.
Keep one continuous scale and annotate the values. Data labels, a concise note, or a second view can reveal small changes without implying that an interval has been removed.

A logarithmic axis is not a general fix for a waterfall chart. Logarithmic scales cannot represent zero or negative values in the ordinary way, while waterfall steps commonly involve zero baselines and negative changes. Do not switch to a log scale unless the data and chart type genuinely support that interpretation.

Why a cropped axis is not the same as a break

Changing an axis minimum or maximum limits what is displayed. It does not tell Excel to skip a section and then resume at a different scale. In a waterfall, a cropped range can hide the lower or upper parts of columns, including the baseline or part of a total. That can make the remaining visible bar look like a complete change when it is not.

If you adjust bounds, label the displayed range and inspect every column that touches the cut-off. Ask whether a reader can still see the starting point, the direction and size of each movement, and the final result. If the answer is no, the crop is likely to confuse rather than clarify. For an external report, also consider whether the chart will be viewed without the surrounding explanation.

Common mistakes to avoid

Calling an overlaid zigzag a functional break. It is only an annotation unless the data display itself has been redesigned to omit and rescale an interval.
Omitting the size of the gap. Tell readers exactly which values are not shown. A vague label such as Scale break may not be enough to interpret the chart.
Hiding an unfavorable movement. A break or crop should not make a negative step, a large adjustment, or a material difference easy to miss.
Using a break when the data are simply inconsistent. Check units, signs, totals, and category definitions before changing the visual scale.
Forgetting to update a manual annotation. After refreshing data or resizing the chart, verify that the symbol and note still describe the visible scale accurately.

Frequently Asked Questions

Can I add an axis break to an Excel waterfall chart?
No. Excel for Microsoft 365 has no native command to insert an axis break into a waterfall chart. You can add a labeled drawing as a visual cue, but it does not change the chart’s scale.

Can I make a break by changing the axis minimum?
No. Changing axis bounds crops the displayed range; it does not skip an interval and resume at another scale. In a waterfall chart, cropping may hide part of a column or its baseline, so label the range and check for misleading results.

Can I add a zigzag to show that values are omitted?
Yes, as a manual annotation using a shape, provided you clearly state the omitted range. The zigzag does not adjust the plotted values, and it may need repositioning if the chart or axis changes.

Can I use a logarithmic scale instead?
It is usually unsuitable for a waterfall with zero baselines or negative changes. A logarithmic axis cannot handle zero and negative values in the ordinary way, so it may not represent the steps accurately.

What is the clearest alternative to a broken waterfall axis?
Often it is a full-scale waterfall paired with a clearly labeled focused view or a table of exact changes. Choose the format that preserves the running-total logic and makes any change in scope obvious.

Does Excel for Mac have a built-in break option?
No built-in axis-break control is available for the native waterfall chart there either. Ribbon labels and chart controls can differ by Mac version, but a manually drawn break remains an annotation rather than a change to the scale.

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.