How to Create a Funnel Chart in Tableau

Building a funnel chart in Tableau is one of the most effective ways to see exactly where customers are dropping off in your marketing or sales process. Instead of getting bogged down in rows of data, a funnel chart gives you a clear, immediate visual of your conversion pipeline's health. This tutorial will walk you through a step-by-step process to build a practical and visually appealing stepped funnel chart, perfect for any dashboard.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

What Exactly is a Funnel Chart?

A funnel chart is a visualization that shows the progressive flow of users or customers through specific, sequential stages. Think of a real-world funnel: wide at the top and narrow at the bottom. The chart mimics this shape, with each section representing a stage and its size corresponding to the number of people in that stage. The initial stage, like "Website Visitors," is the largest, while the final stage, such as "Purchase Complete," is the smallest.

The primary value of a funnel chart lies in its ability to instantly highlight bottlenecks. If you see a dramatic drop-off between two stages, you’ve immediately identified a problem area that needs investigation. Marketers and sales teams use them constantly to track things like:

• Sales Pipeline: Moving leads from "Prospect" to "Initial Contact," "Demo," "Proposal," and finally "Closed-Won." A big drop after the "Proposal" stage might signal pricing issues.
• Marketing Conversion: Tracking users from an "Ad Click" to a "Landing Page Visit," "Form Submission," and "Email Sign-up." If few people are filling out the form, the landing page copy might need work.
• E-commerce Checkout: Following customers from "Viewed Product" to "Added to Cart," "Began Checkout," and "Completed Purchase." High cart abandonment becomes obvious with a funnel chart.

Preparing Your Data for Tableau

Before you even open Tableau, the most important step is ensuring your data is structured correctly. Messy data will lead to frustration and a chart that doesn't work. For a standard funnel chart, you need a simple, clean table with at least two columns:

1. A column for the stages of your funnel (a dimension).
2. A column for the corresponding value at each stage (a measure), like the number of users, deals, or sign-ups.

Your data might look something like this simple sales pipeline example:

Stage Name,Deal Count Initial Outreach,2500 Initial Reply,1800 Meeting Booked,950 Proposal Sent,400 Deal Closed,150

The names don't matter as much as the structure. You could have "Funnel Step" and "User Count" instead. The key is that each row represents a distinct, sequential stage of your process.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

How to Create a Funnel Chart in Tableau: The Step-by-Step Guide

Once your data is ready, we can start building the chart. We'll be creating a classic "stepped" funnel chart, which uses a clever trick with negative values to center the shape. Follow these steps carefully.

Step 1: Connect to Your Data and Set Up the Stages

First, open Tableau and connect to your data source (like the Excel or CSV file you prepared). Once it’s loaded, drag your "Stage Name" dimension onto the Rows shelf.

Immediately after, you need to sort your stages in the correct logical order. Tableau will likely sort them alphabetically, which won't work for a funnel. Right-click the "Stage Name" pill in the Rows shelf, select Sort, and choose "Manual." Drag and drop the stages into the correct sequence from top to bottom (e.g., Initial Outreach at the top, Deal Closed at the bottom). This step is critical - an unsorted funnel is meaningless.

Step 2: Create the Right Side of the Funnel

Next, drag your numeric measure (e.g., "Deal Count") onto the Columns shelf. Tableau will automatically aggregate it, likely as SUM([Deal Count]), creating a standard horizontal bar chart. This represents the right half of our funnel.

Step 3: Create the Left Side of the Funnel for Symmetry

Here’s the trick that makes the funnel shape. We need to create a mirrored, negative version of our bar chart. The easiest way to do this is to double-click on an empty space in the Columns shelf and type in the negative version of your measure aggregate:

-SUM([Deal Count])

Press Enter. Tableau will create a second pill and a second bar chart pointing to the left. You should now see two bar charts, back-to-back.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Step 4: Change the Mark Type to an Area

