Yes. Microsoft Excel for Microsoft 365 on Windows includes a built-in Funnel chart for showing values across stages of a process, such as sales opportunities moving from leads to purchases. Select your stage labels and values, then choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Funnel; the chart is most useful when the values generally decrease from one stage to the next.
What an Excel funnel chart shows
A funnel chart displays categories as horizontal bars, usually arranged as steps in a process. Bar size represents the value assigned to each category. When successive values get smaller, the bars narrow down the chart, making it easy to see where a process loses volume. A sales pipeline is a common example, but the same chart can show customer onboarding, application reviews, recruitment stages, or website visitors moving toward a goal.
The chart is a visual summary, not a specialized analysis tool. Excel does not automatically determine why a count fell, calculate conversion rates, or verify that each row represents the same people or items. You provide the categories and values; the chart displays them. That distinction matters when interpreting results, especially if stages come from different reporting periods or use different definitions.
Prepare the data before inserting the chart
Put the process stages in one column and their corresponding counts in the next, with a header for each column. For example, a simple sales pipeline could look like this:
- Website visitors — 12,000
- Leads — 3,200
- Qualified prospects — 1,100
- Proposals — 420
- Purchases — 160
Keep the labels and values on the same rows, and include the headers when you select the data. Use one value series for a straightforward funnel. Check that the values are numeric, not numbers stored as text, and remove blank rows within the range if they are not meaningful stages. Clear, short labels make the chart easier to read; long category names can take up space or wrap.
Arrange the categories in the order you want readers to follow the process, from its beginning to its end. Funnel charts are generally clearest when values decline at each step. Do not sort the rows from largest to smallest automatically if that would scramble a real sequence: the order of stages should describe the process, not merely rank the values. If the numbers rise partway through, check whether the data definitions or order need attention before treating that as a charting problem.
Create a funnel chart in Excel
- Enter the stage names and values in adjacent columns, including column headers.
- Select the full range, including the headers.
- Open the Insert tab on the ribbon.
- Choose Insert Waterfall, Funnel, Stock, Surface or Radar Chart, then select Funnel.
- Review the result and add a descriptive chart title, such as Sales pipeline by stage.
Excel inserts the chart into the worksheet. If the chart uses the wrong cells or treats the data in an unexpected way, select it and use Chart Design > Select Data to review or change the source range. When the categories and series appear in the wrong orientation, Chart Design > Switch Row/Column may help, though a two-column stage-and-value table is usually the simplest layout.
On Excel for Mac, the ribbon and chart menus may be arranged differently, but look on the Insert tab for the chart-type menu and Funnel. The exact set of available chart types can depend on the Excel edition and update level. If Funnel is missing, confirm that you are using a recent Excel version and try the desktop app rather than assuming the workbook data is unsuitable.
Format the chart for quick reading
A useful funnel chart makes the process and its values understandable without requiring readers to guess. Select the chart and use the Chart Design tab to change its style, colors, or title. To display the counts directly, use Chart Design > Add Chart Element > Data Labels, or the chart elements controls that appear beside a selected chart in Windows. Labels are particularly helpful when two bars look similar but represent meaningfully different counts.
Choose a restrained color treatment. A single color family emphasizes that the bars are steps in one process; different colors can be useful when they encode a genuine distinction, but arbitrary colors may imply categories that do not exist. Make sure text and labels have enough contrast, and avoid decorative effects that make bar sizes harder to compare. A descriptive title should identify the process and, where relevant, the time period.
Consider whether the data labels should show raw counts, percentages, or both. A funnel chart’s bar sizes communicate the values you supplied; it does not automatically turn those values into percentages of the first stage. If readers need rates as well as counts, calculate or summarize those separately in the worksheet and explain what the percentage means. Label the measure clearly so that a count of people is not confused with a percentage of the starting group.
Example: interpreting a sales pipeline
In the example above, the chart makes the sharp reduction from 12,000 visitors to 3,200 leads immediately visible. It also shows that 160 purchases remain at the end of the sequence. The chart alone does not tell you whether the visitor-to-lead change is good or bad; that judgment needs a target, historical comparison, or business context. Nor does a shrinking bar prove that the same individuals were tracked through every stage.
For a valid stage-by-stage conversion analysis, confirm that the stages are defined consistently and that the counts describe a comparable cohort. For example, if visitors are counted this month but purchases include customers acquired over several months, the final bar may not represent a conversion from that visitor group. A funnel chart can still display those figures, but the shape could invite an incorrect conclusion. Add a note about the measurement period or use cohort-based data when that is what the question requires.
Another common use is tracking applications: submitted, screened, interviewed, offered, and accepted. If the accepted count exceeds offers, that may signal a data issue, a timing difference, or a process in which stages are not strictly sequential. Investigate the underlying records rather than changing the chart to force a narrowing shape. The visual should reveal the data’s pattern, not conceal it.
Common problems and how to fix them
- The Funnel option is not visible: Check that you are using a sufficiently recent Excel edition and that Office is updated. Some older installations do not include every newer chart type.
- The chart has unhelpful labels: Include the category-name column in the selected range and check the source under Chart Design > Select Data.
- The categories appear in an unexpected order: Reorder the source rows to match the process, then review the chart. Avoid changing the sequence just to make the bars descend if that distorts the real workflow.
- A value is missing or looks wrong: Check for blanks, text-formatted numbers, duplicate categories, and an incomplete selected range.
- The chart is difficult to interpret: Add a title and data labels, shorten long stage names, and remove unnecessary visual decoration.
One misconception is that a funnel chart automatically calculates the percentage lost at each stage. It does not: it represents the values in the data range. Another is that a funnel must always narrow perfectly. If your source values do not decrease, Excel can still display the supplied values, but the result may not resemble a conventional funnel. Treat an unexpected shape as a prompt to check the data and the process, not as proof that Excel has calculated something incorrectly.
When to choose a different chart
A funnel chart is a good choice when the categories are meaningful steps and the main question is how volume changes across them. It is less suitable when the categories are unrelated, when values rise and fall without a process sequence, or when exact comparisons between many categories matter more than the overall progression.
A bar chart is often better for comparing unrelated groups because readers can compare lengths against a shared axis without interpreting a funnel shape as a sequence. A line chart is generally more appropriate when the horizontal axis is time and the central question is how a measure changes over time. A table may be clearest when readers need to inspect exact values, definitions, or several metrics side by side. You can also pair a funnel chart with a small table of conversion rates, provided the rates are clearly defined and calculated from suitable data.
Excel’s native Funnel chart is convenient for a clean, single-series process view. If you need multiple cohorts or want to compare several pipelines at each stage, consider whether separate charts, a clustered bar chart, or a carefully designed table will communicate the comparison more accurately. A crowded funnel can be harder to read than a simpler chart, even when Excel can technically display the data.
Availability and sharing considerations
Funnel charts are available in modern desktop versions of Excel, including Microsoft 365. Older perpetual editions or installations that have not received feature updates may not show the same chart choices. Excel for Mac and Excel for the web can also have interface or feature differences by version, so check the Insert tab in the actual app you use. If a workbook is opened in an older program, the chart may not be fully editable there even if it displays.
When sharing a workbook, consider the recipients’ Excel versions and whether they need to edit the chart or only view it. For a report that must render consistently across different software, test the workbook in the target environment or provide a static image or PDF alongside it. Keep the underlying data in the workbook if readers need to inspect how the chart was made, and clearly identify the source and reporting period.
Frequently Asked Questions
Does Excel have a built-in funnel chart?
Yes. In current Excel editions, select the stage and value data, then use the Funnel option in the Insert tab’s chart menu.
How do I make a funnel chart in Excel?
Place stage labels and numeric values in adjacent columns, select both columns with their headers, and choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Funnel.
Can an Excel funnel chart show percentages?
It displays the values in its source data; it does not automatically calculate conversion percentages. Add percentage values to the data or show a separate, clearly labeled rate alongside the chart.
Why is my funnel chart not narrowing?
The values may increase at one or more stages, or the rows may not follow the intended process order. Check the source data and stage definitions rather than rearranging valid stages solely to create a narrower shape.
Can I create a funnel chart in older Excel?
It depends on the edition and update level. If Funnel does not appear in the chart menu, use a newer Excel version or choose another chart type that your installation supports.
Related
- Center Across Selection in Excel: Add It to Quick Access
- Change Block Capitals to Lowercase in Excel
- Cell in Microsoft Excel: Meaning, Types, and How to Use It
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Scatter Plot Secondary Y-Axis: Setup and TipsYes. In Excel for Microsoft 365 on Windows, select the scatter-plot data series you want to move, right-click…
- Balance Graph in Chemistry: What It Means and How It WorksA “balance graph” in chemistry is not one universally standardized tool or term. It usually refers to a…
- Excel Graph: How to Move the X-Axis to the BottomTo move an Excel chart’s x-axis to the bottom, select the vertical (y) axis, open Format Axis, and…
- How to Open a Pivot Table Menu in Google SheetsTo open the pivot table controls in Google Sheets, click any cell inside the pivot table; the Pivot…
- Excel Gantt Chart: Build, Format, and Manage a ScheduleYes. An Excel-based Gantt chart is a project schedule displayed as task rows and date columns, with colored…
- Excel Combo Chart Not Working? Fix the Common CausesTo create a combo chart in Excel for Microsoft 365 on Windows, select your data, choose Insert >…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.