How to Create Funnel Chart in Excel - Practical Guide

Learn to create a funnel chart in Excel to visualize sequential stages and conversion rates across a sales pipeline, marketing funnel, or process flow. Funnel charts display data as progressively narrowing stages, making it easy to identify where drop-offs occur and optimize your business process.

Why This Matters

Funnel charts are essential for sales, marketing, and project management professionals to track conversion rates and identify optimization opportunities. They provide clear visual insights into performance bottlenecks at each stage.

Prerequisites

•Basic Excel knowledge and ability to navigate the ribbon
•Data organized in a table with stage names and corresponding values
•Excel 2016 or later version installed

Step-by-Step Instructions

Prepare your data

Organize your data in two columns: stage names (e.g., Leads, Qualified, Proposal, Closed) in column A and corresponding values in column B. Ensure data is in descending order for proper funnel visualization.

Select the data range

Highlight your data range including headers (A1:B5 or your data range). Ensure both columns are selected with no blank rows between entries.

Insert chart

Navigate to Insert > Charts > Recommended Charts. Excel displays chart suggestions based on your data structure.

Select funnel chart type

In the chart gallery, find and click on Funnel under the All Charts tab. Choose the standard funnel chart option and click OK.

Customize and place chart

Add a title via Chart Title, adjust colors via Format > Shape Fill, and resize/position the chart on your worksheet as needed.

Alternative Methods

Using the Charts menu directly

Click Insert > Charts and browse All Charts, filtering by chart type to find Funnel without using recommendations.

Creating with a pivot table

Build a pivot table summarizing your stages and values, then insert a funnel chart from the pivot table data for dynamic updates.

Tips & Tricks

✓Arrange data in descending order (largest to smallest) for a proper visual funnel effect that narrows from top to bottom.
✓Use descriptive stage names and round values to whole numbers for cleaner, more readable charts.
✓Apply consistent color themes that align with your presentation or reporting standards.

Pro Tips

★Include percentage drop-off between stages as data labels (right-click chart > Add Data Labels) to highlight conversion efficiency.
★Use conditional formatting on source data to quickly identify underperforming stages before charting.
★Export funnel charts as PNG/PDF for presentations and dashboards using Chart > Export.

Troubleshooting

Funnel chart not appearing in chart options

Ensure you're using Excel 2016 or later, as funnel charts were introduced in recent versions. Update Excel and try again.

Chart appears inverted or reversed

Check that your data is sorted in descending order. If values are ascending, sort column B from largest to smallest and refresh the chart.

Data labels are overlapping or hard to read

Right-click the chart > Format Data Labels and adjust Label Position to Inside End or Outside End, or reduce font size.

Related Excel Formulas

SUBTOTAL SUM PERCENTILE RANK

Frequently Asked Questions

Can I create a funnel chart in Excel Online?

Funnel charts are available in Excel Online and on the web version, but with slightly limited customization options compared to desktop Excel. Most core features function identically.

How do I add percentage values to the funnel chart?

Right-click the chart, select Add Data Labels, then right-click labels and choose Format Data Labels. Enable Show as percentage to display conversion rates.

Can I use a funnel chart for non-sales data?

Yes, funnel charts work for any sequential process: user onboarding, project pipeline, recruitment stages, or customer support escalation. Any data with decreasing values across stages is suitable.