How to Make a Funnel Chart in Excel

If you run any process where numbers shrink at each stage — leads to closed deals, applicants to hires, site visitors to buyers — a funnel chart is the fastest way to show where they shrink. The shape does the talking: a healthy pipeline tapers gradually, and a broken one has a cliff you can spot from across the room.

Excel has had a native funnel chart type since Excel 2019 (and it’s in every Microsoft 365 version), yet a surprising number of guides still teach the old stacked-bar workaround as the main event. Skip that. The native chart takes three clicks. This guide builds one around a sales pipeline, adds the one thing the default chart is missing — stage-to-stage conversion rates — and keeps the legacy method where it belongs: clearly labeled, at the bottom, for anyone stuck on Excel 2016 or earlier.

Set Up Your Data (Two Columns, That’s It)

The native funnel chart wants the simplest data layout in all of Excel charting: one column of stage names, one column of values, ordered top to bottom the way the process flows.

Two rules worth following:

1. Make it a Table first (select the data, Ctrl+T). When next quarter’s numbers replace this quarter’s, the chart picks them up automatically. If a chart ever stops reflecting your data, that’s a different problem with known fixes — see Excel chart not updating?
2. Keep it to 4–8 stages. Three stages barely qualifies as a funnel; ten stages is a process-mapping exercise wearing a chart costume. If your pipeline genuinely has ten stages, your problem isn’t charting.

The values don’t strictly have to decrease — Excel will draw whatever you give it — but if a later stage is bigger than an earlier one, a funnel is the wrong chart and will actively mislead. More on that below.

Insert the Native Funnel Chart

1. Click anywhere in your data.
2. Go to Insert > Charts and click the Insert Waterfall, Funnel, Stock, Surface or Radar Chart icon (it looks like a small waterfall chart).
3. Choose Funnel.

Done. Excel draws centered horizontal bars, widest at the top, each labeled with its value. On a Mac, the same option lives under Insert > Chart > Funnel.

If you don’t see the funnel option at all, you’re on Excel 2016 or earlier — jump to the legacy method at the end.

Add Conversion Rates (the Upgrade That Earns Its Keep)

Raw counts tell you the pipeline’s size. Conversion rates tell you where it leaks — and the default chart doesn’t show them. Here’s the fix, and it takes two minutes:

1. Add a third column to your table, headed Conversion. Leave the first row blank (nothing converts into Leads). In the second row, enter =B3/B2 and format as a percentage; fill down. Each cell now shows the percentage that survived from the previous stage: Qualified 42%, Demo 45%, Proposal 42%, Closed 45%.
2. Click the chart’s data labels once to select them all, then right-click > Format Data Labels.
3. Check Value From Cells, select your Conversion column, and click OK. Keep Value checked too if you want both numbers.

Now every bar reads something like “95 · 45%” — the count and the stage-to-stage survival rate. This is the version worth putting in front of a sales manager, because the leak announces itself. In our example the pipeline converts remarkably evenly; in most real pipelines, one stage sits 15 points below the others, and that’s the meeting agenda sorted.

If you’d rather not build any of this from scratch, our free sales funnel template has the chart, conversion formulas, and formatting already wired up — swap in your numbers and go.

Formatting: Less Is More

The native funnel needs less cosmetic work than most Excel charts, but three changes lift it:

• Recolor with intent. Excel defaults to a single blue. A single-color funnel is fine; if you recolor per stage, use a light-to-dark run of one hue, not a rainbow. The shape carries the meaning — color shouldn’t compete.
• Kill the gridlines and axis. Right-click each > Delete. The bars are labeled; the scaffolding is redundant.
• Title with the takeaway. “Q3 Pipeline: Proposal Stage Is the Leak” is a chart people act on. “Funnel Chart” is a chart people scroll past.

One thing you can’t do with the native chart: it won’t draw the smooth trapezoid “funnel” shape you see in marketing decks. Excel’s version is stacked centered bars. That’s not a limitation worth fighting — the trapezoid version distorts area (a stage with half the value doesn’t look like half), while the bar version stays honest. Excel accidentally made the better design choice.

You can also generate this chart by asking Copilot — “create a funnel chart from this pipeline data” works — though you’ll still want the conversion-label step done manually. Our complete guide to Copilot charts covers where AI charting genuinely saves time and where it doesn’t.

When a Funnel Chart Is the Wrong Choice

A funnel chart makes one specific claim: these stages are sequential, and each is a subset of the one before. If that’s not true of your data, the chart lies on your behalf:

• Values that go up mid-process (returns processed, tickets reopened) — use a column chart.
• Categories that aren’t stages (revenue by region, sadly common in funnel costume) — use a bar chart.
• Two pipelines compared — use paired bar charts side by side; overlapped funnels are unreadable.

If you’re not certain, our chart decision guide maps data shapes to chart types and will settle it in a minute.

Legacy Method: Excel 2016 and Earlier

Labeled fallback — only use this if the native chart isn’t in your Insert menu.

The trick is a stacked bar chart with an invisible “spacer” series that centers the visible bars:

1. Add a Spacer column to the left of your values: =(MAX($B$2:$B$6)-B2)/2 filled down. Each spacer is half the gap between that stage and the widest stage.
2. Select stages, spacers, and values; insert a Stacked Bar chart (Insert > Column or Bar Chart > Stacked Bar).
3. Right-click the vertical axis > Format Axis > check Categories in reverse order so the widest stage sits on top.
4. Click the spacer series (the left-hand blocks), then Format Data Series > Fill > No Fill. The spacers vanish, and the visible bars now sit centered — a funnel.
5. Add data labels to the value series only, and delete the legend.

It works, and it’s served people well for fifteen years. It’s also fiddly to maintain and breaks if someone deletes the “empty-looking” spacer column. If you’re on Microsoft 365 and building this manually, stop — the native chart exists.

FAQ

Which Excel versions have the native funnel chart? Excel 2019, 2021, 2024, and all Microsoft 365 versions on Windows and Mac, plus Excel for the web. Excel 2016 and earlier need the legacy method above.

Can I make the funnel show percentages of the top stage instead of counts? Yes — add a column with =B2/$B$2 formatted as a percentage and point Value From Cells at it. “Closed won: 3.6% of leads” is often the number executives actually want.

Why are my funnel bars in the wrong order? The chart draws rows in worksheet order, top to bottom. Reorder the rows in the sheet; don’t fight the chart.

Can I add a target line to a funnel chart? Not natively — the funnel type doesn’t support combo series. Put targets in the data labels via Value From Cells (“40 vs target 55”), which reads better on a funnel anyway.

---

Related Guides

• Which Chart Should You Use? A Decision Guide by Data Type
• Free Sales Funnel Chart Template for Excel
• Excel Chart Not Updating? 7 Fixes That Actually Work
• How to Create Charts with Copilot in Excel: The Complete Guide