Funnel Chart in Excel: Create, Format, and Fix One

Charts & pivot tables · Updated November 19, 2026

To create a funnel chart in Microsoft Excel for Microsoft 365 on Windows, put your 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 data labels and check that the stages appear in the intended order; the chart then shows how the values change from one stage to the next.

What a funnel chart shows

A funnel chart visualizes values at successive stages of a process. It is commonly used for sales pipelines, website journeys, application reviews, and other sequences in which people, items, or cases move from one step to another. Each stage appears as a horizontal band, and the band’s width represents its value. The overall shape makes large drop-offs and smaller later stages easy to spot.

A funnel chart is useful when the stages have a meaningful order and the values can be compared on the same scale. For example, a visitor-to-purchase funnel might show 1,000 site visitors, 600 product-page views, 180 cart additions, 120 checkouts, and 90 purchases. The narrowing shape highlights that the largest loss occurs between product-page views and cart additions.

The chart does not explain why a value changes. It also does not automatically show the percentage of people who move from one stage to the next. Treat it as a visual summary, then use a table, notes, or additional analysis to explain the causes and rates.

Prepare the data in the right layout

For a straightforward chart, use a text column for stage names and one numeric column for values. Put headers in the first row, with one stage per row beneath them. Keep the stages in the order you want readers to follow, normally from the first step at the top to the final step at the bottom.

  • Use descriptive, concise stage names, such as Visitors, Product views, Added to cart, Checkout, and Purchases.
  • Enter actual counts or amounts as numbers, not text containing commas, percent signs, or explanatory words.
  • Use one series for one process. If you need to compare separate regions or periods, consider separate charts or another chart type rather than combining several processes into one funnel.
  • Check that the values refer to the same population, time period, and measurement. A funnel can mislead if one stage counts unique people while another counts events.

For example, enter Stage in A1 and Count in B1, then list Visitors—1,000, Product views—600, Added to cart—180, Checkout—120, and Purchases—90 in rows 2 through 6. The chart will use the labels in column A and the values in column B. Avoid blank rows within the data range, since they can create an unintended gap or category.

Create the chart in Excel for Microsoft 365

  1. Select the cells containing both the stage names and values, including the headers. In the example, select A1:B6.
  2. Open the Insert tab. In the Charts group, choose Insert Waterfall, Funnel, Stock, Surface or Radar Chart, then select Funnel. Depending on the ribbon width or Excel build, the chart-type button may appear as a small icon with a drop-down arrow.
  3. Excel inserts the funnel chart on the worksheet. Drag its border to move it, or drag a corner handle to resize it.
  4. Select the chart and add labels. One route is Chart Design > Add Chart Element > Data Labels, followed by a suitable label position. You can also use the Chart Elements button (the plus sign beside a selected chart) when it is available.
  5. Review the result against the source table. Confirm that all intended stages are present, the values are correct, and the labels are readable.

If the funnel chart option is missing, confirm that you are using a version of Excel that supports funnel charts. Microsoft added this chart type in Excel 2019; it is also available in Microsoft 365. Excel for Mac and Excel for the web can have different ribbon layouts or feature availability, so look under Insert and the chart-type menus. If the option is not offered in your installation, use the desktop version or choose a bar chart as an alternative.

Format labels, colors, and order

Data labels are particularly helpful because a funnel’s shape gives a visual comparison but not an exact count. Select the chart, then use Chart Design > Add Chart Element > Data Labels to turn them on. If the chart is crowded, try a different label position or enlarge the chart. For long stage names, widen the chart area or shorten the category wording in the source cells.

To change the chart title, select it and type a clear description, such as “Online Store Purchase Funnel, April.” Avoid titles such as “Funnel Chart,” which identify the chart type but not what the figures measure. Use a subtitle or a note near the chart to define the date range, audience, or unit if that context is not obvious.

To change the series appearance, select a funnel segment and open the Format Data Series pane. Use the Fill and Line controls to adjust its fill or outline. Selecting a single segment may let you format that data point separately; use restraint, since too many colors can imply distinctions that do not exist. Consistent colors generally make the stages easier to compare and keep attention on changes in width.

If the order is wrong, first inspect the order of the rows in the source table. Reorder those rows to match the process sequence, then check the chart again. The source table should remain understandable on its own, so do not rely on an unexplained chart setting to define which stage comes first. A clear top-to-bottom sequence also makes screenshots and printed copies easier to interpret.

