To make a funnel chart in Excel for Microsoft 365 on Windows, put 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. Add a clear title and data labels, and check that the chart displays the stages in the order your process actually follows.
What an Excel funnel chart shows
A funnel chart uses horizontal bars to show how a group changes as it moves through consecutive stages. It is often used for a sales pipeline, recruitment process, website journey, or service workflow. A sales example might track prospects, qualified leads, proposals, and closed deals. The decreasing bar lengths make drop-off and relative volume easy to see at a glance.
The chart visualizes the values you provide; it does not know what each stage means or calculate why people leave. A shorter bar shows a smaller count, not necessarily a problem. For a fair comparison, stages should describe a consistent process and counts should use compatible definitions and time periods. If the values increase at a later stage, check the underlying data: that may be valid, but it can make the chart look less like a conventional funnel.
Prepare the data before inserting the chart
Use a simple two-column table: one column for stage names and one for the number or amount at each stage. Put headers in the first row, with one stage per row beneath them. For example, a lead funnel could have the headers Stage and Count, followed by Website visitors, Leads, Qualified leads, Proposals, and Customers. Keep the values numeric, not numbers stored as text, and remove blank rows within the data.
Decide what each number means before charting. Counts of people, orders, or applications are usually intuitive. If you use revenue or another monetary measure, label the unit and period clearly; a funnel of dollar amounts is not the same as a funnel of people. Do not mix unique people in one stage with actions or transactions in another, or compare stages drawn from different date ranges without explaining the difference.
For a process funnel, arrange the rows in the intended stage sequence and use values that generally decline from one stage to the next. Excel’s display can depend on the chart and category ordering, so inspect the result rather than assuming the visual order matches the worksheet. If stages appear in an unexpected order, use the chart’s source data and axis options to correct the presentation, or adjust the source ordering and verify it again.
Create the funnel chart in Excel for Windows
- Enter the stage names and values in adjacent columns, including a header for each column.
- Select the complete range, including the headers. For example, select A1:B6 if the headers are in row 1 and there are five stages.
- On the ribbon, choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Funnel. Excel inserts a chart based on the selected range.
- Click the chart title and replace the default wording with a descriptive title, such as Sales pipeline by stage, Q2.
- Check the category labels and bar sequence. If Excel interpreted the rows or columns incorrectly, use Chart Design > Switch Row/Column or Chart Design > Select Data to review the chart’s source.
- Save the workbook and, if the chart will be shared, check it at the size and in the format in which readers will see it.
Excel normally creates a single-series funnel from this two-column layout. If you have several separate funnels, avoid selecting multiple value columns without considering how the chart will interpret them. A chart that combines unlike series can be difficult to read; one chart per segment or a small-multiple layout may communicate the comparison more clearly.
Format the chart for clear reading
Start with the information readers need most: what process is shown, when it was measured, and what the values represent. A title such as Applications remaining at each hiring stage is more informative than Funnel Chart. If counts are monthly, say so in the title or a subtitle. If a unit is not obvious, add it in a nearby text box or explain it in the worksheet.
Use a restrained color scheme with enough contrast against the chart background. A single color often emphasizes the decreasing shape without suggesting that each stage has a different status. If you use different colors to distinguish stages, include a clear reason for the distinction; color alone should not carry essential meaning. Consider accessibility: avoid relying only on red and green, and ensure labels remain readable at normal zoom.
To add labels in Windows, select the chart and use the Chart Elements button (the plus sign beside the chart) and check Data Labels. You can also use Chart Design > Add Chart Element > Data Labels. Choose a label position that does not crowd the bars, then inspect long category names and large numbers. If labels overlap or are clipped, enlarge the chart, shorten labels carefully, or move explanatory details into a nearby table.
Understand counts, percentages, and conversion rates
A funnel chart can show the value at each stage, but readers often also want to know the percentage that progressed. Those are different measures. If your data shows 1,000 visitors, 240 leads, 72 qualified leads, 30 proposals, and 9 customers, the count at each stage is what the funnel bars represent. The conversion from visitors to leads is 240 divided by 1,000, or 24%; the conversion from proposals to customers is 9 divided by 30, or 30%.
Do not assume the chart automatically explains those rates. You can calculate rates in a separate worksheet column and display them in a companion table, or add a carefully worded annotation. State the denominator: a stage-to-stage rate uses the prior stage as its denominator, whereas an overall rate compares a later stage with the first stage. For the example above, overall visitor-to-customer conversion is 9 divided by 1,000, or 0.9%. Keeping those definitions visible prevents a percentage from being misread.
Worked example: a sales pipeline
Suppose a team recorded 1,000 prospects, 400 qualified leads, 160 proposals, and 40 wins during a specified quarter. Put those four stage names in the first column and the counts in the second, then insert a funnel chart. The bars communicate that the largest reduction in absolute count occurs between prospects and qualified leads: 600 records do not appear in the qualified stage. That observation can prompt a useful question about qualification criteria, but the chart alone cannot tell you the cause.
For additional context, stage-to-stage conversion is 40% from prospects to qualified leads, 40% from qualified leads to proposals, and 25% from proposals to wins. Overall prospect-to-win conversion is 4%. These rates can reveal a different pattern from raw bar lengths: the first two transitions have the same percentage, even though the first has a larger numerical loss. Include both counts and rates when readers need to assess performance, and make clear whether the records refer to the same cohort or to separate totals collected over a period.
Common problems and how to fix them
- The Funnel option is missing. Confirm that you are using an Excel edition with funnel charts, such as a current Microsoft 365 desktop version, and that you are in the desktop app. Some older releases or limited interfaces may not offer the chart type. Update Excel if appropriate, or use a bar chart as an alternative.
- The chart shows the wrong labels or values. Select the chart and open Chart Design > Select Data to check the data range and series. Make sure the stage names and numeric values were both selected and that the header row was recognized correctly.
- The bars do not form a familiar funnel. Check for increases, inconsistent stage definitions, or values entered as text. Also inspect the displayed order against the process sequence. A funnel chart is not a sorting or data-cleaning tool, and an unusual shape may accurately reflect the supplied numbers.
- Labels are hard to read. Widen the chart, reduce unnecessary words, or show the exact values in a nearby table. Avoid shrinking text until it is unreadable just to fit every annotation into the plot area.
- A stage has zero or missing data. A zero can produce a bar with no visible length; a blank may be interpreted differently from zero. Decide whether the stage truly had no cases or whether its value is unknown, and use a note or a separate table to distinguish those situations.
- Percentages look misleading. Verify each denominator and whether the chart displays counts or rates. Do not compare a stage-to-stage conversion rate with an overall conversion rate as though they measured the same thing.
When to use a funnel chart—and when not to
Choose a funnel chart when the stages form a meaningful sequence and the main question is how volume changes as cases progress. It is especially effective with a modest number of clearly named stages and values that generally narrow. The familiar silhouette makes an overview quick to scan, but it can make precise differences hard to estimate because readers are judging bar lengths rather than reading an aligned scale.
For close comparisons, a horizontal bar chart may be better: all bars share a common baseline, making their lengths easier to compare. A table is preferable when exact values and rates matter more than the visual pattern. A line chart can help when the question concerns change over time, but it does not replace a stage funnel unless the data actually represents a time series. Choose the chart for the question, not simply because the data has stages.
Excel for Mac and Excel for the web
On current Excel for Mac releases, the ribbon layout and chart insertion route can differ from Windows. Look under Insert for Recommended Charts, then check the All Charts tab for Funnel. If the option is unavailable, check that Excel is up to date or create the chart in a desktop version that includes funnel charts. Ribbon labels and placement can vary slightly by release.
Excel for the web has a different interface and may not expose every chart type or formatting control found in the desktop app. If you cannot create or fine-tune a funnel there, open the workbook in desktop Excel, make the chart, save the file, and then return to the browser. The exact experience can depend on the account and update available to the workbook.
Frequently Asked Questions
Can I make a funnel chart in Excel without a template?
Yes. A template is not required. Create a two-column stage-and-value table, select it, and insert the Funnel chart from Excel’s chart menu. You can then format the title, labels, colors, and chart size yourself.
Does Excel automatically calculate funnel conversion rates?
No. The funnel chart visualizes the values in its source data; it does not determine stage-to-stage or overall conversion for you. Calculate those rates separately and label the denominator so readers know what each percentage means.
Can funnel chart values increase between stages?
They can, but increases are unusual for a conventional drop-off funnel and may make its shape less intuitive. First confirm that the stages and definitions are consistent. If the increase is real, explain it or consider a bar chart that presents the values without implying a narrowing process.
How do I change the order of funnel stages?
Check the source range through Chart Design > Select Data, then adjust the source rows or chart category settings and inspect the result. Keep the intended process sequence clear in the worksheet; do not assume the chart’s visual order is correct without checking it.
Why can’t I find Funnel under Insert Chart?
The chart type may be unavailable in an older or limited Excel version, or the menu may be arranged differently on Mac or the web. In Windows desktop Excel for Microsoft 365, look under Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart. If Funnel is absent, update Excel or use a horizontal bar chart.
Related
- Excel Won’t Group Dates in a PivotTable? Fixes That Work
- Excel Table Names: Where to Find, View, and Change Them
- Excel Weekly Meal Planner: Build a Reusable Template
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Donut Chart: How to Make the Ring Wider and ThickerTo make an Excel donut chart’s ring thicker, select the ring, open Format Data Series, and reduce Doughnut…
- Excel Pivot Table Relationships: How to Link DataExcel PivotTable relationships connect separate tables through matching columns in the workbook’s Data Model, so you can summarize…
- Excel Stacked Bar Chart: Add, Move, and Format the LegendTo add a legend to a stacked bar chart in Excel for Microsoft 365 on Windows, select the…
- Gantt Chart Template: Word or Excel for Your Project?Choose an Excel Gantt chart template if your schedule will change, needs date-based bars, or must track progress;…
- Excel Pivot Table Not Pulling All Data? Fix ItIf an Excel PivotTable is missing rows, first refresh it, then check whether its data source includes those…
- Excel Sparklines: How to Make Horizontal Bar ChartsExcel for Microsoft 365 does not have a horizontal-bar sparkline type: its built-in sparklines are Line, Column, and…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.