How to Create a Funnel Chart

A funnel chart is one of the most effective ways to visualize how users or customers move through a series of steps, instantly showing you where they drop off. This article walks you through what a funnel chart is, when to use one, and exactly how to build your own in common tools like Excel, Google Sheets, and Power BI.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What is a Funnel Chart and Why Is It Useful?

Imagine pouring water into a bottle through a funnel. You start with a wide opening, but the liquid is channeled into a much narrower space. A funnel chart works the same way for data. It represents stages in a process using progressively smaller bars, showing a decrease in value at each step.

The classic example is a sales pipeline:

• Leads: 1,000 people who showed initial interest.
• Qualified Leads: 400 of those who fit your target customer profile.
• Meetings Booked: 150 who agreed to a demo.
• Proposals Sent: 50 who received a price quote.
• Deals Closed: 10 who became paying customers.

When visualized as a funnel chart, you can immediately see the drop-off rate between each stage. This visual makes it incredibly easy to spot bottlenecks. For instance, if you lose a huge percentage of people between "Qualified Leads" and "Meetings Booked," you know there's likely a problem in your follow-up process that needs investigation.

The main benefit of a funnel chart is its clarity. It answers a critical question at a glance: Where is our process breaking down? By highlighting the largest drop-offs, it guides your team on where to focus their efforts to make the biggest impact.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

When Should You Use a Funnel Chart?

Funnel charts aren't just for sales teams. They are perfect for visualizing any linear process with sequential stages. Here are a few common scenarios where a funnel chart provides immense value:

• Marketing Campaign Analysis: Track conversions from ad impressions to clicks, lead form fills, and finally to a purchase. You can quickly see which part of the customer journey needs optimizing.
• E-commerce Checkout Process: Visualize how many users visit a product page, add an item to their cart, initiate checkout, and complete the purchase. A big drop-off at the shipping information stage might indicate high shipping costs.
• User Onboarding Flow: Monitor how new users move through your product's setup process, from creating an account and completing their profile to inviting their first team member.
• Recruitment Pipeline: Track job applicants as they move from application submission, through phone screenings, interviews, and finally to a job offer. This helps HR identify stages where great candidates might be dropping out.
• Lead Nurturing Sequences: Analyze how many leads open your first email, click a link, download a resource, and eventually book a demo.

How to Build a Funnel Chart: Step-by-Step Guides

Building a funnel isn't always a one-click process, but with a few simple steps, you can create one in your favorite spreadsheet or BI tool. Here’s how.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

How to Create a Funnel Chart in Microsoft Excel

Newer versions of Excel (2019, Microsoft 365) have a built-in Funnel chart type, making this process very easy. If you're on an older version, don't worry - you can still create a beautiful funnel using a simple bar chart trick.

Method 1: Using the Built-in Chart (Excel 2019+)

If your version of Excel has the waterfall/funnel option, you’re in luck. This is the fastest way.

1. Set up your data: Create two columns. One for the stages of your funnel (e.g., "Awareness," "Consideration," "Conversion") and one for the corresponding values (the number of people at each stage).
2. Insert the chart: Highlight your data. Go to the Insert tab, find the Charts group, and click the "Insert Waterfall, Funnel, Stock, Surface, or Radar chart" icon. Select Funnel from the list.
3. Customize: Excel will instantly generate the funnel chart. From here, you can customize the title, change the colors under the Chart Design tab, and add data labels by right-clicking the bars and choosing Add Data Labels. It’s that simple.

Method 2: The Bar Chart Trick (All Excel Versions)

If you don't have the built-in option, this method works universally and gives you full control.

1. Organize your data: You'll need three columns:
2. Calculate the Offset: In the first cell of your Helper column (B2), enter this formula. It finds the largest value in your funnel and uses it to calculate the needed space to center your real data bars.

=(MAX($C$2:$C$5)-C2)/2

