How to Build a Funnel Chart in Excel: Step-by-Step

Charts & pivot tables · Updated November 20, 2026

To build a funnel chart in Excel for Microsoft 365 on Windows, arrange process stages in one column and their values in the next, select both columns, then choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Funnel. The chart shows how values change from one stage to the next, making drop-offs in a sales pipeline, signup journey, or other sequential process easier to see. Before you begin, decide what each stage measures and make sure the values use the same unit and represent comparable points in the process.

What You’ll Need

  • Excel for Microsoft 365 on Windows, with the workbook open and editable. Current Excel versions for Mac also include funnel charts, though the ribbon labels or layout may differ slightly.
  • A small, tidy data table with one column of stage names and one column of numeric values. Include a header for each column.
  • Stage values that describe the same measure at successive points—for example, the number of people at each sales stage. A funnel is most meaningful when values generally decline as the process advances.

Step-by-Step

  1. Define the process and the measure. Decide what the funnel represents before you enter data. A useful example is a sales pipeline showing leads, qualified prospects, proposals, and customers. Choose one measure, such as the number of records reaching each stage. Do not mix a count at one stage with revenue, percentages, or a different time period at another; the chart would compare values that do not mean the same thing.
  2. Lay out the data in two columns. Put a clear heading such as Stage in A1 and Count in B1. Enter one stage per row beneath the headings, with its value beside it. For example, enter Leads and 1,000, Qualified and 600, Proposals and 250, and Customers and 100. These values represent a simple funnel: 1,000 leads progress through the process and 100 become customers. Use actual numbers rather than text such as “1,000 people,” because text values cannot be plotted as numeric amounts.
  3. Check that each row is a stage, not a separate series. The stage labels belong in the first column and the measurements in the second. Avoid adding separate columns for each stage; Excel may interpret those as multiple series, which is not the usual structure for a funnel. If your source data has extra columns, copy the relevant stage and value fields to a clean area of the worksheet first.
  4. Review the sequence and values. Put the stages in the order you want readers to follow from the start of the process to the end. Check that later-stage values do not exceed earlier-stage values unless that increase is real and explained. Investigate blanks, negative numbers, duplicates, and totals included as if they were stages. Keep the values as numbers, and use a consistent unit such as people, orders, or dollars throughout.
  5. Select the chart data. Drag across both columns, including the headings—for the example, select A1:B5. If the data is in a structured Excel table, selecting a cell in the relevant two-column range may be enough, but confirm that the chart includes only the intended stage and value fields. Including unrelated notes or a grand total can create extra slices or distort the visual.
  6. Insert the funnel chart. On the ribbon, choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Funnel. Excel inserts a funnel chart based on the selected range. In current Excel for Mac, use the Insert tab and choose the Funnel chart from the chart options; the menu grouping can vary by build. If Funnel is not available, check that you are using a version of Excel that supports this chart type, or use the bar-chart alternative described in Troubleshooting.
  7. Check the stage order and chart orientation. Compare the displayed labels from top to bottom with the order in your table. If the chart runs in the opposite direction from the process, right-click the category axis, choose Format Axis, and look for Categories in reverse order under Axis Options. The exact axis controls can depend on the chart and Excel build. If necessary, reorder the source rows instead, then check the result again. Do not assume Excel has interpreted your process sequence correctly.
  8. Add a useful chart title and labels. Click the chart title and replace the placeholder with a specific description, such as Sales Pipeline by Stage. To show values, select the chart and use Chart Design > Add Chart Element > Data Labels, then choose an available position. You can also use the Chart Elements button beside the chart in Windows. Labels help readers identify the size of each stage without estimating from the shape. Keep them readable and avoid turning on every label option if the chart becomes crowded.
  9. Format the chart for quick reading. Use Chart Design to choose a restrained chart style or color palette, and use the Format tab for text, fills, and outlines. A single color family can make the stages feel connected; a contrasting color can emphasize the final stage, but do not use color alone to communicate important information. Widen the chart if labels wrap, and use a readable font size. Remove a legend if there is only one data series and it adds no useful information.
  10. Verify what the funnel says before sharing it. Confirm the title, units, labels, stage sequence, and source values. In the example, the final count is 100 out of 1,000 leads, but the chart itself shows counts, not necessarily the conversion rate between each pair of stages. If readers need rates, calculate or report them separately and clearly state the denominator. Finally, resize and position the chart so all stage labels and values are visible, then save the workbook.

Common Mistakes

Using values that are not comparable. A funnel should track one measure through successive stages. Mixing people, dollars, and percentages makes the shape meaningless, even if Excel accepts the data. Choose a consistent unit and explain it in the chart title or a nearby note.

Putting stages in the wrong order. Excel uses the category labels from the source range, but the chart can appear reversed relative to the way you expect to read it. Check top-to-bottom order after insertion. Reorder the rows or use the category-axis option where available; do not rely on a familiar label order to guarantee the chart orientation.

