Excel Waterfall Chart Split Bar: How to Show Components

Excel’s built-in Waterfall chart cannot split one bar into stacked segments. To show what makes up a change, either add separate, consecutive waterfall steps for its components or build a custom chart; the first option is simpler and keeps the running total accurate.

What “split bar” can mean

People use “split bar” to describe several different chart effects. In a waterfall chart, they usually mean dividing one increase or decrease into colored parts while keeping those parts inside the same category. For example, a single “New sales” bar might be divided into Online and Retail segments. That is different from splitting a bar into several consecutive steps, where each component gets its own category and the chart shows the running balance after each one.

It can also mean a broken axis: a gap in the value scale that makes a very large or small value easier to display alongside other values. A broken axis does not show the composition of a change, and it is not the same as splitting a waterfall bar. If the goal is to explain what contributed to a net change, use component steps or a custom segmented design rather than an axis break.

What Excel’s Waterfall chart can and cannot do

A waterfall chart shows how a starting value changes through a sequence of positive and negative contributions before reaching an ending value. Excel draws each change from the previous cumulative level, so the bars appear to float rather than all starting at zero. The chart is useful for explaining profit bridges, budget movements, inventory changes, and other reconciliations.

In Excel for Microsoft 365 on Windows, select the category and value data, then choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Waterfall. Excel assigns colors to increases, decreases, and totals. You can designate a point as a total by right-clicking that data point and choosing Set as Total. A total bar starts at the chart baseline, rather than floating from the preceding value.

The built-in chart treats each row as one change or total. It does not provide a setting to turn one change into a stack of independently colored subsegments. Changing a bar’s fill color only changes the appearance of the whole data point; it does not create component values or show their separate contributions. This limitation is why a “split bar” usually requires a different data layout or chart type.

Best option: show components as consecutive steps

For most reports, consecutive steps are the clearest and most dependable solution. Suppose a starting balance is 100, Online adds 18, Retail adds 12, and Returns subtracts 5. The running value becomes 125. Instead of one “Sales” bar of 30 split into two colors, show Online and Retail as separate positive steps. Viewers can read the contribution of each channel and see how the cumulative figure changes.

To create this version:

Arrange the data in order, with a category column and a value column. Include the starting value, each component change, and the final value.
Select the data and insert a Waterfall chart using the ribbon path above.
Right-click the starting bar and choose Set as Total. Do the same for the final value, if it is shown as an ending balance.
Add a clear chart title and, if useful, data labels from Chart Design > Add Chart Element > Data Labels.
Check that the categories are in the intended sequence and that the ending total reconciles to the start plus all changes.

For the example, the arithmetic is 100 + 18 + 12 − 5 = 125. If the original chart had a single +30 “Sales” step, replacing it with +18 and +12 preserves the same ending value while revealing the two contributions. The trade-off is a wider chart with more category labels. Short labels, a larger chart area, or a deliberate line break in a category name can help, but avoid shrinking text until it becomes hard to read.

This method works especially well when the components are genuine sequential changes. It is less suitable if the chart must show “Sales” as one summary category and the subcomponents only as a visual breakdown. In that case, a custom chart or a companion breakdown chart may fit the reporting goal better.

Custom chart for a single segmented-looking bar

A custom chart can create a floating bar made of multiple segments, but it takes more setup than a native Waterfall chart. A common approach is to use a stacked column chart: one hidden series positions the visible segments at the cumulative starting level, and other series represent the component sizes. The category axis can then show one bar for the combined change, with a distinct color for each component.

This is most straightforward when all components move in the same direction. For a starting value of 100 and positive components of 18 and 12, the visible pieces can occupy the range from 100 to 130. The hidden positioning series supplies the starting height; the two visible series supply the segment lengths. The final value is 130, just as it would be in a standard waterfall. You must also include the other categories and totals in the helper data if you want the custom chart to represent a complete bridge.

In Excel, create the helper series in worksheet cells, select that data, and choose Insert > Insert Column or Bar Chart > Stacked Column. Format the positioning series with No Fill and No Line, then assign separate fills to the component series. Use the chart’s data labels or add labels with text boxes if the component names need to appear inside the segments. Text boxes are manual annotations, so check their positions after resizing the chart or changing the data.

This is not a native Waterfall chart, even if the result looks like one. Excel will not automatically apply Waterfall total behavior or maintain the floating positions when values change unless the helper data and chart series are designed to do so. A custom chart is appropriate when the segmented appearance is essential and someone can maintain the supporting data. For a chart that must update simply and reliably, sequential native waterfall steps are usually safer.

Positive, negative, and mixed components

Component direction matters when designing a custom segmented bar. If every piece is positive, the pieces can stack upward from the previous cumulative value. If every piece is negative, a custom chart can represent the total drop, but the helper layout and the order in which segments appear need careful attention. Test the chart against the underlying arithmetic rather than assuming the colors or stacked order communicate the intended sequence.

