Excel for Microsoft 365 includes a built-in funnel chart creator: put stage names in one column and their values in the next, select the data, then choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Funnel. Excel draws the stages in the order you supply, so arrange them from largest to smallest before making the chart.
What an Excel funnel chart shows
A funnel chart displays a sequence of stages as horizontal bands whose widths represent the values at each stage. It is commonly used for processes where a group narrows as it moves forward, such as website visits becoming leads, sales opportunities becoming customers, or applications progressing through review. The narrowing shape makes the overall drop-off easy to see at a glance.
The chart does not calculate why people or items leave a process, and it does not calculate conversion rates for you. It simply plots the values in your source data. A chart can therefore be visually clear while still representing misleading or incomplete information if the stage definitions or counts are inconsistent.
Prepare the data before creating the chart
Use a simple two-column table with one row per stage. Put the stage labels in the first column and the corresponding counts in the second. For example, a sales pipeline might contain Website visits: 1,000; Qualified leads: 400; Product demos: 180; Proposals: 90; and Sales: 36. Use one value for each stage and include descriptive column headings, such as Stage and Count.
Check that the stages describe a coherent progression and that the numbers use the same unit and counting rules. If one row counts people and another counts transactions, the funnel may appear to narrow for reasons unrelated to progression. For a conventional funnel, values usually stay the same or decrease at each stage. If a later stage is larger, investigate whether the data uses a different time period, includes repeat entries, or measures a different population.
- Keep stage names concise so chart labels remain readable.
- Use actual counts or another clearly defined measure, not a mixture of counts and percentages.
- Remove blank rows, totals, and unrelated notes from the selected range.
- Decide whether the chart represents one period, one cohort, or a cumulative process, and label it accordingly.
Create a funnel chart in Excel 365 for Windows
- Enter the stage names and values in adjacent columns, with headings in the first row.
- Sort the stages into the intended top-to-bottom sequence, typically from the largest value to the smallest. Excel uses the order of the source rows; it does not automatically sort stages by value.
- Select the full table, including the headings. For the example above, that means the two columns containing Stage and Count and their five data rows.
- Open the Insert tab. In the Charts area, select Insert Waterfall, Funnel, Stock, Surface or Radar Chart, then choose Funnel.
- Review the result and correct the source range or stage order if the chart does not reflect the process you intended.
You can change the data later by editing the worksheet cells. To adjust which cells the chart uses, select the chart and choose Chart Design > Select Data. This is useful when you add another stage or accidentally included a total row. If the chart is too small to read, drag a corner handle to enlarge it before changing the font size.
Format labels and make the chart easier to read
Give the chart a specific title, such as Sales pipeline by stage, rather than leaving a generic title. Select the chart title and type the replacement. To show values or stage names on the bands, select the chart and use the Chart Elements button beside it, then enable Data Labels. Available label choices depend on the chart and Excel build; if the labels overlap, make the chart wider, reduce the label font size, or keep only the information readers need.
Use the Chart Design and Format tabs to adjust the chart’s appearance. A restrained color scheme is generally easier to interpret than a different strong color for every stage. If color is used to distinguish stages, keep the colors consistent with any related charts and make sure labels remain legible. A title or nearby note should explain the unit and time period, for example, Number of leads, April to June.
For a presentation or report, add context outside the chart when a band alone cannot convey the needed detail. A short note can state the overall conversion, the largest loss point, or the cohort definition. Avoid implying that a visually narrow stage necessarily has the worst performance: funnel band widths show counts, while performance comparisons often require rates.
Worked example: interpreting a sales funnel
Suppose a team records 1,000 website visits, 400 qualified leads, 180 demos, 90 proposals, and 36 sales during a defined campaign. Enter those five stages in that order with their counts. The chart will show the biggest reduction between visits and qualified leads, then smaller bands down the pipeline. That visual change helps readers locate where the largest absolute drop occurs.
Rates add a different perspective. In this example, 400 of 1,000 visits become qualified leads, or 40%; 180 of 400 qualified leads reach a demo, or 45%; 90 of 180 demos receive a proposal, or 50%; and 36 of 90 proposals become sales, or 40%. Overall, 36 of 1,000 visits become sales, which is 3.6%. These percentages are calculated from the example counts; the funnel chart itself does not display or derive them automatically.
The distinction matters because absolute losses and conversion rates answer different questions. The first step loses 600 records, the largest count reduction, but the proposal-to-sale step has a 60% loss rate. If the business question is which stage converts least effectively, calculate and compare stage-to-stage rates separately, then show those rates in labels, a companion table, or another chart.
Common problems and how to fix them
- The funnel widens lower down: Check whether the source values increase at a later stage. If that is valid, retain the real data and explain why; do not alter values just to force a tapered shape. If it is unexpected, review duplicate records, date ranges, and stage definitions.
- Stages appear in the wrong order: Reorder the worksheet rows. The chart follows source order, so sorting values or labels in the sheet is usually the simplest fix.
- The chart includes a heading or total as a stage: Select the chart and use Chart Design > Select Data to correct the range. Keep headings for clarity, but exclude summary rows that are not actual process stages.
- Labels are missing or crowded: Turn on Data Labels through Chart Elements, enlarge the chart, shorten stage names, or show fewer label details. Long labels can be placed in adjacent worksheet cells or explained in a note.
- The chart option is unavailable: Confirm that you selected a usable data range and are working in a version of Excel that supports funnel charts. Older Excel editions may not include the built-in chart type; updating Office or choosing an alternative chart can help.
Funnel charts compared with other chart types
A funnel chart is most suitable when the categories form a sequential process and the values generally decline through it. A horizontal bar chart is often better when the categories are independent, when values rise and fall, or when precise comparisons matter more than the overall narrowing shape. Bars share a common baseline, which usually makes small differences easier to judge.
A 100% stacked bar chart or a table of conversion percentages can be more informative when the focus is the share moving from one stage to the next. A funnel chart emphasizes the size of each stage, not the percentage change between stages. For a process with several cohorts or time periods, a line chart or grouped bars may communicate comparisons more clearly than placing multiple funnels side by side.
Excel’s built-in funnel chart is convenient when the data fits the single-sequence model. If your chart needs custom stage widths, elaborate annotations, or a specialized sales-funnel layout, a purpose-built visualization tool may offer more control. For routine reporting, however, a clear Excel table plus a standard funnel or bar chart is often sufficient.
Excel for Mac and the web
Excel for Mac also supports funnel charts in current desktop versions of Microsoft 365. Select the data and look for Funnel in the Insert tab’s chart gallery; the exact grouping or menu presentation can differ from the Windows ribbon. Once inserted, the same principles apply: order the worksheet rows deliberately, verify the source range, and format the labels for readability.
Excel for the web may present chart creation and formatting controls differently from the Windows desktop app, and available options can vary. If you cannot find the funnel chart type or a particular formatting control in the web interface, open the workbook in the Microsoft 365 desktop application and check there. Keep the workbook’s source data in a normal worksheet table so it remains easy to edit across versions.
Frequently Asked Questions
Does Excel have a funnel chart creator?
Yes. Excel for Microsoft 365 includes a built-in Funnel chart type. Select the stage labels and values, then use Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Funnel on Windows.
How do I reverse the order of an Excel funnel chart?
Reorder the stage rows in the source data into the sequence you want. Excel plots the categories in source order, so changing the worksheet order is the direct way to change the displayed sequence.
Can an Excel funnel chart show percentages?
It can show values through data labels, but it does not automatically calculate conversion percentages between stages. Calculate those separately and include them in the chart labels or in a companion table if they are important to the analysis.
Why does my funnel chart get wider at a later stage?
The later stage has a larger value than the stage above it. Verify that the values use consistent definitions, units, and time periods. If the increase is genuine, explain it rather than changing the underlying data to create a narrower shape.
What can I use if my version of Excel has no Funnel chart?
Use a horizontal bar chart to compare stage counts, or create a table that shows each count and its conversion rate. These options work in more Excel versions and can be clearer when the stages do not consistently decrease.
Related
- Excel Custom Number Format for Millions
- Excel Custom Number Format: Show Numbers in Thousands
- Excel Shortcut to Select the Rest of a Column Down
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Pareto Chart in Excel: How to Create and Interpret ItYes. In Excel for Microsoft 365 on Windows, select a column of raw category records, then choose Insert…
- Edit Legend in Excel Line Charts: Names, Position, and StyleTo edit a legend in an Excel line chart, select the chart and go to Chart Design >…
- Excel Pivot Table Average: Add a Column and Set It UpTo add an average column to an Excel PivotTable, drag the numeric field into the Values area a…
- Butterfly Graph in Excel: How to Build and Format OneTo make a butterfly graph in Excel, put one comparison series in negative values and the other in…
- Pivot Chart vs Pivot Table: Differences and Best UsesA PivotTable organizes and summarizes source data into a changeable grid; a PivotChart turns that summary into a…
- Excel Pivot Table: Filter Values Greater Than a NumberTo show PivotTable items whose summarized value exceeds a threshold, open the drop-down for the row or column…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.