Right now, your chart still looks like separate bars. To transform it into a connected funnel shape, navigate to the Marks card. Click the dropdown menu that currently says "Automatic" (or "Bar") and change it to Area.

Instantly, your visualization will transform. The distinct bars will merge into solid, filled areas, creating the classic symmetrical funnel visualization. You're almost there!

Step 5: Add Color for Visual Distinction

A monochrome funnel works, but adding color makes the stages even clearer. Drag your measure (SUM([Deal Count])) from the Data pane onto the Color shelf on the Marks card. By default, Tableau will apply a color gradient - often blue - where darker shades represent higher values. This gives a nice professional finish and reinforces the decreasing size of each stage.

Step 6: Add Labels for Context

A chart without labels forces the viewer to guess at the numbers. Let’s add the labels directly onto the funnel.

• Drag the "Stage Name" dimension to the Label shelf.
• Drag the `SUM(Deal Count)` measure to the Label shelf as well.

Your labels will now appear on the chart, but they might be misaligned. On the Marks card, click the Label button. Under the "Alignment" options, click the dropdown for "Horizontal" and select the center option. This will position your labels neatly in the middle of each funnel section.

Step 7: Final Polish and Formatting

The last step is to clean up a few distracting elements to make your chart presentation-ready.

• Hide the Axes: The numeric axes at the top of the chart are now redundant since we have labels. Right-click on the top axis (the one showing the deal counts) and uncheck "Show Header."
• Remove Grid Lines: To create a cleaner look, get rid of the vertical lines running through the chart. Right-click anywhere on the chart, select Format, go to the "Lines" tab (a border icon), and under "Columns," set the "Grid Lines" dropdown to "None."
• Edit Tooltips: Hover over a funnel stage. The tooltip might show positive and negative values. You can clean this up by clicking on the Tooltip button on the Marks card and editing the text to only show the relevant information, like Stage Name and the positive deal count.

Taking Your Funnel Analysis Further

Building the chart is only half the battle, the real value is in the insights you draw from it.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Calculate Conversion Rates

The most important metric in any funnel is the conversion rate from one stage to the next. In Tableau, you can display this using a calculated field and the LOOKUP function.

Create a new calculated field called "Conversion Rate" with this formula:

SUM([Deal Count]) / LOOKUP(SUM([Deal Count]), -1)

Here’s what this does: LOOKUP(SUM([Deal Count]), -1) tells Tableau to "look" at the previous row's SUM of Deal Count. The formula then divides the current stage's count by the previous one. Drag this new calculated field to your Tooltip to show the conversion rate when a user hovers over a stage.

Now, when you hover over the "Meeting Booked" stage, you can see not only that you have 950 deals, but that this represents a 52.7% conversion rate from the "Initial Reply" stage - a much richer piece of information.

Spotting and Questioning Bottlenecks

Look for the steepest drop-offs. In our example data, we see a huge drop from "Meeting Booked" (950 deals) to "Proposal Sent" (400 deals). That's a huge leak in the funnel.

This chart prompts you to ask critical business questions:

• "Why are we losing more than half of our prospects between the meeting and the proposal?"
• "Is our BDR a great appointment setter but our salesperson is failing to qualify them properly during the meeting?"
• "Are prospects dropping out because they aren’t a good fit?"

The chart doesn't give you the answer, but it tells you exactly where to start digging for it.

Final Thoughts

Creating a funnel chart in Tableau transforms rows of conversion data into a powerful, insightful story that anyone can understand. By structuring your data, using a mirrored measure for symmetry, and adding clear labels, you can quickly build a dashboard component that highlights issues and drives important business conversations.

While mastering tools like Tableau provides deep control over your visualizations, we know that many teams don't have hours to spend on chart creation and formula writing. That's why we created Graphed. Inside, you can simply connect your Salesforce, HubSpot, or other data sources and ask in plain English, "Show me a funnel of our sales pipeline for this quarter," and get an automated, live-updating dashboard in seconds. It's built to give you the insights without the BI busywork.