Excel Stacked Funnel Chart: How to Build One

Charts & pivot tables · Updated November 19, 2026

Excel does not offer a built-in stacked funnel chart: its native Funnel chart displays one value series, not several colored components. To make a stacked funnel, use a 2-D Stacked Bar chart and add a hidden spacer series that centers each stage’s bar; the visible segments then show both the stage total and its composition.

What Excel means by a funnel chart

A funnel chart shows values at successive stages of a process, usually with a wide first stage and narrower later stages. It is commonly used for sales pipelines, application steps, recruiting, and customer journeys. The shape makes loss between stages easy to see, but it does not explain why people or items dropped out.

Excel’s native Funnel chart is designed for a single sequence of stage totals. In Microsoft 365 for Windows, select the stage names and one value column, then choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Funnel. The chart can display the stages as a funnel, but it cannot divide every stage into multiple colored, stacked components.

A stacked funnel is a custom charting arrangement rather than a separate Excel chart type. Its bars are ordinary stacked bars, with empty plot space on the left and right making them appear centered and progressively narrower.

When a stacked funnel is useful

Use this design when you need to compare both the total at each stage and the makeup of that total. For example, a sales team might divide leads at each stage by source: website, events, and referrals. A regular funnel can show the overall count at each stage, but not the source mix within each stage.

Stacking is useful only when each component has a meaningful relationship to the total. If colors represent unrelated measures, or if the chart has many segments, the funnel can become difficult to read. Consider whether readers need to compare component values across stages; stacked bars make the first segment easiest to compare, while segments farther along the stack do not share a common baseline.

Prepare the data and calculate the spacer

Put one process stage on each row, in process order, and place the component values in separate columns. The example below uses four stages and three lead sources. The totals decrease from 1,000 inquiries to 50 wins, and each row’s component values add up to that stage’s total.

  • Inquiries: Website 500, Events 300, Referral 200; total 1,000.
  • Qualified: Website 180, Events 120, Referral 100; total 400.
  • Proposal: Website 60, Events 50, Referral 40; total 150.
  • Won: Website 20, Events 15, Referral 15; total 50.

Set up the worksheet with stages in A2:A5, a spacer in column B, the three components in C2:E5, and totals in F2:F5. Put the component headings in row 1. In F2, with component values in C2:E2, enter =SUM(C2:E2) and fill down through F5. The four resulting totals are 1,000, 400, 150, and 50.

In B2, with totals in F2:F5, enter =(MAX($F$2:$F$5)-F2)/2 and fill down. The spacer values are 0, 300, 425, and 475. Each spacer is half the difference between the largest total and the current stage’s total. That leaves equal blank space to the left and right of each visible bar when the chart’s horizontal scale runs from zero to 1,000.

Keep the total column for calculations and checking, but do not include it as a chart series. The chart uses the stage names, spacer, and component columns; including the total would add an unwanted extra segment.

Build the stacked funnel in Excel

  1. Select A1:E5, including the stage labels, spacer values, and component data. Leave column F out of the selection.
  2. Choose Insert > Insert Column or Bar Chart > 2-D Bar > Stacked Bar. Do not choose 100% Stacked Bar: that chart makes every stage the same full width and hides the change in total size.
  3. Click the spacer series in the chart. Open Format Data Series, then use Fill & Line to set Fill to No fill and Border to No line. The spacer remains in the chart’s calculations but is invisible.
  4. Check that the stage order runs from the first process step to the last. If it appears upside down, right-click the vertical category axis, choose Format Axis, and use Categories in reverse order. Axis options can make the value axis cross at an unexpected edge, so check the chart after changing the order.
  5. Adjust the chart title, legend, and gap width to suit the data. A smaller gap between bars makes the funnel look more continuous; a modest gap can make individual stages easier to distinguish.

The visible bar lengths in this example are 1,000, 400, 150, and 50, each centered on the same horizontal scale. The chart is therefore a stacked bar chart with a funnel-like silhouette, not a native funnel chart. In Excel for Mac, the chart type is also available under Insert, although the formatting pane and labels can differ slightly by release. Excel for the web may expose fewer chart-formatting options than the desktop app.

Format labels, colors, and axes

Give each component a consistent color across all stages and use a legend with clear names. Avoid using similar shades for adjacent segments, especially if the chart will be projected or printed. A descriptive title should identify the population and period, such as “Sales opportunities by source, Q2.” Without that context, stage counts can be mistaken for conversion rates or a complete customer journey.

