For most Microsoft 365 users, the top pick is Excel’s built-in Funnel chart: it is quick to create, stays linked to your worksheet data, and needs no add-in. Choose a stacked bar chart instead when you need more control over the funnel’s shape or labels; use SmartArt or shapes for a one-off graphic that does not need to update with data.
What to Look For
A good funnel chart makes the movement from one stage to the next easy to understand. Before picking a design, check that your stages are meaningful, consistently defined, and arranged in sequence. A chart cannot fix mismatched data—for example, comparing leads from one month with customers from another—or explain why people leave a process. Add a short title or note if readers need that context.
Data fit: The usual funnel shows a count at each successive stage, such as 1,000 visitors, 620 sign-ups, and 180 purchases. Values generally decline as the process advances. If your figures rise and fall, the visual may still plot them, but readers can mistake the shape for a drop-off story. Consider a bar chart or a table when a funnel would imply a sequence that is not present.
Correct interpretation: Decide whether the widths should represent raw counts or conversion rates. Raw counts communicate the number remaining at each stage. A percentage-only funnel can make rates look comparable, but it does not show how many people those rates represent. Label the measure clearly and do not mix counts and percentages in one series.
Readability: Check that stage names and values remain legible at the size where the chart will be used. Short labels, restrained colors, and direct data labels are usually more useful than a legend or decorative gradients. If there are many stages, long names, or close values, a horizontal bar chart may be clearer than a tapered shape.
Maintenance and sharing: A native chart or formula-driven chart can update when its source data changes. SmartArt and manually drawn shapes usually require hands-on editing. Also consider where the workbook will be opened: Excel for Microsoft 365 on Windows is the reference here; some chart-formatting controls differ on Mac, and Excel for the web may not offer every editing option.
1. Excel’s Built-In Funnel Chart
Best for: A standard stage-by-stage funnel that should be fast to build and easy to refresh. This is the best default for most business reports because it is a real chart, not a collection of manually arranged objects.
Put stage names in one column and the corresponding counts in the next, with one row per stage and no blank rows in the data range. Select the table, then choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Funnel. The chart uses the category labels as stages and the numeric column as their values. If Funnel is unavailable in an older Excel edition, use a stacked bar chart or a shape-based alternative.
Keep the stages in the order you want readers to follow and check the displayed category order after insertion. Excel may reverse the visual order of categories; if that happens, right-click the category axis, choose Format Axis, and adjust Categories in reverse order. Add a concise title and useful value labels from Chart Design > Add Chart Element. A note such as Counts at each stage can prevent confusion between totals and conversion rates.
The main strength is convenience: the chart is linked to worksheet values, so changing a count updates the visual. It is also easy to resize and place in a dashboard. The trade-off is limited control compared with a carefully built stacked bar. If you need unusual spacing, a particular taper, or more elaborate label placement, Excel’s native formatting may not give you the exact look you want. Use it when clarity and low maintenance matter more than pixel-level customization.
2. A Custom Funnel Made from a Stacked Bar Chart
Best for: People who want a clean, centered taper and more control over chart formatting while keeping the chart connected to cells. This method creates funnel bars from a hidden offset series and a visible value series.
For example, place stage names in A2:A6 and counts in B2:B6. Put Offset in C1, then enter =(MAX($B$2:$B$6)-B2)/2 in C2 and fill it down through C6. With counts of 1,000, 620, 300, 120, and 40, the first offset is 0 and the offset for 620 is 190: (1,000 − 620) ÷ 2. The formula centers each bar against the largest count. If your count range changes size, update the formula range as well.
Select the stage names and both numeric series, then choose Insert > Insert Bar Chart > 2-D Stacked Bar. Format the Offset series so it has no fill and no line; format the Count series with a single color or a restrained color progression. You can use Chart Design > Add Chart Element to add data labels and a title. Check the category order and the horizontal axis scale, then remove unnecessary gridlines and the legend if the labels make the series obvious.
This design gives you control over bar thickness, color, spacing, and labels, and it can be refreshed from worksheet data. Its cost is setup and upkeep: the hidden offset series can confuse someone editing the workbook, and the chart can look wrong if the formula range or source values are incomplete. Add a small note in the worksheet explaining that Offset is a chart helper column. Prefer this approach when the native Funnel chart feels too rigid, not just because a stacked bar has more formatting controls.
3. A 100% Stacked Bar for Conversion Rates
Best for: A report that is specifically comparing the share that moves through each transition, rather than the total number of people at each stage. A 100% stacked bar is not automatically a funnel, but a carefully labeled version can make stage conversion easy to compare.
First calculate each transition rate consistently. For instance, divide the count at stage two by the count at stage one, then stage three by stage two. Put the resulting percentages beside their stage names and use Insert > Insert Bar Chart > 100% Stacked Bar if your layout is designed to compare a percentage series with its remainder. Label the chart as a rate comparison and show the actual percentage values. Do not feed cumulative stage counts into this chart and describe the resulting widths as conversion rates; those are different measures.
The advantage is that percentages are explicit and comparable even when the underlying populations differ in size. The drawback is that normalization removes the audience scale: a 50% conversion from 20 people and a 50% conversion from 20,000 people look alike. A 100% stacked bar also does not have the same familiar taper as a conventional funnel. Include the underlying counts in labels or a nearby table when volume matters, and use this option only when percentage comparison is the actual question.
4. SmartArt Funnel
Best for: A presentation or report graphic that needs a polished process illustration but does not need to recalculate from cells. SmartArt is convenient when the funnel is explanatory—for example, showing the broad steps in a hiring process—rather than an analytical chart.
In Excel for Microsoft 365 on Windows, choose Insert > SmartArt, open the Relationship category, and look for the Funnel layout. Enter the stage text in the text pane, then use the SmartArt Design and Format tabs to adjust the layout, colors, and styling. If the Funnel layout is not available in your Excel build, use shapes instead. On Mac, SmartArt is also available from the Insert tab, but layout names and ribbon details can differ slightly.
SmartArt is quick to edit as a graphic, and its stage labels remain grouped with the design. It does not behave like a chart: changing a number in a worksheet will not resize the funnel automatically, and numeric values do not determine each segment’s width. That makes it a poor choice for a recurring performance report or for data where segment sizes carry meaning. Use it for a static process diagram, and do not present equal-sized SmartArt sections as though they accurately represent unequal counts.
5. A Funnel Built from Excel Shapes
Best for: A one-page infographic where brand styling and precise placement matter more than automatic updates. Shapes give you the most direct control over the appearance, but they also place the most responsibility on the person maintaining the workbook.
Choose Insert > Shapes and create trapezoids or other suitable shapes for the stages. Align and distribute them using the shape-formatting controls, then add stage names and values as text inside the shapes or in separate text boxes. Use consistent spacing, clear contrast, and a visible title. For a proportional funnel, size each stage deliberately from the data rather than choosing widths by eye; keep the source counts in a nearby table so readers can verify the values.
Shapes are flexible: you can match a company palette, add annotations, and control each label’s position. The trade-off is that the graphic is not data-linked. If the figures change, someone must revise both the labels and the widths, which creates a risk of inconsistencies. This is a reasonable option for a fixed presentation graphic or a small number of carefully reviewed reports. For regularly refreshed analysis, prefer the native chart or a formula-backed stacked bar.
How to Choose
Start with the job the chart must do. For a straightforward sequence of declining counts, use the built-in Funnel chart. If stakeholders need to compare conversion rates, make the rate—not the funnel silhouette—the focus, and show the underlying volume somewhere nearby. If the stages describe a process but have no measured values, SmartArt or shapes are more honest than a chart that suggests the widths are data-driven.
Then weigh the time and budget. The built-in chart and the other methods above are available within Excel, so they do not require a paid charting add-in. Their cost is your time: a native chart is usually quickest, a custom stacked bar takes more setup, and shapes take the most manual maintenance. If a team already uses a separate reporting platform, compare its refresh and sharing workflow with Excel before adding another tool just for a funnel.
Choose how much customization you really need. Native Funnel is the sensible starting point for most users. Move to a stacked bar if you need better control of labels, color, or bar geometry and are comfortable documenting the helper series. Use SmartArt or shapes only when the graphic is mainly illustrative or static. More formatting freedom is not automatically better if readers have to work harder to understand the values.
Finally, test the chart at its destination size. A chart that looks clear on a wide monitor may become unreadable in a slide, printed page, or narrow dashboard. Keep stage names short, use a small number of meaningful stages, and verify that values are visible without relying on color alone. If labels collide or the shape hides small differences, switch to a horizontal bar chart or add a compact data table rather than forcing the funnel design.
Frequently Asked Questions
Does Excel have a built-in funnel chart?
Yes. In supported desktop versions, select the stage and value data, then use Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Funnel. Availability and editing controls can vary by Excel version.
What data should I use in a funnel chart?
Use one row per ordered stage and one consistent measure, commonly the number of records remaining at that stage. Make sure each count refers to the same cohort or reporting period if you want readers to interpret the differences as drop-off.
Can Excel calculate conversion rates for a funnel?
Yes, but conversion rate is a separate measure from the count at a stage. Calculate each rate using a consistent starting and ending stage, label it clearly, and show counts too when audience size matters. A chart’s appearance alone does not define the calculation.
Why does my funnel appear upside down or in the wrong order?
Excel may display category labels in the reverse of the order in your source range. Right-click the category axis, choose Format Axis, and check Categories in reverse order. Also confirm that the source rows are arranged in the intended process sequence.
Can I make a funnel chart in Excel for the web or on Mac?
Excel for Mac has chart and SmartArt features, though the ribbon layout and some formatting choices may differ from Windows. Excel for the web can open and edit many workbooks, but advanced chart formatting may be more limited; use desktop Excel if a specific control is missing.
Bottom Line
Start with Excel’s built-in Funnel chart for a data-linked view of stage counts: it is the clearest balance of speed, readability, and maintenance for most Microsoft 365 users. Choose a custom stacked bar when you need more control and can maintain its helper data, and reserve SmartArt or shapes for graphics that are intentionally static. Whatever design you choose, label the measure, keep the stages comparable, and show counts alongside rates whenever readers need both.
Related
- Excel Merge Multiple Cells Into One Cell: A Clear Guide
- Excel Merge Two Cells Into One Cell Without Losing Text
- Excel: Merge Data From Multiple Cells Into One Cell
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Microsoft Excel Power Pivot: What It Is and How to Use ItMicrosoft Excel Power Pivot is a data-modeling feature in desktop Excel for Windows that lets you combine tables,…
- Pivot Text to Columns in Excel: Split or Reshape?If you mean splitting text from one Excel column into separate columns, select the cells and choose Data…
- Excel School Dashboard: What It Shows and How to BuildAn Excel school dashboard is a visual summary of school data—such as attendance, grades, enrollment, or staffing—organized so…
- Excel Dashboard Templates: How to Choose and Build OneAn Excel dashboard template is a pre-built workbook layout for summarizing data with charts, key performance indicators (KPIs),…
- Excel Trendline Function: Charts and TREND FormulasExcel does not have a worksheet function named TRENDLINE. To draw a trendline, select a chart and choose…
- Excel Waterfall Chart Connector Lines: How to FormatIn Excel for Microsoft 365 on Windows, select the waterfall chart’s data series, open Format Data Series, expand…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.