Sales Funnel Chart in Excel: Template, Setup, and Tips

Charts & pivot tables · Updated November 20, 2026

To make a sales funnel chart in Excel, arrange sales stages in one column and the number of prospects at each stage in the next, select both columns, then choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Funnel. In Microsoft 365 for Windows, a simple template can show stage counts and, in a separate column, the conversion rate from each stage to the next.

A Simple Sales Funnel Template

Start with a small, readable dataset. Put stage names in A1:A7 and the number of prospects in B1:B7. For example, enter the following headings and counts:

  • Website visits — 10,000
  • Leads — 1,200
  • Qualified leads — 480
  • Proposals — 180
  • Closed deals — 54

Use a heading such as Stage in A1 and Prospects in B1, then place the five stage names and counts in rows 2 through 6. For a chart, the important requirement is that each stage has one numeric value. Keep the values as numbers rather than text such as 10,000 visitors; put units in the heading or a note instead. Excel needs numeric values to size the funnel segments correctly.

This example is illustrative, not a benchmark for a typical sales organization. It represents one group moving through a process, with each later count referring to prospects from the same starting group. If counts are drawn from different time periods or represent separate monthly totals, the chart may still compare them, but it should not be read as a literal conversion funnel without more context.

How to Insert the Funnel Chart

In Excel for Microsoft 365 on Windows, select the stage and count range, including the headings, then use the Insert tab and choose Insert Waterfall, Funnel, Stock, Surface or Radar Chart in the Charts group, followed by Funnel. Excel creates a chart from the selected data. If the chart does not use the stage names as labels, select it and check the source range through Chart Design > Select Data.

  1. Keep stages in the order you want readers to follow, from the broadest entry stage to the final outcome.
  2. Select the two columns of stage names and counts. Do not include a conversion-rate column in the selection unless you intend to chart that measure too.
  3. Insert the Funnel chart, then add a descriptive chart title, such as Sales Pipeline by Stage.
  4. Review the labels and the order from top to bottom. If the order is reversed, adjust the category order in the chart’s axis formatting options.

The command is available in current Microsoft 365 desktop Excel. Older editions may not include the built-in Funnel chart. On a Mac, use the Insert tab and the chart controls to find Funnel; the ribbon layout can differ slightly from Windows. Excel for the web also has chart tools, but available controls may vary. If Funnel is not offered in your edition, use a bar chart as an alternative rather than assuming the missing option is a problem with the data.

Add Stage-to-Stage Conversion Rates

Counts show how many prospects remain at each stage; conversion rates help explain the movement between stages. Add a third column headed Conversion from prior stage. Leave the first stage’s rate blank because it has no preceding stage. With stage names in A2:A6, counts in B2:B6, and the first conversion result in C3, enter =B3/B2 in C3 and fill it down through C6. For the example, the first result is 12% because 1,200 divided by 10,000 is 0.12. The remaining rates are 40%, 37.5%, and 30%.

Format the conversion cells as percentages using Home > Number > Percent Style. Adjust decimal places if useful. These rates are not the same as the overall conversion rate from the first stage to the last. With the same counts in B2:B6 and the overall rate placed in C8, enter =B6/B2 in C8. The result is 0.54%, because 54 divided by 10,000 is 0.0054. Label the result clearly as Overall conversion so it is not mistaken for a stage-to-stage rate.

Keep the funnel chart focused on one measure, usually counts. The conversion column is useful beside the chart or in a separate table, but combining counts and percentages on a single funnel can confuse the visual because they use different scales. A reader can then see both the size of each stage and where the largest proportional losses occur.

Format the Chart for Clear Reading

A useful funnel chart makes stage names and values easy to scan without decorative effects competing for attention. Click the chart title to replace the default text with a title that names the measure and, where relevant, the reporting period. For example, Sales Pipeline by Stage — Q2 is more informative than Sales Funnel. If the reporting period is not fixed, include it in a cell or note outside the chart so it can be updated consistently.

To add values, select the chart and use Chart Design > Add Chart Element > Data Labels. Choose a label position that remains readable, then inspect the chart at its intended display size. Some labels may be hard to read when segments are narrow. Shorten long stage names in the source data only if the shorter wording is still clear, or widen the chart. Number formatting can also help: large counts may be easier to compare when shown with thousands separators.

Use consistent colors and restrained styling. A funnel chart’s narrowing shape already communicates that values are getting smaller, so gradients, shadows, and a different color for every stage are rarely necessary. Color can be useful when it has a meaning, such as distinguishing completed stages from active ones, but explain that meaning. If the chart is shared in a report, check that text and colors remain distinguishable when printed or viewed by people with color-vision differences.

