How to Add a Funnel Chart in Excel: Steps and Tips

Charts & pivot tables · Updated November 20, 2026

To add a funnel chart in Excel for Microsoft 365 on Windows, put each process stage in one column and its value in the next, select the data, then choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Funnel. A funnel chart turns a sequence of values—such as prospects moving through sales stages—into a visual that makes drop-offs easy to spot. Before inserting it, arrange stages in their process order and use comparable, positive values.

What You’ll Need

  • Excel for Microsoft 365 on Windows, or a version with funnel charts, such as Excel 2019 or later.
  • A small table with one column of stage names and one column of values. Use one value series, with stages such as Visits, Sign-ups, Trials, and Purchases.
  • Values that describe the same measure at each stage, such as the number of people remaining in a process. A funnel is most useful when the values generally decrease from stage to stage.

The example below uses illustrative counts: 1,000 visits, 720 sign-ups, 410 trials, 260 qualified leads, and 180 purchases. Your figures should reflect your own data and definitions.

Step-by-Step

  1. Arrange the source data in two columns. Enter stage names in the first column and the corresponding values in the second. For example, put Stage in A1, Count in B1, Visits in A2 with 1000 in B2, Sign-ups in A3 with 720 in B3, Trials in A4 with 410 in B4, Qualified leads in A5 with 260 in B5, and Purchases in A6 with 180 in B6. Keep each label beside its own value. A header row helps Excel identify the data correctly.
  2. Check that the values describe a consistent measure. If your chart tracks people, use people at every stage; do not mix people, dollars, and percentages in the same value column. For a conventional funnel, each later stage should usually represent a subset of the previous one, so counts tend to decline. Investigate any increase before charting: it may indicate a different date range, duplicated records, or a stage definition that is not comparable.
  3. Select the complete data range. In the example, select A1:B6, including the headers. If your table has more rows, select through the last stage but do not include totals, notes, or unrelated columns. When the data is in an Excel table, clicking a cell in the table may be enough for Excel to recognize it, but selecting the relevant two columns makes the intended chart data clear.
  4. Insert the funnel chart. On the ribbon, choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart, then select Funnel. Excel inserts a chart based on the selected labels and values. If Funnel is unavailable, check that you are using a version that supports this chart type and that the workbook is open in the desktop app rather than a restricted viewer.
  5. Confirm that the stages and values were read correctly. The chart should show five segments labelled Visits, Sign-ups, Trials, Qualified leads, and Purchases, with the largest value at the widest part and later, smaller values narrowing. Excel does not repair inconsistent source data or infer the meaning of your stages. If labels appear as numbers, stages are missing, or the chart has an unexpected shape, return to the worksheet and verify the selected range and cell contents.
  6. Add a clear chart title. Click the chart, then choose Chart Design > Add Chart Element > Chart Title > Above Chart. Click the title box and type a specific description, such as Sales Pipeline by Stage. A title should tell readers what the stages measure; avoid leaving the default Chart Title text or using a vague label such as Results.
  7. Show the values on the segments. With the chart selected, choose Chart Design > Add Chart Element > Data Labels, then select an available position such as Inside End. Labels make the exact counts visible without requiring readers to estimate widths. If Excel offers different label positions in your version, choose one that remains readable on the narrowest segment. To change the number format, right-click a label and choose Format Data Labels, then use the Number options.
  8. Format the chart for easy reading. Select the chart and use the Chart Design and Format tabs to choose a restrained style, adjust its size, or change the fill colour. Keep labels and segment colours high-contrast. If values are counts, a whole-number format with a thousands separator is often easier to scan than decimals. Avoid effects that make the segments look three-dimensional or obscure how their widths compare.
  9. Review the order and update the source if needed. Funnel segments follow the category sequence in the source data; Excel does not automatically reorder your stages into a logical process. If the order is wrong, rearrange the worksheet rows and keep each label with its value. When you edit a value in the selected range, the chart should update. If you add a new stage below the original range and it does not appear, use Chart Design > Select Data to expand the chart data range.

On Excel for Mac, the chart type is available in supported versions, but the ribbon layout can differ. Look on the Insert tab for the chart-type menu and choose Funnel. In Excel for the web, open Insert > Chart and look for Funnel; if it is not offered in your current interface, open the workbook in the desktop app. Menu names and available formatting options can vary slightly by platform and update.

