No—not as two independently comparable funnels in one standard Excel funnel chart. Excel’s built-in funnel chart is designed to show one value series across stages; to compare two groups, use two matched funnel charts or choose a chart type that supports multiple series.
What an Excel funnel chart is designed to show
A funnel chart shows how a quantity changes through a sequence of stages. A sales pipeline might list Leads, Qualified, Proposals, and Customers, with the count at each stage. Because the values often decrease from one stage to the next, the bars form a narrowing shape. The same idea can describe an application process, a website journey, or steps in a service workflow.
The key structure is one category for each stage and one value for that category. In a worksheet, that usually means a stage column beside a count column. A funnel chart is not a general-purpose container for multiple measures in the way a clustered column chart can be. Selecting two value columns may lead Excel to use only one series, interpret the selection unexpectedly, or produce a chart that does not show two clear, separate funnels. It is better to prepare the data for the comparison you intend rather than assume the chart will arrange two series automatically.
Why two series are not a straightforward fit
In a two-series comparison, each stage has two values: for example, leads and customers from two campaigns. A clustered chart can place the two values beside each other at every category. A funnel chart, by contrast, is organized around a single sequence of stage values. Its narrowing silhouette is the visual encoding, not a set of side-by-side series slots. Excel does not offer a standard two-funnel layout within one funnel chart that makes the two groups easy to compare.
There is also a data-meaning issue. Funnels commonly begin with different starting totals. If Campaign A starts with 1,000 leads and Campaign B with 100, a direct comparison of raw counts mainly emphasizes the difference in audience size. That may be exactly what you need, but it does not by itself show which campaign converts more effectively. It helps to decide whether your question is about volume, conversion, or both before choosing the chart.
Ways to compare two groups
Choose a layout based on what the reader needs to compare. The following options are practical in Excel for Microsoft 365 on Windows:
- Two separate funnel charts: Make one chart for each group and place them side by side. Keep the stage order, chart dimensions, colors, and label treatment consistent. This preserves the familiar funnel shape while letting readers compare stage patterns.
- A clustered bar chart: Put the stages on the vertical axis and show the two series as bars next to each other. This is often the clearest choice when exact counts at each stage matter more than a funnel silhouette.
- A line chart: Use this when the stages are sequential and you want to compare the shape or rate of decline. Lines can make the trend easy to see, though the stage labels are categories rather than equally spaced time measurements.
- A percentage-based comparison: Convert each group’s stage counts to a percentage of its own first-stage total, then compare the two groups in paired charts or a clustered chart. This focuses on relative progression rather than audience size.
- A table with conversion metrics: If precise stage-to-stage conversion rates are the main point, a table with counts and percentages can be more informative than forcing all information into a funnel graphic.
For instance, suppose two campaigns have 1,000 and 600 visitors. At the next stage they have 300 and 240 sign-ups, and later they have 60 and 48 purchases. The first campaign has more people at each stage, but both campaigns convert 30% of visitors to sign-ups and 20% of sign-ups to purchases. A chart of raw totals highlights volume; a percentage view shows that the step-by-step conversion pattern is the same. Neither view is wrong, but they answer different questions.
Build two comparable funnel charts
For separate funnels, make a small two-column table for each group, with stages in the first column and that group’s values in the second. Keep the stage labels in the same order in both tables. In Excel for Microsoft 365 on Windows:
- Select the stage and value cells for the first group, including the headers if present.
- Choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Funnel.
- Repeat with the second group’s table. Move and resize the charts so they have the same dimensions and align their top and bottom edges.
- Add a clear title to each chart, such as Campaign A and Campaign B. Use consistent colors and data labels, and leave the stage names readable.
- Check that both charts use the same unit and that the numbers shown are counts, percentages, or another clearly identified measure.
On Excel for Mac, use the Insert tab and choose Funnel from the chart options; the precise grouping or menu label can vary with the ribbon layout and Excel build. If Funnel is not immediately visible, check the chart-type options on Insert. Excel for the web and different desktop builds may expose different formatting controls, so the Windows ribbon path above is the reference for this guide.
Separate charts are not automatically a shared-scale comparison. For a fair visual comparison, avoid making one chart much larger than the other, and show the actual values so readers are not left to estimate bar widths. If the chart formatting offers control over scale or gap width, keep the settings consistent. If you cannot ensure comparable scaling, use a clustered bar chart or include the numbers prominently rather than implying that the two shapes can be compared precisely.
Use counts, percentages, or both?
Counts answer how many people or items reached each stage. Percentages answer how much of the preceding or starting group progressed. A useful report often shows both, because a percentage alone can conceal scale and a count alone can conceal efficiency.
Be explicit about the denominator. A percentage of the initial stage answers, for example, what share of all leads became customers. A stage-to-stage conversion rate answers what share of qualified leads moved on to proposals. Those figures differ. If you compare two funnels using percentages, calculate each group against the same definition and label the basis directly in the chart title, subtitle, or nearby text.
Also confirm that stages represent the same process in both groups. Comparing one group’s qualified leads with another group’s all leads would create a neat picture but not a meaningful comparison. If people can enter at later stages, return to earlier stages, or skip steps, say so: the classic funnel shape suggests a simple ordered progression and may not reflect the real process.
When another chart type is better
A funnel is most useful when the process has a clear start, ordered stages, and a generally decreasing quantity. If the goal is to compare two values at every stage, a clustered bar chart is usually more direct. Select a table containing the stage labels and both value columns, then use Insert > Insert Column or Bar Chart and choose a clustered bar or clustered column option. A bar chart is often easier to read when stage names are long; a column chart can suit short labels.
For conversion performance, a line chart or a clustered chart of percentages can make the pattern clearer than two raw-count funnels. For a compact dashboard, you can retain two funnel charts and place a small table beside them showing each stage’s count and conversion rate. Avoid using a stacked bar chart simply to make two series appear in one graphic: stacking adds the values together and can make it harder to compare each group independently.
There is no universally best choice. Use funnels when the narrowing process is the story, bars when exact stage-by-stage comparison is the story, and a table when readers need exact figures or several rates. It is reasonable to show a funnel as an overview and a table or bar chart as supporting detail.
Common setup and interpretation problems
- Excel shows the wrong labels or values: Check that each selected range has stage names in one column and numeric values in the adjacent column. Remove blank rows or extra totals from the chart range if they are not part of the process.
- The funnel widens at a later stage: Check the source data and definitions. A rise may be valid, but it can also indicate duplicate counting, inconsistent time periods, or stages that are not mutually exclusive.
- The two charts look dramatically different: Check whether the starting totals differ. Raw counts communicate volume, not just conversion quality. Add percentages or use a percentage-based comparison if efficiency is the question.
- Labels are crowded: Shorten stage names in the chart source or make the charts wider. Do not remove labels that are needed to understand the sequence; a clearly labeled table can provide detail next to the graphic.
- One chart seems to have reversed stages: Confirm the row order in the source data and inspect the chart’s category-axis settings. Keep the order identical in both charts so the comparison is not accidentally reversed.
Before sharing the workbook, verify that the chart includes the intended stages and that its title explains the population and period, such as Qualified leads by month or Customer journey, Q2. A funnel chart can look polished while still comparing different dates, definitions, or denominators, so those checks matter as much as formatting.
Frequently Asked Questions
Can an Excel funnel chart show two series?
Excel’s built-in funnel chart is intended for one value sequence across stages, not two clear, independent funnels in a single chart. Use two matched funnel charts or select a chart type such as clustered bars for a direct two-series comparison.
How do I compare two funnels in Excel?
Create one funnel chart for each group, using the same stage order and matching dimensions and formatting. Add the values as labels or place a comparison table nearby, and decide whether raw counts or percentages answer your question.
Can I put two funnel charts next to each other?
Yes. Create each chart from its own stage-and-value table, then move and resize them on the worksheet. Align their edges and use consistent titles, colors, and labels to make the comparison easier to follow.
Should funnel charts use counts or percentages?
Use counts when the number of people or items at each stage is important. Use percentages when comparing progression relative to a starting group or a prior stage. For a useful comparison, state the denominator and consider displaying both measures.
What chart is best for two sales funnel series?
A clustered bar chart is often best when readers need to compare the two counts at every stage. Use paired funnels when the process shape is important, and add conversion percentages if the groups have different starting totals.
Related
- Excel Dependent Drop-Down Lists With Spaces: Setup Guide
- Excel Dependent Drop-Down List: 3 Levels
- Excel Dependent Drop-Down Lists with Dynamic Ranges
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Access Power Pivot in Excel 365: Enable and Use ItTo access Power Pivot in Excel for Microsoft 365 on Windows, open File > Options > Add-ins, choose…
- Bar Chart Examples in Excel: How to Create and ChooseUseful bar chart examples in Excel include comparing sales by product, survey responses by answer, or monthly results…
- Double Stacked Bar Chart in Excel: How to Create OneTo create a double stacked bar chart in Excel, put each bar you want to compare on its…
- Excel Pivot Table Group Error: Causes and FixesWhen Excel shows “Cannot group that selection” in a PivotTable, the selected field usually contains blanks, errors, or…
- Excel Copy Trendline Equation to a Cell: What WorksYou cannot directly link an Excel chart’s displayed trendline equation to a worksheet cell with a built-in formula.…
- Google Sheets Chart Legend Labels: Edit and FixIn Google Sheets, chart legend labels usually come from the headings in the chart’s source data: edit the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.