How to Create a Funnel Chart in Excel

Charts & pivot tables · Updated November 20, 2026

To create a funnel chart in Excel for Microsoft 365 on Windows, arrange process stages in one column and their values in the next, sort the stages from largest to smallest, select the data, then choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Funnel. Add a clear title and data labels so readers can see both the stages and their values.

What a funnel chart shows

A funnel chart compares values across sequential stages of a process. Its bars are centered and narrow as the values decrease, making it easy to spot where the largest drop-offs occur. It is often used for a sales pipeline, a customer journey, recruitment, or a website conversion process. For example, a marketing team might compare visitors, product-page views, cart additions, checkouts, and purchases.

The chart is most useful when the stages represent steps in the same process and each value measures the same thing, such as people, orders, or applications. It does not show the path of individual people, explain why a decline happened, or prove that one stage caused the next-stage loss. Treat it as a visual summary of counts, then investigate the underlying data for explanations.

Prepare the data in the right order

Use one column for stage names and one for a single comparable value series. Put a descriptive heading above each column, and list the stages in the order you want readers to follow, typically from the largest count at the top to the smallest at the bottom. Avoid blank rows within the data range, merged cells, and extra numeric columns, which can make Excel interpret the source incorrectly.

For example, a simple website funnel could look like this:

  • Visitors — 10,000
  • Product-page views — 6,000
  • Added to cart — 2,400
  • Started checkout — 1,200
  • Purchased — 720

These are illustrative counts, not a recommended benchmark. Here, 6,000 of 10,000 visitors viewed a product page, and 720 of the original 10,000 completed a purchase, so the overall visitor-to-purchase rate is 7.2%. The chart itself displays the stage counts; you can explain conversion rates in a nearby table or note if that context matters.

Create the chart in Excel

  1. Enter the stage names and values in adjacent columns, including headers. Select the complete range, such as A1:B6 for five stages and a header row.
  2. On the ribbon, select Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Funnel. Excel inserts a funnel chart based on the selected range.
  3. Check that the stages appear in the intended sequence and that the largest stage is at the top. If necessary, reorder the source rows and confirm the chart reflects the new order.
  4. Select the chart title and replace the default text with a specific description, such as Website visits to purchases. If the title is not visible, use Chart Design > Add Chart Element > Chart Title.
  5. To show counts on the bars, select Chart Design > Add Chart Element > Data Labels, then choose an available label position. Review the result and use the Format Data Labels pane if you need to adjust which values appear.

Keep the source range compact and include only the labels and values intended for the chart. If you add more stages later, you may need to update the chart’s data range: select the chart and use Chart Design > Select Data to inspect or change the source. Exact ribbon wording or available chart options can vary slightly with the Excel build.

Format the funnel for readability

A funnel chart should make the sequence and size differences understandable at a glance. Use a short title that identifies the process and, when needed, the time period. For instance, Monthly trial sign-ups to paid accounts is more informative than Funnel. Keep stage labels short enough to read without wrapping awkwardly, and use consistent terms in both the chart and any accompanying report.

Data labels help readers distinguish values that look similar in width. If labels overlap or crowd the chart, try a different label position, enlarge the chart, or shorten the stage names. Avoid adding decorative effects that compete with the bars. A single restrained color scheme is usually clearer than assigning unrelated colors to every step. If color communicates a meaningful category, explain it with a legend or note rather than relying on color alone.

Axis lines and gridlines are often less useful in a funnel than direct labels, but the best choice depends on the audience and the chart’s purpose. If counts vary greatly, the smallest bars may be hard to compare visually; labels can preserve the exact values. Include units in the title or a note when values are not self-explanatory, such as applications, dollars, or thousands of visits.

Understand the shape and the conversion story

The width of each funnel stage represents its value relative to the other stages. A sharp narrowing between two adjacent stages signals a larger count loss there, while a gradual narrowing suggests a steadier decline. In the example, the change from 6,000 product-page views to 2,400 cart additions is a substantial drop. That observation identifies a point worth examining; it does not, by itself, explain the reason.

