Creating a funnel chart in Excel helps sales and marketing teams visualize progressive stages and conversion rates at a glance. This quick guide shows you how to build a clean, professional funnel using just three straightforward steps.
Below is a structured summary of the key actions, tools, and expected outcomes when building an Excel funnel chart.
| Step | Action | Tool / Feature | Expected Result |
|---|---|---|---|
| 1 | Organize raw stage data in descending order | Excel table or range | Consistent top-down funnel values |
| 2 | Insert a stacked bar chart and switch rows/columns | Insert > Bar chart | Horizontal bar visualization ready for funnel shaping |
| 3 | Format gap width, remove fill, add data labels | Format Data Series, Chart Elements | Clean funnel chart with clear stage labels and percentages |
Organize your sales stages in structured order
Begin by arranging your pipeline data so that stages progress from widest at the top to narrowest at the bottom. Use a simple two-column layout with Stage Name and Value, and ensure values are sorted descending.
Consistent ordering prevents confusion later when you map data to chart segments. You can use Excel Sort or Power Query to prepare large datasets quickly and keep the logic transparent for stakeholders.
Insert and reshape a stacked bar chart
Create the base chart
Select your sorted table and insert a stacked bar chart through the Insert menu. Excel will map each stage to a separate bar segment, giving you the horizontal base shape needed for a funnel.
Switch axes and adjust colors
Use Select Data to switch row/column axes so stages appear vertically. Then reduce the gap width of the series and remove the fill for the invisible segment to reveal the classic funnel silhouette.
Apply final formatting for clarity
Add data labels and stage names
Turn on data labels directly on the bars, then customize them to show both stage names and percentages. Position labels outside for readability and adjust font size for dashboard integration.
Refine colors and white space
Choose a cohesive color palette that aligns with your brand or scenario theme. Trim margins, align axes, and test how the funnel chart looks on both screen and printed reports.
Next steps for building Excel funnels
- Prepare descending stage data with clear category and numeric columns.
- Insert a stacked bar chart and switch axes to align stages vertically.
- Remove fills, adjust gap width, and add descriptive data labels.
- Use Excel Tables to automate sorting and refresh behavior.
- Test appearance on screen and in print to ensure readability.
FAQ
Reader questions
How do I keep the funnel sorted when source data updates?
Use an Excel Table for your source data and rely on Power Query or a dynamic named range to keep stages automatically sorted descending after each refresh.
Can I create a funnel chart without combining stacked bars and a doughnut?
Yes, you can build a basic funnel using only stacked bars and manual formatting; the doughnut method is optional, and many teams prefer pure bar-based funnels for simplicity and clarity.
What if my stages have negative or zero values?
Filter out or clean zero and negative values before plotting, because funnel charts assume progressive reduction, and blanks or zeros can distort segment sizes and misleadingly compress the visual shape.
How do I display both percentage and absolute numbers on labels?
Customize data labels to show category name, percentage, and value by selecting More Options on the label menu, then format the label text to include all three elements for richer context.