No: Excel’s built-in funnel chart is designed to show one data series across a set of stages, not several parallel series in one funnel chart. To compare groups, use separate funnel charts or choose a chart type such as a clustered bar chart that supports multiple series.
How Excel’s funnel chart represents data
A funnel chart displays values at successive stages of a process. A common example is a sales pipeline: 1,000 leads, 420 qualified prospects, 160 proposals, and 55 completed sales. The stages are categories, and the counts are the single series of values. Excel draws one bar for each stage, with the bar lengths reflecting the amounts.
In Excel terminology, a series is a set of related values, usually one per category. If you add a second column of counts—for example, one for the current quarter and another for the previous quarter—you have two series. The built-in funnel chart is not intended to show those as two independent funnels side by side, each with its own bars and stage labels. The issue is not simply chart styling; the chart type’s basic layout is a single sequence of stages and values.
That distinction matters because a funnel chart is most useful when the reader needs to follow one process from start to finish. It does not automatically provide a fair comparison between two processes, cohorts, or time periods.
Prepare a one-series funnel data table
For a standard funnel, put the stage names in one column and the corresponding values in the next. Use one row per stage, and order the rows in the sequence you want readers to follow. For example:
- Leads — 1,000
- Qualified — 420
- Proposal sent — 160
- Won — 55
Keep the stage labels clear and consistent. Avoid inserting blank rows inside the data, and use numeric values rather than numbers stored as text. A funnel usually narrows as it progresses, so the values commonly decline. Excel can still chart values that rise at a later stage, but an increase may mean that the process is not a simple loss-through-stages funnel, or that the counts are defined differently. Check the data rather than changing values just to make the shape look conventional.
Also check what each number means. For a sales pipeline, stages might count distinct opportunities that reached each stage. If one opportunity can be counted more than once, or if different stages use different date windows, the visual may imply a conversion path that the data does not actually measure.
Create a funnel chart in Excel for Microsoft 365
- Select the two-column range containing the stage names and values, including the headers if you have them.
- On the ribbon, choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Funnel.
- Review the stage order and labels. If Excel interprets the selected range unexpectedly, select the chart and choose Chart Design > Select Data to check the category labels and plotted values.
- Use the chart’s plus button or the chart-design controls to add useful elements such as data labels and a chart title. Keep the title specific, for example, “Quarter 2 Sales Pipeline.”
If the chart is blank or the stages appear as series rather than labels, revisit the selected range and the settings in Select Data. A common cause is including extra numeric columns or selecting a layout that Excel interprets differently than intended. The Mac version of Excel also has a Funnel chart in its chart options, though ribbon placement and the names or arrangement of controls can differ. Excel for the web may have fewer chart-editing controls than the desktop app; if a formatting option is missing, open the workbook in Excel for Microsoft 365 on Windows or Mac.
Ways to compare multiple groups
The right alternative depends on what “compare” means. If you need to compare the number of people at each stage for two regions, two quarters, or two customer types, a clustered bar chart is often the clearest starting point. Each stage gets a pair of bars, making the absolute counts easy to compare. In Excel, organize stages in the first column and put each group in a separate value column, then select the table and insert a bar chart.
A clustered column chart can also work, but long stage names are often easier to read on a horizontal bar chart. If the most important question is the percentage of people who progress from one stage to the next, show the conversion rates in a separate table or chart. Absolute counts and conversion rates answer different questions: a group can have more people at every stage simply because it started with more people, while still converting at a lower rate.
Choose the visual based on the comparison readers need:
- Compare counts at each stage: use a clustered bar chart with one series per group.
- Compare composition as a share of each stage: consider a 100% stacked bar chart, while clearly noting that it hides differences in total volume.
- Show one group’s process clearly: use a single funnel chart.
- Compare several funnels as shapes: use separate, consistently formatted funnel charts, usually side by side.
Workarounds for showing more than one funnel
For a small number of groups, separate funnel charts can preserve the familiar funnel shape. Create one chart per group, place them next to one another, and use the same stage order, colors, and sizing. Keep the units and axis or scale treatment consistent where possible. A shared title and a short note explaining the groups can make the comparison easier to scan. The drawback is that separate charts take more space, and small differences can be hard to judge visually.
Another option is to make a clustered bar chart and format it to emphasize the stage-by-stage comparison. This generally works better when the key question is “Which group has more at this stage?” rather than “What does each group’s funnel look like?” Give each series a distinct, color-blind-friendly color and include a legend. If the values span very different ranges, consider whether a logarithmic scale is appropriate before using it; such a scale changes how differences look and can be confusing for readers unfamiliar with it.
A manually constructed funnel using shapes or carefully formatted cells can provide more control over layout, but it is less robust. Shapes may not update cleanly when the underlying values change, and a hand-built visual can make comparisons look more dramatic than the data warrants. If you use this approach, link labels and values to the source data where practical, document the design, and verify it after updates. For a recurring report, a standard chart that updates from a clean table is usually easier to maintain.
Formatting choices that improve the chart
For a single funnel, make the chart’s purpose obvious. Use a descriptive title, display stage names clearly, and consider data labels so readers do not have to estimate values from bar lengths. Format counts consistently—for example, use whole numbers for people or opportunities, and include units in the title or a nearby note when the values represent dollars, visits, or another measure.
Do not rely on color alone to communicate meaning. A single color for the bars is often sufficient; if stages have distinct colors, keep the palette restrained and make sure the colors do not suggest categories or performance differences that the data does not support. Avoid 3-D effects and decorative gradients that make bar lengths harder to compare. If a chart is intended for presentation or printing, check that stage labels remain legible at the final size.
For comparisons across separate charts, consistent formatting is especially important. Use the same group colors in every chart, align the charts, and make the period and population clear. If the charts use different value ranges, tell readers; otherwise, identical-looking funnels may represent very different totals.
Common problems and misconceptions
A frequent misconception is that adding a second value column will automatically produce a second funnel. In a standard Excel funnel chart, that is not a reliable way to create parallel group comparisons. If the chart does not show what you expect, confirm that the selected range contains only the intended stage labels and one set of values. Use a clustered bar chart or separate funnels when you need separate groups.
Another problem is assuming that a narrowing shape proves a particular conversion rate. Bar widths show stage values, but the chart itself does not explain why values changed, whether the same people were followed through every stage, or how long the process took. A funnel also does not replace a well-defined denominator. Add context such as date range, cohort definition, and whether the figures are counts or percentages.
Finally, do not sort stages alphabetically or from smallest to largest if that breaks the process sequence. The order should reflect the real workflow. If the plotted order appears reversed, check the category order in the chart and adjust the source table or axis settings rather than silently relabeling stages.
Frequently Asked Questions
Can an Excel funnel chart have two series?
Excel’s native funnel chart is designed for one series of values across stages. It does not create two clear, independent funnels in one chart. Use separate funnel charts or a chart type such as clustered bars for a direct comparison.
Can I compare this year and last year in one funnel chart?
Not as two parallel funnel series using the standard funnel chart. Use a clustered bar chart to compare this year’s and last year’s counts stage by stage, or make two consistently formatted funnel charts if the funnel shape is important.
Why does my funnel chart show the wrong labels or values?
Excel may have interpreted the selected rows and columns differently than intended. Check the range and use Chart Design > Select Data to confirm that stage names are the categories and the single value column is the plotted series.
Can a funnel chart show percentages instead of counts?
Yes, you can put percentage values in the chart’s value column, provided they are numeric percentages and the chart communicates what each percentage uses as its denominator. A percentage of the starting group is not the same as a conversion rate from the immediately preceding stage, so label the measure clearly.
Is a funnel chart the same as a sales pipeline chart?
A sales pipeline is one common use, but the chart is not limited to sales. It can show counts across sequential steps in a process, such as applications reviewed or visitors moving through a sign-up flow. The stages and values still need to represent a meaningful sequence.
Related
- Excel: Find Names in Two Worksheets
- Excel Find the Minimum Value in a Range With Criteria
- Excel Find the Minimum Date With Criteria
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Dashboard Styles: Layouts, Uses, and Design TipsExcel dashboard styles are the visual and structural approaches used to present important measures, trends, and comparisons on…
- Excel Clustered Bar Chart Error Bars: How to Add and FormatTo add error bars to a clustered bar chart in Excel for Microsoft 365 on Windows, select the…
- Excel Area Chart Change Order: Move Series CorrectlyTo change the order of series in an Excel area chart, select the chart and choose Chart Design…
- Pareto Chart in Excel: Create and Read One Step by StepTo make a reliable Pareto chart in Excel for Microsoft 365 on Windows, summarize your categories and counts,…
- How to Add a Line in an Excel Org ChartTo add a reporting line in an Excel org chart, select the employee’s box and use SmartArt Design…
- Excel Clustered Column Chart Overlap: Causes and FixesYes—columns in an Excel clustered column chart can overlap when the series overlap setting is above 0%, or…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.