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

To create a funnel chart in Excel, place each process stage in one column and its value in the next, sort the stages from largest to smallest, select both columns, then choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Funnel. A funnel chart makes it easy to compare values as they pass through stages such as website visits, sign-ups and purchases. You will need Excel for Microsoft 365 on Windows and a small, clearly labelled set of stage data.

What You’ll Need

Excel for Microsoft 365 on Windows. The Funnel chart type is also available in supported perpetual desktop versions such as Excel 2019 and later. If you do not see it, check your Excel version or use the desktop app rather than assuming the feature is missing from your data.
A table with one column for stage names and one column for numeric values. For example, use stages in A2:A6 and counts in B2:B6, with headers in row 1.
Values that describe the same kind of thing at every stage, such as people, orders, or applications. Keep the stages in the order you want to explain, usually from the largest count to the smallest.

Step-by-Step

Set up the source table. In a blank worksheet, enter a heading such as Stage in A1 and Count in B1. Add one stage per row underneath. For a sales process, rows might be Visitors, Product views, Added to cart, Checkout started, and Purchases. Enter the count for each stage in column B. Keep stage names concise so they remain readable beside the chart. Use a single row per stage and avoid merged cells.
Check that the values are suitable. Make sure every value is a number, not text that only looks like a number. Select the value cells and check that Excel treats them as numeric; numbers stored as text may align differently from ordinary numbers. Remove currency symbols or explanatory text from the cells if those are not part of the underlying values. Use a consistent unit and date range across all stages. A funnel is most useful when the values generally decrease as the process advances.
Put the stages in a meaningful order. Arrange the first, largest stage at the top of the table and later stages underneath, usually with each later value smaller than the one before it. For example, 1,000 visitors, 420 product views, 150 cart additions, 90 checkouts, and 60 purchases tell a plausible narrowing story. Excel uses the source categories to label the chart, so a deliberate source order makes the chart easier to understand. Do not sort stage names alphabetically: that can scramble the process sequence.
Select the stage and value data. Select the two columns, including their headings. If the table occupies A1:B6, select A1:B6. Including the headers helps Excel identify the category names and series name. If the columns are not next to each other, select the first range, then hold Ctrl on Windows while selecting the second range. Adjacent columns are simpler and less likely to produce an incorrect selection.
Insert the funnel chart. On the ribbon, choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Funnel. Excel adds the chart to the worksheet using the selected data. If the chart type is not visible on the first menu, open the chart menu and look for Funnel. You can also use Insert > Recommended Charts, open the All Charts tab, and select Funnel if that option is offered by your Excel build.
Confirm the categories and series. Check that the stage names appear as the chart categories and the counts determine the funnel widths. If Excel has interpreted the rows and columns incorrectly, select the chart and choose Chart Design > Switch Row/Column. For a two-column stage table, the expected result is one funnel with several labelled stages, not a separate series for each stage. If the chart shows a legend with a single unhelpful series name, the source headings may not have been included correctly.
Add a title that explains the data. Select the chart, then choose Chart Design > Add Chart Element > Chart Title > Above Chart. Replace the placeholder with a specific title such as Sales Leads by Stage or Online Store Conversion Funnel. A title should identify the process and, where useful, the period covered. Avoid leaving the generic Chart Title text, because it does not tell a reader what the numbers represent.
Show values on the funnel. With the chart selected, choose Chart Design > Add Chart Element > Data Labels, then select a label position that is readable for your chart. Available positions can depend on the chart and Excel build. Check that each label displays the count for its stage and does not overlap the category text. If the labels are crowded, widen the chart or reduce the number of displayed decimal places by formatting the source values as whole numbers.
Improve the layout and appearance. Drag a corner handle to enlarge the chart without distorting it. Use Chart Design > Change Colors to choose a palette with adequate contrast, and select a built-in chart style if it improves legibility. Keep the colors restrained: the funnel should communicate the changes in stage size, not distract from them. If the category names are hard to read, widen the chart area or shorten the labels in the source cells.
Review the chart against the source data. Compare each stage label and value with the table. Check that the largest stage is at the intended end of the funnel and that no row is omitted. Add a note nearby if the chart needs context, such as the reporting period or the definition of a qualified lead. Save the workbook after you are satisfied with the chart and its data.

Common Mistakes