Counts and conversion rates answer different questions. Counts show how many records remain at each stage; a stage-to-stage rate expresses the share that moves from one step to the next. In the example, 2,400 cart additions out of 6,000 product-page views is 40%. If you present rates, state the denominator clearly: a rate based on the previous stage is not the same as a rate based on all visitors. A funnel chart is generally clearest with one series of stage counts, while separate rate labels or a companion table can supply the extra detail.

Common problems and fixes

  • The funnel option is missing: Check that you are using a version of Excel that includes funnel charts, such as Microsoft 365 or Excel 2019 and later. If you are in Excel for the web and the chart type is unavailable in your interface, open the workbook in the desktop app.
  • Excel plots the wrong information: Make sure the selection contains the stage-name column and just one numeric value column, with headers included. Use Chart Design > Select Data to inspect the chart’s source range.
  • Stages appear in an unexpected order: Sort or move the source rows into the intended top-to-bottom sequence. Do not assume that Excel will infer the business order from stage names.
  • Labels are unreadable: Enlarge the chart, shorten long category names, or choose a less crowded data-label position. If necessary, keep exact counts in a nearby table instead of forcing every value into a narrow bar.
  • A stage is larger than the one above it: Check for inconsistent definitions, duplicate records, or a genuine increase between steps. A funnel is commonly used for declining stages, but the data should not be altered just to make the shape look conventional.

When to choose another chart

A funnel chart is a good fit for a small number of ordered stages with values that generally decrease. It is less suitable when you need to compare many unrelated categories, show several series side by side, or track changes over time. A bar chart is usually easier to read for unrelated categories or when precise comparisons between values matter more than a narrowing process shape.

If the main question is how performance changes by date, use a line chart or another time-series view rather than placing dates into a funnel. If your main goal is to communicate the percentage moving from one stage to the next, a table or a bar chart of conversion rates may be clearer. The chart type should follow the question the data needs to answer, not simply the appearance you want.

Excel versions and alternatives

These steps are for Microsoft Excel for Microsoft 365 on Windows. Funnel charts are also available in modern desktop versions such as Excel 2019 and later, though ribbon layout can differ. Excel for Mac has a similar Insert-chart workflow, but the controls and menus may be arranged differently. Excel for the web may offer different chart-editing options from the desktop app; if you cannot create or format the chart there, use the desktop version.

If your Excel version does not have a built-in funnel chart, you can use a horizontal bar chart as a practical substitute: place stage names beside counts, sort the counts in descending order, and add data labels. It will not have the centered funnel silhouette, but it can communicate the same stage values and may make exact comparisons easier. Avoid complex manual shapes unless you are prepared to update them whenever the source values change.

Frequently Asked Questions

Can I make a funnel chart in Excel with two columns?
Yes. A stage-name column and a numeric-value column are the simplest setup. Include headers, select both columns, and insert the Funnel chart. Keep the values to one comparable measure for a straightforward result.

Does Excel automatically sort funnel stages?
Do not rely on automatic sorting to determine your process sequence. Arrange the source rows in the order you want the stages displayed, usually largest to smallest, and check the chart after inserting it.

Can a funnel chart show percentages?
It can show the values used in the chart as data labels, but the usual funnel setup displays stage counts. Calculate or report conversion percentages separately, and clarify whether each rate uses the previous stage or the first stage as its denominator.

Why is my funnel chart upside down or out of order?
First check the order of the source rows and the chart’s selected data range. Reorder the source data to match the intended process sequence, then check whether the chart updates as expected. Also verify that the values are numeric rather than text.

Can I use a funnel chart for values that increase?
Excel can plot values that do not steadily decrease, but the result may no longer look or read like a conventional funnel. Confirm that the stages and measurements are valid, and consider a bar chart if increases or unrelated categories are central to the story.

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.