Calculate and interpret conversion rates

The funnel chart normally plots the stage counts, not the percentage retained between stages. For the example values, the conversion from Visitors to Product views is 600 ÷ 1,000, or 60%; from Product views to Added to cart it is 180 ÷ 600, or 30%; from Added to cart to Checkout it is 120 ÷ 180, or about 66.7%; and from Checkout to Purchases it is 90 ÷ 120, or 75%. Overall, 90 of 1,000 visitors purchased, giving an overall conversion rate of 9%.

With stage names in A2:A6 and counts in B2:B6, enter the following in C3 to calculate each stage’s rate relative to the previous row, then fill it down through C6: =B3/B2. Format C3:C6 as Percentage. The results are 60%, 30%, about 66.7%, and 75%. For the overall rate, with the same layout, use =B6/B2; the result is 9%.

These are ratios of the displayed counts, not proof that the same individuals progressed through every step. If stages are measured in different ways, or if people can skip, repeat, or return to steps, the percentages may not represent a true individual-level conversion rate. Define the measurement rules before interpreting the chart. Excel will not infer those rules from the funnel shape.

Common problems and how to fix them

  • The chart option is unavailable: Check the Excel version and whether you are using the desktop or web app. Funnel charts are supported in Excel 2019 and Microsoft 365, but menus can differ by platform and update channel.
  • Stage names or values are missing: Select the complete two-column range, including the rows you want plotted. If data was added after chart creation, right-click the chart and choose Select Data to inspect or adjust its source range.
  • The funnel has an unexpected gap: Look for blank rows, blank cells, or values stored as text. Correct the source table, then check whether the chart updates.
  • Labels overlap or are hard to read: Enlarge the chart, reduce overly long category names, or choose a less crowded data-label position. A small chart cannot display a large amount of text clearly.
  • The chart seems to exaggerate a change: A funnel emphasizes relative width. Show data labels and include the source counts so readers can judge the size of the changes rather than relying on shape alone.
  • The values increase at some stages: Excel can still plot the numbers, but the result may not look like the conventional narrowing funnel. Check whether the process truly has increasing counts, whether stages are in the intended order, or whether a different chart would communicate the pattern better.

When to use a different chart

A funnel chart is not automatically the best choice just because data has several categories. Use it when the categories are ordered steps in one process and the changing quantity is central to the message. A horizontal bar chart is often clearer when category values are not stages, when values rise and fall, or when precise side-by-side comparisons matter more than the funnel silhouette.

A table may be the better option when readers need exact counts and conversion rates together. A line chart is more appropriate when the main question is how a measure changes over time; time periods are not process stages. For comparisons between two sales teams, regions, or campaigns, two aligned bar charts can be easier to compare than funnels whose widths may be judged relative to their own totals.

One common misconception is that a funnel chart automatically reports a drop-off percentage or explains where a business is losing customers. It does neither: it plots the values supplied. Add calculated rates, provide definitions, and investigate the underlying records if you need to explain a change. The visualization is a starting point for analysis, not a substitute for it.

Frequently Asked Questions

Can I make a funnel chart in Excel?
Yes. In Excel 2019 and Microsoft 365, select the stage labels and values, then use Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Funnel. The exact placement of the chart menu can vary with the ribbon layout.

How do I show percentages in an Excel funnel chart?
The chart plots the values in its data series; it does not automatically calculate stage-to-stage conversion percentages. Calculate those rates in adjacent worksheet cells, format them as percentages, and show them beside the chart or in a supporting table.

Can a funnel chart show more than one data series?
A funnel is clearest when it represents one process with one value per stage. For multiple processes, separate charts or a different chart type usually makes comparisons easier and less ambiguous.

Why is my funnel chart not narrowing?
Check whether the values actually decrease, whether the stage rows are in the intended sequence, and whether any values are missing or stored as text. A funnel chart displays the supplied figures; it does not automatically sort stages into a logical process.

Can I create a funnel chart in Excel for Mac or the web?
Menu locations and available options can differ from Excel for Windows. Look for Funnel in the Insert tab’s chart menus. If your version does not offer it, update Excel or use a bar chart to represent the same stage values.

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.