A funnel chart shows how a quantity shrinks at each stage of a sequential process. Each section is narrower than the one above it, so the biggest drop-offs are visible at a glance—no spreadsheet required.
Sales teams use funnel charts to see where deals stall in the pipeline. Marketing teams use them to find the checkout step that loses the most customers. Recruiters use them to track candidates from application to offer. Wherever a process has stages and each stage loses some volume, a funnel chart makes the loss visible and actionable.
In this guide, you'll learn what funnel charts are, when to use them instead of other chart types, how to create one step by step, and the design mistakes that make funnels misleading.
What Is a Funnel Chart?
A funnel chart is a visualization shaped like an inverted trapezoid (or literal funnel) divided into horizontal sections. Each section represents a stage in a sequential process, and its width is proportional to the value at that stage. The chart naturally narrows from top to bottom because each successive stage typically retains fewer items than the previous one.
The funnel metaphor dates back to the AIDA marketing model (Attention, Interest, Desire, Action) proposed by E. St. Elmo Lewis in 1898. The concept of visualizing progressive narrowing became standard in sales and marketing by the mid-20th century. Today, funnel charts are a core component of CRM dashboards, web analytics platforms, and product analytics tools like Amplitude and Mixpanel.
If you're new to data visualization, our beginner's guide to data visualization covers the fundamentals before you dive into specialized chart types.
When Should You Use a Funnel Chart?
A funnel chart is the right choice when your data represents a linear process where volume decreases at each stage. They excel at:
- Sales pipeline tracking — Show how leads move from prospect to qualified lead to proposal to closed deal, revealing where the pipeline is leaking
- E-commerce conversion analysis — Trace visitors from product page to cart to checkout to purchase, identifying the step that loses the most revenue
- Marketing funnel optimization — Map impressions to clicks to signups to activations, quantifying each stage's conversion rate
- Recruitment pipeline tracking — Follow candidates from application to screening to interview to offer to hire
- Customer onboarding — Track new users from account creation through setup steps to first value moment
- Content marketing funnel — Measure the path from blog visit to email signup to free trial to paid subscription
Funnel Chart vs. Other Charts: When to Use What?
Funnel charts overlap with several other visualization types. Choosing the wrong one hides important patterns in your data.
| Question You're Answering | Best Chart | Why Not a Funnel? |
|---|---|---|
| How much volume drops at each stage of a linear process? | Funnel chart | This is exactly what funnel charts are built for |
| How do users take multiple branching paths through a process? | Sankey diagram | Funnels assume a single linear path; Sankey handles branching flows |
| How does a value change through sequential additions and subtractions? | Waterfall chart | Waterfall shows positive and negative changes; funnels only show decreasing volume |
| What share does each category hold? | Pie chart or donut chart | Funnels show sequential stages, not static proportions |
| Which category is largest? | Bar chart | Bar charts compare independent categories; funnels show sequential narrowing |
| How does a metric trend over time? | Line chart | Funnels show stages, not time-based progression |
| What is the data distribution? | Histogram or box plot | Funnels are not designed for statistical distributions |
The most common mistake is using a funnel chart when a Sankey diagram is more appropriate. If users can take multiple paths (e.g., some skip stages, some loop back), a Sankey diagram shows the branching reality. A funnel assumes everyone enters at the top and exits at the bottom. See our Sankey diagram guide for when multi-path flow is the better fit. For the full chart selection framework, see our chart types explained guide.
How to Create a Funnel Chart: Step by Step
There are several ways to create funnel charts, from no-code tools to full programming environments.
Method 1: Use CleanChart (No Code Required)
The fastest way to create a funnel chart without writing any code:
- Prepare your data with two columns: stage name and value (count or amount at each stage)
- Go to CleanChart's funnel chart maker and upload your file
- Map your columns to stage labels and values
- Customize colors, labels, percentage display, and layout
- Export as PNG, SVG, or PDF for presentations and reports
You can upload data from multiple sources:
- CSV to funnel chart – Import comma-separated data files
- Excel to funnel chart – Upload .xlsx spreadsheets directly
- Google Sheets to funnel chart – Connect live spreadsheets
If your data needs cleaning before visualization, our complete CSV data cleaning guide walks through the process step by step.
Method 2: Google Sheets
Google Sheets does not have a native funnel chart type. You can approximate one with a stacked bar chart or use Google Charts (a JavaScript library) for a proper funnel. For most users, the easier path is to export your sheet and use the Google Sheets to funnel chart converter in CleanChart. See our Google Sheets to chart tutorial for the full workflow.
Method 3: Excel
Excel 2016+ includes a built-in funnel chart type. To use it: select your data (stage labels in one column, values in another), go to Insert > Charts > Funnel, and customize from there. Older Excel versions require workarounds with stacked bar charts. If you're evaluating options, our Excel vs. online chart makers comparison breaks down the trade-offs. For publication-quality output, see our publication-ready charts guide.
Method 4: Python (Plotly)
For programmers, Plotly provides a dedicated funnel chart module:
import plotly.express as px
import pandas as pd
data = pd.DataFrame({
"Stage": ["Visitors", "Signups", "Free Trial",
"Paid Plan", "Annual Plan"],
"Count": [10000, 4200, 1800, 620, 310]
})
fig = px.funnel(data, x="Count", y="Stage",
title="SaaS Conversion Funnel")
fig.update_traces(textinfo="value+percent initial")
fig.write_image("funnel.png", scale=2)
fig.show()The Plotly funnel chart documentation covers advanced customization including colors, text positioning, and stacked funnels. If coding isn't your preference, our guide on creating charts without Python covers no-code alternatives.
How to Structure Data for a Funnel Chart
Funnel chart data is straightforward: each row represents one stage in the process.
Basic Format (Most Common)
| Stage | Count |
|---|---|
| Website Visitors | 50,000 |
| Product Page Views | 22,000 |
| Add to Cart | 8,500 |
| Checkout Started | 4,200 |
| Purchase Complete | 2,800 |
Key rules:
- Stages must be in order from largest to smallest (top to bottom)
- Each row needs exactly two fields: a stage name and a numeric value
- Values should represent the same unit throughout (users, dollars, leads)
Extended Format (with Conversion Rates)
For more detailed analysis, add conversion rate and drop-off columns:
| Stage | Count | Conversion Rate | Drop-off |
|---|---|---|---|
| Visitors | 50,000 | 100% | — |
| Product Page | 22,000 | 44% | 56% |
| Add to Cart | 8,500 | 38.6% | 61.4% |
| Checkout | 4,200 | 49.4% | 50.6% |
| Purchase | 2,800 | 66.7% | 33.3% |
CleanChart uses the Stage and Count columns for the visual and can display conversion rates as annotations. If your data has missing values or inconsistent stage names, clean it first using our guide to handling missing values in CSV files.
Practical Funnel Chart Examples
Example 1: SaaS Sales Pipeline
A B2B software company tracks their sales pipeline with six stages: Leads (1,200), Marketing Qualified (680), Sales Qualified (340), Demo Scheduled (210), Proposal Sent (95), Closed Won (42). The funnel immediately reveals a 50% drop between Marketing Qualified and Sales Qualified—signaling a lead scoring problem. The sales team focuses handoff criteria and improves the MQL-to-SQL rate by 15% in the next quarter. For the full picture of sales visualization, see our guide to visualizing sales data.
Example 2: E-Commerce Checkout Optimization
An online retailer maps the purchase journey: Product Views (100,000), Add to Cart (28,000), Cart Page (19,500), Shipping Info (12,300), Payment (9,800), Order Confirmed (8,200). The biggest absolute drop-off is between Product View and Add to Cart (72,000 lost), but the biggest relative surprise is between Cart Page and Shipping Info—a 37% loss suggests the shipping form is too complex. The product team simplifies it and recovers $450K in quarterly revenue.
Example 3: Content Marketing Funnel
A content marketing team measures their blog-to-customer pipeline: Blog Visitors (80,000), Email Subscribers (3,200), Free Trial Signups (640), Active Trial Users (380), Paid Customers (120). The 4% blog-to-subscriber conversion is below the industry benchmark of 5-10%, indicating the CTA placement or lead magnet needs improvement. For techniques on structuring marketing reports, see our business reports with charts guide.
Example 4: Recruitment Pipeline
An HR team tracks their hiring pipeline for engineering roles: Applications Received (500), Resume Screening Passed (120), Phone Interview (75), Technical Interview (40), Onsite Interview (18), Offer Extended (8), Offer Accepted (5). The funnel shows that 76% of applicants fail resume screening—suggesting either poor job posting targeting or overly strict criteria. The team adjusts their job listings and improves the application-to-screen rate. For presenting this kind of data in reports, see our charts for survey data guide.
Funnel Chart Best Practices
- Order stages top to bottom, largest to smallest. This is the defining visual convention of funnel charts. If your data doesn't naturally decrease at each stage, a funnel chart may not be the right choice—consider a horizontal bar chart instead.
- Show both absolute numbers and percentages. Absolute numbers show scale ("we lost 28,000 users at checkout"). Percentages show rates ("67% drop-off at checkout"). Together, they tell the complete story. A $10M pipeline with 20% conversion is very different from a $100K pipeline with the same rate.
- Use consistent colors with intentional variation. A gradient from dark at the top to light at the bottom reinforces the narrowing flow. Alternatively, use a single brand color for most stages and highlight the biggest drop-off in red. For color guidance, see our guide on color in data visualization and our color palette guide.
- Label every stage clearly. Each segment should display the stage name, value, and conversion rate without requiring the viewer to refer to a legend or calculate mentally.
- Keep stages between 4 and 8. Fewer than 4 stages makes the funnel trivial—a simple table works. More than 8 stages compress the lower segments into unreadable slivers. Group granular steps if needed.
- Include stage-over-stage conversion rates. The percentage from one stage to the next (not just from the top) is the most actionable metric. "38% of Add-to-Cart users complete checkout" is more useful than "8% of all visitors complete checkout."
Common Mistakes to Avoid
Mistake 1: Using Funnel Charts for Non-Sequential Data
A funnel implies a process with ordered stages. If your data is just categories ranked by size (e.g., revenue by product), use a bar chart. Forcing non-sequential data into a funnel misleads viewers into thinking there's a conversion process.
Mistake 2: Inconsistent Stage Definitions
If "Leads" means different things in different months (e.g., marketing leads vs. total form fills), your funnel comparison across time is meaningless. Define each stage precisely and consistently. Our common data cleaning mistakes article covers this category of error in detail.
Mistake 3: Ignoring Time Cohorts
A funnel built from a snapshot (today's leads count vs. today's customers count) mixes cohorts—today's leads haven't had time to convert. Use cohort-based data where you track the same group through each stage. Otherwise, your conversion rates are artificially low or high.
Mistake 4: No Benchmarks or Context
A 5% conversion rate means nothing without context. Is that good or bad? Compare against previous periods, industry benchmarks, or internal targets. Add reference annotations showing the target rate alongside the actual rate.
Mistake 5: Treating the Funnel as Only Decreasing
Some processes have stages where volume can increase (e.g., referrals bringing new leads into the middle of the funnel). Standard funnel charts can't represent this. If your process has inflows at intermediate stages, consider a Sankey diagram instead, which handles branching and merging flows.
When Should You NOT Use a Funnel Chart?
- Your data doesn't represent a sequential process — Use a bar chart for independent category comparisons
- Users take multiple branching paths — Use a Sankey diagram to show the branching reality. See our Sankey diagram guide
- You need to show increases and decreases — Use a waterfall chart for sequential gains and losses. See our waterfall chart guide
- You have fewer than 3 stages — A simple percentage or a donut chart is clearer for two-stage conversions
- Your stages don't naturally decrease — Funnels visually imply narrowing; if stages fluctuate up and down, use a bar chart or line chart
- You want to compare across many segments simultaneously — Side-by-side funnels get cluttered quickly; use a heatmap showing conversion rates by segment and stage
Advanced Funnel Chart Techniques
Side-by-Side Funnels for A/B Comparison
Place two funnels next to each other to compare conversion rates between segments (e.g., mobile vs. desktop, US vs. EU, control vs. variant). This immediately highlights which segment performs better at each stage. Keep both funnels on the same scale so widths are comparable.
Time-Series Funnel Tracking
Create the same funnel chart weekly or monthly and compare conversion rates over time. Display the rates in a line chart with one line per stage-to-stage conversion. This reveals whether optimization efforts are working. Our time series charts guide covers temporal tracking techniques.
Funnel with Revenue Overlay
Instead of showing just counts, create a second funnel showing the revenue value at each stage. A stage with few users but high revenue per user might be more important to optimize than a high-volume, low-value stage.
How to Make Funnel Charts Accessible
Funnel charts rely on width and color to convey information, which creates accessibility challenges. To make yours inclusive:
- Use colorblind-safe palettes. Avoid relying solely on red/green distinctions. Use palettes where hue, saturation, and brightness all differ. Our guide to colorblind-friendly charts has specific palette recommendations.
- Add text labels to every stage. Each segment should display the stage name, count, and conversion rate directly on the chart, not just in tooltips.
- Provide an alternative data table. Include a simple table below the chart showing Stage, Count, Conversion Rate, and Drop-off. This gives full accessibility to screen reader users.
- Use descriptive chart titles. Instead of "Sales Funnel," write "Q1 2026 Sales Pipeline: 1,200 Leads to 42 Closed Deals" so the purpose and scale are clear without seeing the visual.
Frequently Asked Questions
What data format do I need for a funnel chart?
A funnel chart needs two columns: stage name and a numeric value. Each row represents one stage of the process, ordered from largest to smallest. You can supply this as a CSV file, Excel spreadsheet, or Google Sheet.
What is the difference between a funnel chart and a Sankey diagram?
A funnel chart shows a single linear path where volume decreases at each stage. A Sankey diagram shows multiple branching paths where volume can split and merge between stages. Use a funnel when everyone follows the same sequence of steps. Use a Sankey when users can take different routes through the system. See our Sankey diagram guide for details.
What is the difference between a funnel chart and a waterfall chart?
A funnel chart shows decreasing volume across process stages (e.g., 1,000 leads become 100 customers). A waterfall chart shows how a value changes through both positive and negative increments (e.g., revenue minus costs equals profit). Funnels show loss at each stage; waterfalls show gains and losses. See our waterfall chart guide.
Can I create a funnel chart in Excel?
Excel 2016 and later include a built-in funnel chart type under Insert > Charts. Older versions require workarounds using stacked bar charts with invisible spacers. For a simpler approach with more customization, use CleanChart's funnel chart maker. Our Excel vs. online chart makers comparison covers the trade-offs.
Can I create a funnel chart from Google Sheets?
Google Sheets does not have a native funnel chart type. The Google Sheets to funnel chart converter in CleanChart is the easiest path. Our Google Sheets to chart tutorial covers the full workflow.
How many stages should a funnel chart have?
Aim for 4–8 stages. Fewer than 4 makes the funnel trivial (just show the numbers in text). More than 8 compresses lower stages into unreadable slivers and overwhelms viewers. If your process has more than 8 stages, group related steps (e.g., combine "Shipping Address" and "Billing Address" into "Checkout Details").
What is a good conversion rate for a sales funnel?
Conversion rates vary dramatically by industry, price point, and sales model. B2B SaaS typically sees 1–5% visitor-to-trial and 15–30% trial-to-paid. E-commerce sees 2–4% visitor-to-purchase. The HubSpot marketing benchmark report provides industry-specific data. The most useful comparison is against your own historical rates, not abstract benchmarks.
Create Your First Funnel Chart
Funnel charts turn pipeline data into a visual story of where your process works and where it leaks. Whether you're optimizing a sales pipeline, improving checkout conversion, or tracking recruitment stages, a funnel chart shows the drop-offs that matter most.
Ready to try it? Create a funnel chart with CleanChart—upload your data from CSV, Excel, or Google Sheets and get a publication-ready chart in under a minute.
Related CleanChart Resources
- Funnel Chart Maker – Create funnel charts online, free
- CSV to Funnel Chart – Convert CSV files directly
- Excel to Funnel Chart – Convert Excel spreadsheets
- Google Sheets to Funnel Chart – Import from Google Sheets
- Sankey Diagram Maker – Multi-path flow visualization
- Waterfall Chart Maker – Sequential gains and losses
- Bar Chart Maker – Compare categories side by side
- Line Chart Maker – Track trends over time
- Pie Chart Maker – Show parts of a whole
- Heatmap Maker – Spot patterns across dimensions
- How to Create a Sankey Diagram – Complete Sankey guide
- How to Create a Waterfall Chart – Complete waterfall guide
- Chart Types Explained – Find the right chart for your data
- Visualize Sales Data – Sales chart examples and techniques
- Business Reports with Charts – Professional report design
- Data Visualization for Beginners – Start here
- Color in Data Visualization – Choose effective colors
External Resources
- Wikipedia: Purchase Funnel – History of the AIDA model and funnel concept
- Plotly Funnel Chart Documentation – Python reference for programmers
- HubSpot Marketing Statistics – Industry benchmarks for funnel conversion rates
- NerdSip – Micro-learning platform for data literacy and analytics fundamentals
- From Data to Viz – Decision guide for choosing chart types
- Storytelling with Data – Best practices for data communication
Last updated: February 13, 2026