Data labels can show segment values, but labeling every small segment may clutter the chart. If readers mainly need the stage totals, place totals beside the bars or in a nearby table. The total column in the worksheet is a reliable source for those labels; it does not need to be plotted as a series. If you add labels manually, revisit them when the source data changes so that they do not become stale.

The hidden spacer takes up horizontal axis space, so its formatting and the axis scale matter. For this example, a maximum of 1,000 makes the first stage fill the available width. If Excel chooses an axis maximum larger than the largest total, the entire funnel will look smaller. You can set the horizontal value axis maximum in Format Axis. Keep the same scale when comparing multiple charts; independently scaled funnels can make similar totals look deceptively different.

Read the segments without overclaiming

A stage’s total width shows its count relative to the other stages. Its colored sections show how that stage’s count is divided among the selected components. In the example, the 400 qualified leads consist of 180 website, 120 event, and 100 referral leads. The chart does not prove that exactly 600 particular inquiries failed qualification: that conclusion requires records that link individuals across stages and a clearly defined time window.

This distinction matters when stages contain different cohorts. A funnel may show counts recorded during a period, while later stages include people who entered earlier. In that case, dividing one stage by the previous stage may not produce a meaningful conversion rate. If you calculate rates, define the cohort, date range, and denominator separately and explain them alongside the chart.

Also be careful about what a segment means. If “Website” identifies the original source of a lead, that source should remain attached to the lead as it advances. If the segments instead represent a changing classification at each stage, the colors describe the stage’s current composition, not the movement of the same groups through the process.

Common problems and fixes

  • The bars are all the same width: The chart may be a 100% Stacked Bar chart. Switch to Stacked Bar so totals determine the bar lengths.
  • The funnel is off-center: Check that the spacer formula is half the difference between the maximum total and that row’s total, and confirm the spacer series is the first plotted series.
  • A colored spacer is visible: Select the spacer series itself and set both its fill and border to none. Removing the spacer data would remove the centering effect.
  • The total is too large or the segments do not add up: Check the source values and total formulas. A stacked chart sums its series, so an incorrect component or an accidentally included total column changes the bar length.
  • The bars run in the wrong order: Reverse the category order on the vertical axis, then confirm that the value axis still appears where intended.
  • Small segments cannot be read: Reduce the number of displayed components, use a companion table, or choose a chart that makes precise comparisons easier.

Stacked funnel versus alternatives

Choose the native Funnel chart when the story is a single series of stage totals and a clean funnel shape is the priority. Choose the custom stacked-bar method when the composition within every stage is important and you can maintain the spacer calculations.

A standard stacked bar chart without spacers is often better for comparing component values, because all bars begin at the same baseline and the chart is simpler to update. A clustered bar chart can make segment-to-segment comparisons clearer, though it gives up the single funnel silhouette. A line chart may suit conversion rates across stages, while a table can be best when exact counts matter more than visual shape.

For a polished report, another practical option is to show a native funnel for totals and a separate stacked bar chart for composition. That avoids implying that the funnel’s width communicates more than the stage totals while giving readers a clearer comparison of the segments.

Frequently Asked Questions

Can Excel make a stacked funnel chart automatically?
Not as a built-in chart type. Excel’s Funnel chart handles one value series. To show multiple components per stage in a funnel-like shape, create a Stacked Bar chart and hide a calculated spacer series.

Should I use Stacked Bar or 100% Stacked Bar?
Use Stacked Bar when the overall stage totals should control the funnel width. Use 100% Stacked Bar only when comparing each stage’s percentage composition is the goal; it makes all stages equal in width and no longer shows the funnel’s changing totals.

Can I use negative values to center the bars?
A hidden positive spacer is usually more straightforward. Negative values can alter the chart’s axis and stacking behavior, making the display harder to interpret and maintain.

Why does the first stage not fill the chart?
Excel may have set the horizontal axis maximum above the largest stage total, or the plot area includes extra space. Check the value-axis maximum and set it to the largest total when that scale is appropriate.

Will the chart update when I add another stage?
It updates only if the chart’s source range includes the new row and the formulas are filled down. Converting the source range to an Excel table can make expanding data easier to manage, but check that the chart includes the spacer and component columns and excludes the total column.

Choosing a chart that tells the truth

A stacked funnel can combine process size and composition in one compact view, but it is a visual construction rather than a dedicated Excel chart. Use the native Funnel chart for one series; for a segmented funnel, center stacked bars with a correctly calculated invisible spacer. Then label the stages, disclose what the colors represent, and verify that the chart’s cohort and time period support the conclusions readers may draw from it.

Related

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.