Horizontal Funnel Chart in Excel: How to Make One

Charts & pivot tables · Updated November 20, 2026

Excel’s built-in Funnel chart is vertical, so it does not directly create a horizontal funnel. To make a horizontal version in Microsoft Excel for Microsoft 365 on Windows, use a stacked bar chart with helper columns that center each stage around the same midpoint; the result is a clear, stepped funnel made from horizontal bars.

What a horizontal funnel chart shows

A funnel chart compares quantities across sequential stages. Typical examples include visitors who view a product, add it to a cart, begin checkout, and complete a purchase, or leads who move from inquiry to qualification, proposal, and sale. A horizontal layout gives each stage a band whose length represents its value. When the values shrink as the process advances, the bands form a funnel-like outline.

The chart is stepped, not a single smooth-sided shape: each stage is drawn as a separate bar. That is often useful because viewers can compare individual stage sizes and read their labels. The centered layout places the narrowing on both the left and right, rather than making all bars start from the same edge as an ordinary bar chart.

Be clear about what the numbers mean. A funnel may show the count remaining at each stage, such as 1,000 visitors, 700 product views, and 120 purchases. It may instead show losses, revenue, or conversion percentages. Those measures answer different questions and should not be mixed in one series. For a standard count funnel, use counts that represent the same cohort or reporting period and that generally decline from stage to stage.

Prepare the stage data

Put stage names in column A and the values to plot in column B. For example, enter the following in A1:B6, with headers in row 1:

  • Visitors — 1,000
  • Product views — 700
  • Added to cart — 420
  • Checkout started — 250
  • Purchases — 120

These are illustrative numbers, not industry benchmarks. Check that the stages are ordered from the broadest entry point to the final outcome. If the underlying figures do not decrease, the shape may not look like a funnel; do not alter valid data just to force that appearance. Investigate whether the stages describe a consistent process and whether they count the same people or events.

Next, add three helper columns: Left spacer, Stage width, and Right spacer in C1:E1. The two spacer series position the visible stage bar around the center. The stage width is the actual value, while the spacer values together make the total width of every stacked bar equal to the largest stage.

Build the centered helper columns

With stage values in B2:B6, enter this formula in C2 to calculate the left spacer:

With the values in B2:B6 and the first stage on row 2, enter in C2: =(MAX($B$2:$B$6)-B2)/2

For the example, C2 returns 0 because the first value, 1,000, is the maximum. In C3 it returns 150: (1,000 − 700) ÷ 2. Copy the formula down through C6. The dollar signs keep the maximum-value range fixed as you fill down, while B2 adjusts to the current row.

With the same layout, enter the actual stage value in D2:

With the values in B2:B6 and the first stage on row 2, enter in D2: =B2

D2 returns 1,000. Copy it down through D6 so the Stage width series contains the values from column B. With this layout, enter the matching right spacer in E2:

With the values in B2:B6 and the first stage on row 2, enter in E2: =C2

E2 returns 0, and E3 returns 150. Copy the formula down through E6. The left and right spacers are equal, so each visible stage is centered. For the 700-value stage, the stacked width is 150 + 700 + 150 = 1,000; for the final stage, it is 440 + 120 + 440 = 1,000. Thus, the chart has a consistent horizontal scale.

Insert a stacked bar chart

  1. Select A1:A6, then hold Ctrl on Windows and select C1:E6 as well. This includes the category labels and the three plotted series while omitting the original values in column B.
  2. Choose Insert > Insert Column or Bar Chart > 2-D Bar > Stacked Bar. Do not choose 100% Stacked Bar: that chart normalizes series to percentages and does not preserve the intended widths.
  3. If Excel assigns the categories or series incorrectly, select the chart and use Chart Design > Switch Row/Column. The stages should be the categories, and Left spacer, Stage width, and Right spacer should be the series.
  4. Right-click the vertical category axis, choose Format Axis, and select Categories in reverse order if necessary to place the first stage at the top. The exact axis position can depend on the current chart settings.

The chart initially shows three colors in each bar. The spacer series are necessary to position the visible bars, but they should not look like meaningful data. Select the Left spacer series and use Format Data Series to set its fill to No fill and its line to No line. Repeat for Right spacer. Leave the Stage width series visible. In current desktop Excel, the Format Data Series pane can be opened by right-clicking the series and choosing Format Data Series; the available formatting controls are in the pane’s Fill & Line section.

Format labels and improve readability

Add labels to the visible Stage width series rather than to the spacer series. Select a visible bar, then choose Chart Design > Add Chart Element > Data Labels and select a position such as Center or Inside End. If Excel adds labels to the wrong series, remove those labels and select the visible series before adding them again. A label may show the value but not the category name, so keep the category axis labels visible or use an appropriate chart title and data labels together.