Common Mistakes

  • Including a total row. A grand total is not another process stage. Including it can create an oversized first or last segment and distort the funnel. Select only the stage rows.
  • Mixing measures or time periods. A chart comparing visits this month with purchases from a different period does not describe a real drop-off. Confirm that all stages use the same time window, population, and counting method.
  • Expecting Excel to sort stages. The chart uses the order of the source categories. Put the stages in the sequence you want readers to follow; do not rely on Excel to decide what comes first.
  • Using percentages as if they were stage counts. A funnel chart sizes segments from the supplied values. If you enter conversion rates, the shape represents those rates, not the number of records reaching each stage. Choose values that match the story the chart is meant to tell.
  • Making labels too crowded. Long category names and data labels can compete for space, especially in a small chart. Widen the chart, shorten labels in the source, or remove nonessential labels rather than shrinking text until it becomes difficult to read.

Tips

  • Use one chart for one process. A funnel is clearest when every stage belongs to the same workflow. If you need to compare regions or product lines, create separate charts or use a different chart type rather than trying to combine unrelated processes.
  • Define each stage precisely. For example, decide whether a Sign-up means an account was created or an email address was verified. Consistent definitions make the chart more useful over time and help viewers understand why a value changed.
  • Show context near the chart. Add a worksheet note stating the date range, source, and what qualifies someone for each stage. This is particularly useful when the chart is copied into a report or presentation without its source table.
  • Keep a clean source table. Store the data in a simple two-column range or Excel table, with one header row and no merged cells. A tidy source is easier to select, update, and check when the funnel does not look right.
  • Use labels to clarify, not decorate. If readers need exact counts, show the values. If the values are already printed beside the chart, labels may be redundant. Preview the chart at the size at which people will actually view it.

Troubleshooting

I cannot find Funnel in the Insert menu. Confirm that you are using a version of Excel that supports funnel charts, such as Excel 2019 or Microsoft 365. If you are in Excel for the web and the chart option is missing, open the file in the desktop app. Also check that you are looking in the chart-type menu on the Insert tab, rather than among the regular column or line chart buttons.

The chart shows the wrong labels or only part of my data. Select the chart and choose Chart Design > Select Data to inspect the range. Make sure it includes the stage-name column and the value column, but not blank rows, notes, or a total. You can also delete the chart, select the correct range on the worksheet, and insert it again. Recreating it is often quicker than correcting a badly selected range.

The funnel looks inverted or the stages run in the wrong direction. Check the sequence of rows in the source data first. Move entire rows—not just the labels or values—so each stage remains paired with its count. If the chart is in the intended process order but the visual direction is still not what you want, review the category-axis options by right-clicking the category labels and choosing Format Axis. Available settings may differ by version; do not change the order without checking that the labels still describe the process correctly.

A segment is unexpectedly wide, narrow, or missing. Look for a mistyped value, a blank cell, a zero, or a negative number. Verify that the values are all from the same measure and that a decimal point or thousands separator has not changed a number. Correct the source data, then check whether the chart updates. A funnel with nonpositive or inconsistent values may not communicate a meaningful process.

Labels overlap or are hard to read. Make the chart larger by dragging a corner, use shorter stage names, and select a different data-label position if one is available. You can also format label numbers to remove unnecessary decimal places. If the smallest segment cannot fit a label clearly, remove that label and display the exact figure in a nearby worksheet cell or note.

Frequently Asked Questions

Which Excel versions can create funnel charts?
Funnel charts are available in Excel 2019 and later desktop versions, including Microsoft 365. Excel for the web may offer the chart type depending on the current interface and feature availability. If you do not see it, use a supported desktop version.

Can I add more than one data series to a funnel chart?
A standard Excel funnel chart is designed to display one series across a set of categories. If you need to compare two groups at every stage, consider making a separate funnel for each group or choosing a chart type designed for side-by-side comparison.

Does Excel calculate conversion rates for funnel stages?
No. The chart displays the values you provide; it does not calculate the percentage moving from one stage to the next. Calculate or report those rates separately if needed, and label them clearly so readers do not confuse rates with stage counts.

Can I change a funnel chart to a different chart type?
Yes. Select the chart and choose Chart Design > Change Chart Type, then select another type that suits the data. If the chart is difficult to compare or the stages do not form a single sequence, a bar chart may be easier to interpret.

Why does my chart not update after I add another stage?
The new row may be outside the chart’s source range. Select the chart, choose Chart Design > Select Data, and edit the range to include the added stage. If the chart is based on an Excel table, adding a row directly to the table may extend the source automatically.

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.