Funnel Chart with Multiple Measures in Excel?

Charts & pivot tables · Updated November 20, 2026

Excel’s built-in funnel chart is designed to show one measure across a sequence of stages, so it does not create a standard, directly comparable funnel for several measures at once. To compare multiple measures, use separate funnel charts with the same stage order, or choose a clustered bar chart when seeing the measures side by side is more important than the funnel shape.

Why Excel funnels are limited to one measure

A funnel chart represents a process that narrows from one stage to the next. A sales pipeline might show leads, qualified prospects, proposals, and closed deals; a hiring process might show applicants, interviews, offers, and hires. Each stage has one value, usually a count, and the values often decrease as people or items leave the process.

That simple structure is what makes a funnel easy to read: stage names identify the steps, and bar widths show the size of the measure at each step. A second measure introduces another question. Does it describe a different group moving through the same stages, a different quantity at each stage, or a rate calculated from the first quantity? Those are different comparisons, and putting them into one funnel can make the chart misleading.

For example, leads and revenue are not automatically two comparable funnel series. Leads may be a count at each stage, while revenue may be a currency total. Their scales and meanings differ. A funnel chart does not provide the usual multi-series layout that would let readers compare those measures cleanly. Excel may let you adjust the source range or chart data, but that does not turn the built-in funnel into a reliable side-by-side multi-measure chart.

Choose the right layout for your data

Before making a chart, define what each measure represents and how it relates to the process. The most useful layout depends on the question you want the chart to answer:

  • One measure across stages: Use one funnel. Examples include the number of deals at each sales stage or the number of visitors completing each checkout step.
  • The same measure for several groups: Use separate funnels for groups such as this quarter and last quarter, or use a clustered bar chart to compare the groups stage by stage.
  • Different measures with different units: Use separate charts, or use a table or dashboard with clear labels. Avoid squeezing counts, percentages, and dollars into a single funnel.
  • A measure and its conversion rate: Keep the count funnel and show the stage-to-stage rate in a separate column, table, or chart. A percentage is not another count.

One important check is whether the stages really form a sequence. If values are independent totals rather than successive steps, the funnel shape can imply a drop-off that does not exist. For instance, monthly sales by product category may be useful as a bar chart, but the categories are not stages in a process.

Prepare the source data

For a basic Excel funnel, put the stage names in one column and the single measure in the next. Use one row per stage, with a clear heading in the first row. A small sales example could have the columns Stage and Opportunities, followed by rows for Leads, Qualified, Proposal, and Closed. Enter the values as counts, not as text with units typed into each cell.

Arrange the rows in the process order you want readers to follow, and check that the values make sense for that process. In a strictly narrowing funnel, a later stage should not have more individual items than an earlier stage unless the business definition allows it—for example, if records can re-enter the pipeline or stages count different events. Do not alter valid data simply to make the shape look like a perfect funnel; investigate the definitions instead.

For several groups, keep the data organized in a tidy table with columns such as Stage, Period, and Opportunities. Filter or copy one period at a time to make separate funnels, or use the table as the source for a clustered bar chart. Keeping the original data intact makes it easier to refresh the chart and check that the comparisons use matching stage definitions.

Create a single-measure funnel in Excel

  1. Select the two-column range containing the stage labels and the measure, including the headings.
  2. On the Windows ribbon, choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Funnel. If the option is not visible in your build, look under Insert’s chart options or use Recommended Charts and select the Funnel chart type.
  3. Check that the stage names appear as category labels and the values form the funnel. If the chart picked up the data in the wrong orientation, use Chart Design > Switch Row/Column or correct the selected source range.
  4. Add labels if they help readers interpret the values. Select the chart, then use Chart Design > Add Chart Element > Data Labels and choose a placement that remains readable.

In Excel for Mac, select the source data and use the Insert tab’s chart options; depending on the interface, choose Recommended Charts, open All Charts, and select Funnel. The exact gallery arrangement can vary by release. Excel for the web may also present a different chart gallery, so use the Funnel option if it is available in that version.

Compare multiple measures without distorting the story

If the measures represent comparable groups, separate funnels can work well when the goal is to show each group’s overall progression. For example, create one funnel for the current quarter and one for the previous quarter, each using the same stages and the same units. Place them next to each other, give them consistent widths and formatting, and use explicit titles such as Current quarter and Previous quarter. Readers can then compare the shapes, while the labels provide the actual values.