Formatting choices that usually help include:

  • Use a short, descriptive chart title, such as “Purchase journey by stage.”
  • Use one clear color for the bars, or apply a deliberate color progression if color carries meaning. Avoid suggesting that color represents a measure when it does not.
  • Reduce unnecessary gridlines and remove the horizontal value axis if the labels and values already communicate scale. Keep a scale if readers need to compare bar lengths precisely.
  • Increase the chart height or reduce the gap width in Format Data Series when category labels or narrow bars are hard to read.
  • Use consistent number formats, such as whole numbers with thousands separators, and make sure values are not clipped by the chart area.

To color stages individually, select a data point rather than the entire series and change its fill. This is optional; distinct colors can draw attention to particular stages but may also make the chart look like several unrelated measures. For a report, include units and a reporting period somewhere near the chart so that a value such as 250 has context.

What the chart can and cannot tell you

A horizontal funnel makes relative stage sizes and drop-offs visible, but it does not explain why people leave the process. It also does not automatically calculate conversion rates. In the example, the overall completion rate is 120 purchases divided by 1,000 visitors, or 12%. The rate from checkout started to purchase is 120 divided by 250, or 48%. Those are useful companion measures, but they are not the same thing as the stage counts shown by the bar lengths.

Consider adding a separate conversion-rate column or annotations if the question is about efficiency between stages. Define the denominator explicitly: a stage-to-stage rate typically divides the later stage by the immediately preceding stage, while an overall rate divides the final outcome by the first stage. A chart that places counts and percentages together without explaining the scales can mislead readers.

Also check whether stages are truly sequential. If people can skip a step, return to an earlier step, or enter at different points, the counts may not decrease in a simple chain. In that situation, a funnel may imply a linear process that the data does not support. A grouped bar chart, flow diagram, or cohort table may communicate the process more honestly.

Common problems and fixes

  • The bars all start at the same point. The chart is likely a clustered bar chart, or the spacer series are not included. Use a 2-D Stacked Bar chart and include both helper columns.
  • The whole chart appears as three colored sections. The spacer series are still visible. Set both spacer fills and lines to No fill and No line, taking care not to hide the Stage width series.
  • The stages run in the wrong order. Format the vertical category axis and change Categories in reverse order. Check the result after changing it, since Excel may reposition the value axis.
  • The funnel is off-center or has uneven total widths. Verify that the left and right spacer formulas use the same maximum range and that the width series links to the original values. Avoid typing inconsistent spacer values manually.
  • Values or labels are missing. Check for blank cells, text stored as numbers, or labels added to an invisible spacer series. Confirm that the source values are numeric and the data labels belong to Stage width.
  • Negative values produce an odd shape. This construction is intended for nonnegative stage quantities. Review the measure and choose a chart designed for the actual data rather than forcing negative values into a funnel.

How it compares with Excel’s Funnel chart

Excel includes a dedicated Funnel chart type, available through Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Funnel. It is designed to show stages as a vertical funnel, with categories arranged down the chart. If that orientation suits the report, it is usually simpler than maintaining helper columns in a stacked bar chart.

Use the horizontal workaround when the page layout, dashboard, or reading direction calls for horizontal stages, or when you want direct control over the centered bands. The trade-off is that a regular stacked bar chart needs helper data and formatting. It may also be less obvious to someone editing the workbook why two series have no fill. Label those columns clearly and consider adding a note explaining that they position the visible bars.

Excel for the web can display and edit many existing charts, but chart-type and formatting options can differ from the Windows desktop app and may change over time. If a particular axis or series-formatting control is unavailable in the web interface, open the workbook in desktop Excel. Excel for Mac also provides chart creation and formatting tools, though ribbon placement and some pane details can differ; the Windows menu paths above should not be assumed to match exactly on Mac.

Frequently Asked Questions

Can Excel make a horizontal funnel chart directly?
Excel’s built-in Funnel chart is vertical. A centered horizontal version can be made with a stacked bar chart and invisible spacer series, as described above.

Why use a stacked bar chart instead of a clustered bar chart?
A stacked bar chart places the spacer, visible value, and spacer end to end, letting the value sit in the middle of a fixed-width total. A clustered chart separates series rather than combining them into one positioned bar.

Do the funnel values have to decrease?
No, Excel will plot values that rise or fluctuate, but the result may no longer read as a conventional funnel. Keep the source data accurate and explain any increase, such as repeat entries or a stage that counts a different population.

Can I show conversion percentages as well as counts?
Yes, but make the distinction unmistakable. Keep the bar lengths based on one measure, usually counts, and show percentages as separate labels or in a nearby table with the denominator defined.

Will the chart update when I add another stage?
Not necessarily. Formulas copied into a new row do not automatically guarantee that a chart’s source range includes it. Convert the source data to an Excel table with Insert > Table, or update the chart’s data range and helper formulas when adding stages, then check that the maximum formula covers all rows.

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.