Mixed-sign components are harder to show as one contiguous stack. Imagine a category containing +20 and −8, for a net change of +12. These are offsets in opposite directions, not two pieces that naturally fill a single bar extending from the starting value to the ending value. A simple stacked column may put positive and negative series on opposite sides of zero instead of arranging them as a meaningful floating segment. In this case, show +20 and −8 as separate waterfall steps, or use a purpose-built diagram that clearly labels each component and its direction.

There is also a difference between components and a sequence. If a report says that a total change consists of several independent contributions, the components may not happen in chronological order. The chart can still show them as consecutive steps to explain the arithmetic, but readers may mistake that visual order for a timeline. Label the chart or add a note explaining that the steps are a decomposition, not events occurring one after another.

Formatting and readability

A split or component-focused waterfall is only useful if readers can distinguish the categories and understand the sign convention. Keep increase and decrease colors consistent across the chart, and use a separate, neutral color for totals. If each component needs a unique color, add a legend or direct labels; a palette of similar shades without a key can make the segments difficult to interpret.

Show values where they help. Data labels can make small changes easier to compare, but too many labels may overlap. Consider labeling only the component bars or the final total.
Use descriptive categories. “Online” and “Retail” are easier to scan than codes that require a separate lookup.
Check the axis scale. A truncated vertical axis can make modest changes look dramatic. Use a scale that supports an honest comparison.
State the unit and period. A title such as “Quarterly operating profit change ($000s)” tells readers what the values represent.
Preserve the reconciliation. Make sure the visible increases and decreases add to the displayed ending value. Rounding can cause a small difference, so explain it when material.

On Windows, chart commands appear on the ribbon when the chart is selected, and point-specific options appear when you right-click a data point. Excel for Mac has comparable chart and formatting controls, though the ribbon layout and context menus can differ slightly. Excel for the web may expose fewer chart-formatting controls than the desktop app; if a custom chart needs detailed series formatting, open the workbook in the desktop version of Excel.

Common problems and how to fix them

The starting or ending bar floats. Right-click the relevant point and choose Set as Total. Excel does not always infer which intermediate values are subtotals, so verify every intended total.

The ending value does not match the components. Check the source values, signs, and order. A negative change should be entered as a negative number. Confirm that the displayed ending value equals the start plus all increases and decreases; if there are hidden rows, filters, or rounded values, check whether they explain the difference.

The chart shows one solid bar instead of segments. That is expected for the built-in Waterfall chart. It cannot convert a data point into a stacked bar. Add separate component rows or use a custom stacked-column construction.

Colors change unexpectedly. Native waterfall colors are associated with increases, decreases, and totals, not with a unique identity for every business component. If component-specific colors are important, use direct formatting carefully or choose a custom chart with a series for each component.

The chart becomes crowded. Too many steps can make labels unreadable. Split the story into a summary waterfall and a separate detail chart, or show only the most important contributors and group the remainder as “Other.” Do not group items if doing so would hide a material offset or make the reconciliation misleading.

When to use another chart

A waterfall chart is best when the point is to explain how a starting value reaches an ending value. If the real question is how categories compare with one another, a clustered bar chart may be clearer. If the aim is to show composition at one moment, use a stacked bar or stacked column chart. Those charts show totals and parts, but they do not naturally communicate a running balance across multiple gains and losses.

A useful compromise is to keep the native waterfall for the overall bridge and place a small stacked bar beside it to break down one important change. This preserves the easy-to-read cumulative story while showing the composition in a chart type designed for parts of a whole. Make the connection explicit with matching labels and units. Avoid making the stacked chart’s total look like a separate waterfall result.

Frequently Asked Questions

Can you split one bar in an Excel Waterfall chart?
No. Excel’s built-in Waterfall chart formats each data point as one increase, decrease, or total; it does not support stacked segments within that point. Use separate component steps or build a custom chart.

How do I show a total in an Excel Waterfall chart?
Right-click the data point that represents the total and select Set as Total. Repeat for any other subtotal or final balance that should start from the chart baseline.

Can I give every waterfall bar a different color?
You can format individual data points, but a standard Waterfall chart’s main color categories are increases, decreases, and totals. It does not automatically assign a unique color to each business category. A custom chart may be preferable if component identity depends on color.

How do I show the parts of one increase without changing the final value?
Replace the single increase with consecutive component increases whose values add to the original change. For example, +18 and +12 replace +30, so the ending balance stays the same while the chart shows both contributions.

Is a split bar the same as a broken axis?
No. A segmented bar displays multiple components within a bar. A broken axis skips part of the value scale. Use a broken axis only when the scale itself needs a deliberate break, and make that break unmistakable to avoid misleading comparisons.

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.