Mixing different measures. A funnel comparing visitors, dollars, and hours is not meaningful because the widths no longer represent comparable quantities. Choose one consistent measure across all stages. If a process tracks both counts and revenue, make separate charts rather than putting both measures into one funnel.
Using values that do not describe sequential stages. A funnel is intended to show a process narrowing from one stage to another. If the stages are unrelated categories, a bar chart is usually a clearer choice. If later stages are larger because they count a different population or time period, explain that clearly or revise the data before charting.
Entering percentages as if they were counts. Values such as 70%, 40%, and 15% show rates, not the number of people continuing through a process. A funnel chart can display the proportions, but readers may mistake them for counts. Label the measure clearly, or use stage counts for the funnel and show conversion rates separately.
Including totals, blank rows, or notes in the selected range. A total row can become an extra funnel stage, while a note row can create a blank or oddly labelled segment. Select only the header and actual stage rows. Keep explanations outside the chart’s source range.
Assuming a narrower stage always means a measured drop-off. A chart shows the values you entered; it does not establish that every individual moved through the process or explain why the numbers changed. Confirm that each stage is defined consistently and that the counts represent comparable groups before drawing conclusions.

Tips

Keep stage names short and specific. Labels such as Qualified leads are more informative than Stage 2. If a longer explanation is needed, add a note next to the chart rather than squeezing a paragraph into the category label.
Include a date range or reporting period. A funnel showing 500 leads is difficult to interpret without knowing whether that count covers a day, month, or year. Put the period in the title or in a nearby text cell.
Use counts for the main funnel and rates for supporting context. If you want to show how many people continue from one step to the next, a separate conversion-rate column in the worksheet can help. Do not include that rate column in the chart’s selected range unless you deliberately want rates, rather than counts, to define the funnel width.
Keep a clean source table. Format the data as a simple two-column range, or use an Excel table when the data will grow. A structured table can make it easier to maintain the source, but check the chart after adding rows to ensure the new stages are included.
Use an alternative chart when the process does not narrow. A funnel can still plot unusual values, but a line or clustered bar chart may communicate increases, comparisons, or changes over time more clearly. Choose the chart based on the question readers need to answer.

Troubleshooting

Funnel is not available in the Insert chart menu: Confirm that you are using a supported desktop version of Excel. If you are in Excel for the web or using an older release, the chart menu can differ. Open the workbook in a current desktop version of Excel for Microsoft 365 and check the Insert chart menu again. On Mac, use the Insert tab and look for the chart options; ribbon grouping and labels can vary by release. If your version does not offer Funnel, use a bar chart as a practical alternative.
The chart contains the wrong labels or extra segments: Select the chart, choose Chart Design > Select Data, and review the chart data range. Confirm that it includes only the two columns of headers and stage data, with no totals or blank rows. Edit the range if necessary, then verify that the category labels point to the stage-name cells.
The chart has multiple funnels or a strange legend: Excel may have read each row as a separate data series. Select the chart and choose Chart Design > Switch Row/Column. If that does not correct it, use Chart Design > Select Data to remove unintended series and select the stage names as the category labels.
Values or labels are missing: Check for blank cells, text-formatted numbers, and values outside the selected range. Re-enter or convert values to numbers, then update the chart selection. To add labels, choose Chart Design > Add Chart Element > Data Labels and select a position. If some labels still cannot fit, enlarge the chart or simplify the displayed number format.
The funnel appears upside down or in an unexpected order: Check the order of the source rows first. Move the stages into the intended sequence, with the largest stage first if that is how you want the chart to read. If the category direction still looks reversed, select the category axis and inspect Format Axis options; the wording and available settings can vary between Excel versions. Avoid changing the underlying process order without checking the labels.
The funnel looks misleading or uneven: Compare the source values and definitions. A sharp change may be a real drop, a data-entry error, or a change in how a stage is counted. Confirm the source before adjusting the chart’s appearance. A funnel visualizes relative values; it does not automatically calculate conversion rates or validate the data.

Frequently Asked Questions

Can I create a funnel chart in Excel for the web?
Chart support in Excel for the web can differ from desktop Excel and may change over time. If Funnel is not offered in the Insert chart options, open the workbook in the Excel desktop app to create or edit the chart.

Does Excel automatically sort funnel stages from largest to smallest?
Do not rely on automatic sorting to establish your process sequence. Put the stages in the intended order in the source table, then check the chart labels and direction after insertion. The chart should reflect the process you want to explain.

Can a funnel chart show conversion rates?
Yes, if you chart percentage values, but the funnel widths will then represent those percentages rather than the number of people or items. For a clearer report, use counts in the funnel and show conversion rates separately with clear labels.

Can I add more stages after creating the chart?
Yes. Add the new stage and value to the source range, then check whether the chart includes it. If it does not, select the chart and use Chart Design > Select Data to extend the chart data range. Charts based on an Excel table may expand when you add rows, but verify the result.

What should I use if the values increase at some stages?
First confirm that the stages and values are comparable and correctly ordered. If increases are legitimate or the categories are not a narrowing process, use a bar or line chart instead. Those chart types often make increases and comparisons easier to interpret.

Can I change the funnel chart colors?
Yes. Select the chart and choose Chart Design > Change Colors, or apply a chart style from the Chart Design tab. Choose colors that keep labels readable and use a consistent palette if the chart is part of a larger report.

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.