Adding totals or unrelated rows. A grand total is not another process stage. Including it can make the first section unusually large and obscure the actual progression. Exclude totals, blank rows, subtotals, and notes from the selected chart range.

Assuming the chart explains why people drop out. A funnel displays the size of each stage, not the cause of a decline. A large gap may reflect a real loss, a changed definition, or data collected over different dates. Confirm the underlying data and define each stage before interpreting the shape.

Confusing stage counts with conversion percentages. A data label that displays a count does not tell readers what share moved to the next stage. If you show percentages, state whether they are a share of the original group or a stage-to-stage conversion rate. Those are different calculations and should not be presented as interchangeable.

Tips

Use short, distinct stage names. Labels such as Qualified lead and Proposal sent are more informative than Stage 2 and Stage 3, but overly long labels can crowd the chart. If you need definitions, keep the chart labels brief and add a small note or a supporting table beside the chart.

Keep the reporting period consistent. For example, do not compare this month’s leads with last quarter’s customers unless the chart is intentionally describing cohorts over time. A funnel often represents one cohort moving through a process, so make clear whether values are current totals, period totals, or a tracked group.

Consider placing the source data next to the chart or on a clearly named worksheet. This makes it easier for someone else to check the values and update them later. If the source table changes, confirm the chart range still includes new rows; a chart built from a fixed range may not automatically include data added below it.

Use simple formatting to support the comparison. Keep a consistent text size, avoid decorative 3-D effects, and leave enough space for the labels. A funnel is a visual summary rather than a substitute for the underlying data, so make the exact values easy to find. If there are many stages, consider whether a table or a horizontal bar chart would be clearer.

Be cautious with funnel shape as a measure of performance. Funnel widths make relative differences visible, but a small-looking section is not automatically a problem. Compare actual counts and relevant rates, and consider how much volume each stage should reasonably have. Add a note if stages have different eligibility rules.

Troubleshooting

The Funnel option is missing. Make sure you are using a recent Excel version with native funnel chart support, and check that you are on the Insert tab with the full chart options available. Excel for the web or an older desktop installation may present a different set of chart features. If the command is still unavailable, update Excel if your license permits it. As a fallback, build a horizontal bar chart from the stage values and format it to show the progression; it will not have the tapered funnel shape, but it can still communicate the counts.

The chart contains the wrong labels or values. Select the chart, open Chart Design > Select Data, and review the chart data range and category labels. Correct the range so it covers the stage names and the one intended value column, including the header row where appropriate. If Excel has assigned the first row or column incorrectly, use the row/column controls in the Select Data dialog and check the preview before closing it.

The chart looks like bars, or some stages are missing. Confirm that the chart type is Funnel, not a standard bar chart, and that the values are numeric rather than text. Check for blank cells, error values, hidden or filtered rows, and accidental spaces or symbols in the value cells. Re-enter or convert values that were imported as text, then refresh or reselect the chart data.

The order is upside down or unexpected. Compare the source row order with the chart and inspect Format Axis for Categories in reverse order. If changing the axis option does not give the intended result, arrange the source data in the desired order and recreate or update the chart. Also check whether the chart is showing a genuinely increasing value at a later stage; that may be a data issue rather than a formatting issue.

Labels overlap or disappear. Enlarge the chart area, shorten stage names, or reduce the number of displayed label elements. Try another data-label position from Chart Design > Add Chart Element > Data Labels. If labels still cannot fit, leave exact values in a nearby table and keep only the most useful labels on the chart.

Frequently Asked Questions

What data format does an Excel funnel chart need?
Use one column of stage names and one adjacent column of numeric values, with a header row. Each row should represent one stage of the same process and the same measure.

Can I make a funnel chart with percentages?
Yes, Excel can plot percentage values if they are numeric and formatted as percentages. Make sure every stage uses the same denominator, or label the chart clearly if the percentages represent different calculations. For stage-to-stage conversion rates, show the calculation or a separate rate column so readers know what each percentage means.

Why does my funnel chart increase toward the bottom?
The values or category order may not match the process direction. Check the source numbers first, then check the category-axis order. If the data truly increases at a later stage, explain why—for example, if a stage includes records from more than one source.

Can I add or remove a stage after creating the chart?
Yes. Add or remove the row in the source data, then check whether the chart range updated. If it did not, select the chart and use Chart Design > Select Data to adjust the range. A chart based on an Excel table is often easier to maintain as rows are added, but verify the chart after changing the table.

Can Excel show conversion rates on the funnel automatically?
A funnel chart can display the plotted values, but you should not assume its labels are stage-to-stage conversion rates. Calculate or provide the rates separately, identify the numerator and denominator, and make the labels clear. This prevents a count or share of the total from being mistaken for a conversion rate.

What if I have too many stages for a funnel chart?
There is no fixed ideal number, but too many narrow sections and long labels make the chart difficult to read. Group related stages where that is analytically appropriate, or use a table or horizontal bar chart to show every value clearly. Keep the detailed data available so a simplified visual does not hide important differences.

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.