Choose the Right Stage Order and Data

Order the source rows to match the actual customer journey, not whichever sequence makes the chart look most symmetrical. A company might use Inquiry, Marketing-qualified lead, Sales-qualified lead, Proposal, and Closed won. Another business may have different definitions, such as a trial or a product demonstration. Write down what qualifies a record for each stage; otherwise, two teams may count different things under the same label.

Counts should describe a consistent cohort when the goal is to show conversion. For example, a cohort might be all leads first acquired in January, followed as they progress. Comparing January website visits with February qualified leads and March wins can be misleading if those values are treated as one group: later stages may come from earlier visitors, and some January prospects may still be progressing. A snapshot of the current pipeline answers a different question from a cohort conversion analysis. State which one the chart represents.

Check for duplicate records, missing values, and stage definitions before charting. Decide how to handle prospects that skip a stage, return to an earlier stage, or are disqualified. A standard funnel is a simplified view of a process, not a record-level audit trail. If the real process includes loops or parallel routes, a funnel may hide those details, so explain the simplification or choose another visualization.

Common Problems and What They Mean

  • The funnel appears upside down: Review the row order and the category order in the chart’s axis settings. Confirm that the first stage in the source is meant to appear at the top.
  • A stage is wider than the one before it: The source counts may have increased, or the stages may not be a single decreasing cohort. Check the numbers and explain legitimate increases rather than editing data to force a funnel shape.
  • Stage names or values are missing: Confirm that the selected range includes the correct label and value columns, then add data labels if values should appear on the chart.
  • The chart looks like a flat bar: Compare the counts and check for an unusually large value or inconsistent units. A strong difference between the first stage and later stages can make smaller segments visually thin.
  • Percentages look wrong: Make sure the formula divides a stage count by the count immediately before it, and that the cells use Percentage formatting. A percentage-formatted cell displays 0.12 as 12%, not 0.12%.

Do not remove an inconvenient stage or alter a count just to create a neat shape. If the data show a genuine increase, it may reflect referrals, re-entry, a reporting mismatch, or a stage definition that does not represent a strict progression. Investigate the cause and annotate the chart as needed.

Funnel Chart Compared with Other Options

A funnel chart is most useful when the stages form an ordered process and the audience wants to grasp how counts narrow toward an outcome. It makes a large-to-small progression visually immediate. However, the segment widths are not as precise for comparison as aligned bars, particularly when adjacent values are close. Readers may also overemphasize the shape and overlook the exact counts unless labels are present.

A horizontal bar chart is a strong alternative when accurate comparisons between stages matter more than the funnel metaphor. Bars share a common baseline, which makes small differences easier to judge. A table is often better when the report must show counts, conversion rates, and notes together. For a process with returns, branches, or separate routes, a flow diagram or a more specialized process visualization may communicate the structure more honestly. Choose based on the question, not simply on which chart looks most familiar.

Frequently Asked Questions

Does Excel have a sales funnel chart template?

Excel includes a Funnel chart type in current Microsoft 365 desktop editions, but a ready-made sales template is not required. Supply stage names and numeric counts in two columns, then insert the chart. You can save the completed workbook as a reusable template if the same layout will be used again.

Why can’t I find Funnel under Insert in Excel?

The built-in chart is not available in every older Excel edition, and ribbon layouts can vary by platform. Check the Insert tab’s chart controls and confirm your Excel version. If Funnel is absent, a bar chart is a practical substitute; avoid downloading an unknown add-in just to reproduce a simple chart.

Can I show percentages in an Excel funnel chart?

Yes, but first decide which percentage readers need. Stage-to-stage conversion is each stage’s count divided by the preceding stage’s count; overall conversion compares the final count with the first. You can calculate these in adjacent worksheet cells and label them clearly. Keep percentage values separate from counts unless the chart is intentionally built to present one measure.

Should funnel counts always decrease at every stage?

Not necessarily. A strict cohort moving through exclusive stages will normally have counts that stay level or decrease, but a live pipeline can gain records, allow re-entry, or use stages with different counting rules. An increase is a reason to check definitions and data, not a reason to change the numbers automatically.

How do I update the chart when I add a new stage?

Add the new stage and its count to the source data, then check whether the chart’s selected range includes the new row. If it does not, use Chart Design > Select Data to adjust the chart data range. Keeping the source as a formatted Excel table can make expanding data easier, though you should still verify the chart after adding rows.

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.