Separate charts have a limitation: apparent bar widths can be hard to compare if each chart scales itself independently. Whenever the software or layout allows it, keep the chart sizes and scale treatment consistent, and do not rely on width alone to communicate small differences. Put values on the bars or in a nearby table. If exact stage-by-stage comparisons are the main purpose, a clustered bar chart is usually clearer: each stage forms a category, with one bar for each group.

If measures have different units—for example, number of opportunities, conversion percentage, and estimated revenue—do not present them as interchangeable funnels. A more useful dashboard might contain one funnel for opportunity counts, a separate chart for conversion rates, and a clearly formatted table for revenue. Titles and unit labels should make the distinction obvious. This arrangement answers more than one question without suggesting that unlike values can be compared by bar width.

Funnel chart versus bar chart

A funnel is most useful when the process itself matters and the values represent successive stages. Its narrowing silhouette makes drop-off visible at a glance, but the shape gives less precise stage-to-stage comparison than a chart with a common baseline. A reader may notice a large contraction while missing whether two nearby values differ by a small or substantial amount.

A clustered bar chart is often the better choice for multiple groups or measures that share a unit. It shows values on a common axis and makes comparisons at each stage more direct. A line chart can suit a time trend, but it is not a substitute for process stages unless the horizontal axis really represents time or another ordered progression. A table can be the clearest option when readers need exact values, several units, or detailed labels.

Choose the chart according to the comparison, not just the visual style. If the key question is where a single process loses volume, use a funnel. If it is which group performs better at each stage, use a clustered bar chart or carefully aligned small charts. If it is how several distinct metrics relate, a compact dashboard may be more honest and easier to understand than a single overloaded chart.

Formatting and interpretation tips

  • Use descriptive stage names. Short labels such as Qualified or Proposal are easier to scan than internal codes. Explain unfamiliar terms in a note or nearby text.
  • Show values when precision matters. Data labels help readers distinguish similar bar widths. Avoid placing so many labels that they overlap.
  • Keep group formatting consistent. When showing separate charts, use the same colors, order, titles, and stage definitions. A color should mean the same thing in every chart.
  • Make the unit explicit. Label a chart or its axis context as opportunities, people, orders, or another measure. Do not assume the title alone communicates the unit.
  • Explain the time period and population. A funnel for leads created this month is not directly comparable to a funnel of all open leads unless that difference is intentional and disclosed.

Remember that a funnel’s shape can overemphasize proportional change. A drop from 100 to 50 and a drop from 10 to 5 are both a 50 percent decrease, but they represent very different numbers of items. Use data labels or a companion table when both the relative change and the absolute volume matter.

Common problems and how to fix them

The chart shows only one measure. That is a limitation of the built-in funnel’s design, not necessarily a problem with your data selection. Make separate funnels for comparable groups or change to a clustered bar chart for a direct multi-series comparison.

The stages appear in an unexpected order. Check the row order in the source data and arrange it in the intended process sequence. Do not assume the chart will interpret stage names as a workflow or sort them according to your business logic.

The funnel widens at a later stage. Verify the underlying values and the meaning of each stage. The increase may be valid, such as when new records can enter downstream, or it may reveal inconsistent definitions, duplicate counting, or a data-entry issue. The chart cannot determine which explanation is correct.

The labels are cramped or hard to read. Widen the chart, shorten labels carefully, reduce unnecessary decoration, or move detail into a table. If several measures require many labels, switching to a bar chart may solve the problem more effectively than shrinking the text.

Frequently Asked Questions

Can an Excel funnel chart show two measures side by side?
No. Excel’s built-in funnel is intended for one measure across stages, not a conventional side-by-side comparison of multiple measures. Use separate funnels or a clustered bar chart, depending on whether you prioritize the funnel shape or direct comparisons.

Can I compare two sales periods with funnel charts?
Yes. Create one funnel for each period using the same stages, units, and definitions. Keep the charts visually consistent and include the values so readers do not have to estimate differences from the shape alone.

Can I put counts and conversion rates in the same funnel?
That is usually a poor comparison because counts and percentages use different units and answer different questions. Show counts in the funnel and put conversion rates in a separate column or chart with clear labels.

Why is my funnel not decreasing at every stage?
Check the data and the stage definitions. A later value can legitimately be larger if the stages are not mutually exclusive or records can enter midway through the process. If the process should only narrow, review for duplicate records or inconsistent counting.

What chart should I use for multiple measures by stage?
Use a clustered bar chart when the measures are comparable and share a unit, such as counts for two periods. Use separate charts or a dashboard when measures have different units, such as counts, percentages, and currency.

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.