*(Be sure to adjust the cell ranges $C$2:$C$5 to match your data. The $ symbol makes the cell reference absolute so it doesn't change when you drag the formula down.)

Drag this formula down for all your stages.

1. Create a Stacked Bar Chart: Highlight all three columns (Stage, Offset, and Value). Go to the Insert tab and choose Chart > 2-D Bar > Stacked Bar.
2. Make the Offset transparent: Your chart will appear with two series - the offset bars (likely in blue) and your value bars. Click on one of the blue bars to select the Offset series. Right-click, choose Format Data Series, and in the "Fill" options, select No fill. The bars will become invisible, leaving your value bars perfectly centered.
3. Flip the Funnel: A funnel should go from top to bottom. To fix this, click on the vertical axis (your stage labels). Right-click, select Format Axis, and in the Axis Options panel, check the box for Categories in reverse order.
4. Final Touches: Remove the legend, add a chart title, and right-click your visible bars to Add Data Labels. You now have a professional-looking funnel chart.

How to Create a Funnel Chart in Google Sheets

Google Sheets doesn't have a native funnel chart type, but the same bar chart trick we used for older Excel versions works perfectly.

1. Arrange your data: Just like in Excel, set up three columns: Stage in column A, the invisible Offset in column B, and your actual Value in column C.
2. Enter the Offset formula: In cell B2, use the same formula as before, adjusting for your data range:

=(MAX($C$2:$C$5)-C2)/2

Drag the formula down to apply it to all stages.

1. Insert a Stacked Bar Chart: Select your entire data range. Go to Insert > Chart. In the Chart editor that pops up, select Stacked bar chart as the chart type.
2. Hide the Offset Series: In the Chart editor, go to the Customize tab. Expand the Series menu. Select your Offset/Helper series from the dropdown. Change its color to None.
3. Reverse the Axis: Still in the Customize tab, find the Vertical axis menu. Check the box for Reverse axis order. Your chart will now be shaped like a proper funnel.
4. Clean up: Customize the title, remove the legend, and under the Series menu, check the box for Data labels to make the chart easy to read.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

How to Create a Funnel Chart in Power BI

Business intelligence tools like Power BI are built for visualizations like this, and creating a funnel chart is much more direct.

1. Load your data: First, connect Power BI to your data source (an Excel file, a database, etc.) and load the data into the model. Make sure you have a column for your stages and a column for the values.
2. Select the Funnel Visual: In the Report view, look at the Visualizations pane on the right side. You'll see an icon that looks like a funnel. Click on it to add a funnel visual to your canvas.
3. Populate the Fields: With the blank funnel selected, drag your stage field from the Data pane into the Group or Category well in the Visualizations pane. Then, drag your numeric value field into the Values well.
4. Magic! Power BI automatically generates an interactive funnel chart for you. You can format colors, labels, and titles in the Format your visual section (the paintbrush icon) of the Visualizations pane.

Best Practices for Effective Funnel Charts

Creating the chart is just the first step. To make it truly insightful, follow these best practices:

• Label Your Conversion Rates: The magic of a funnel lies in the drop-off rates. Manually add data labels showing the percentage conversion from the previous step. For example, if Stage 1 has 1000 and Stage 2 has 500, the label for Stage 2 should read "500 (50%)". This immediately highlights the efficiency of each step.
• Keep it Simple: Don’t overwhelm your audience. Stick to 5-7 distinct stages for clarity. If your process has more steps, group related ones together into a single, logical stage.
• Use Color Strategically: Instead of a multi-color rainbow, use a single color gradient that gets lighter or darker with each stage to show progression. Alternatively, use a neutral color for all stages and a bright, contrasting color to draw immediate attention to the stage with the biggest drop-off.
• Add Context: A chart shows the "what," not the "why." Add a title that explains the chart clearly (e.g., "Q4 Sales Pipeline Conversion Rates"). Use annotations or accompanying text in your report to explain why a particular drop-off is happening and what actions are being taken to address it.

Final Thoughts

Funnel charts offer a remarkably clear way to diagnose the health of any sequential process, showing you exactly where to focus your improvement efforts. Whether you're using Excel's simple built-in charts or diving into a dedicated BI tool like Power BI, building a funnel is a skill every marketing and sales professional should have.

Building a single funnel report is one thing, but manually pulling data from your ad platforms, website analytics, and CRM every week to update them is another. At Graphed, we automate all that. You just connect your data sources once, and then you can create real-time funnel dashboards and reports by simply describing what you want in plain English. No more downloading CSVs or wrestling with pivot tables - just clear, instant insights that stay up-to-date automatically.