Excel 2013 does not include a built-in funnel chart, so there is no menu or ribbon location where you can insert one. You can approximate a funnel with a 2-D stacked bar chart and a hidden spacer series, or use a newer Excel version that offers a dedicated Funnel chart type.
Where the funnel chart is in Excel 2013
Nowhere in the standard chart gallery: Excel 2013 has no native Funnel chart command. Checking Insert > Recommended Charts or the other chart menus will not reveal one, and installing an update to Excel 2013 does not add that chart type. This is a version limitation, not a setting you need to turn on.
In later versions, the chart is available from the Insert tab in the chart gallery that groups Waterfall, Funnel, Stock, Surface, and Radar charts. The exact gallery wording can vary slightly by release, but Excel 2019 and Microsoft 365 include a built-in Funnel chart. If you are following instructions written for a newer version, that is why the pictured command may be missing from your Excel 2013 screen.
The distinction matters because a chart made from stacked bars is a workaround: it can look like a funnel, but it is still a bar chart underneath. Excel 2013 will not treat it as a native funnel or provide funnel-specific options.
What a funnel chart shows
A funnel chart presents values at successive stages of a process. Common examples include website visitors moving to product views, sign-ups, and purchases; or sales prospects moving from qualified leads to proposals and closed deals. Each stage is represented by a band, and the changing width makes increases or losses between stages easy to notice.
For a typical conversion funnel, the values decrease from the first stage to the last. The chart can make the overall drop-off visible, but it does not explain why people left the process. To investigate that, pair the chart with stage conversion rates, time periods, or notes about how each stage is defined. Comparing counts from inconsistent time windows can make a funnel look meaningful while telling a misleading story.
Funnel charts are most useful when the stages form a clear sequence and the numbers are comparable counts or amounts. They are not automatically the best display for every set of categories. If the values do not represent movement through a process, an ordinary bar chart may communicate the comparison more clearly.
Make a funnel-style chart with stacked bars
A practical Excel 2013 workaround centers each stage bar by placing an invisible segment before the visible value. Start with a small table like this, with stage names in A2:A5, spacer values in B2:B5, and stage amounts in C2:C5:
- Awareness — 1,000
- Qualified — 700
- Proposal — 450
- Won — 200
Put the headings Stage, Spacer, and Amount in A1:C1, and enter the stage names in A2:A5 and the amounts in C2:C5. With amounts in C2:C5, enter this formula in B2 to calculate the centered spacer for the first row:
=(MAX($C$2:$C$5)-C2)/2
Copy the formula from B2 down through B5. For the example, the spacer values are 0, 150, 275, and 400. Each spacer plus its amount totals no more than the maximum amount of 1,000, and the visible bars are centered around the same midpoint.
- Select A1:C5, including the headings.
- Choose Insert > Insert Bar Chart > 2-D Stacked Bar. In some Excel 2013 installations, the gallery button is labeled simply Bar Chart; choose the 2-D Stacked Bar option, not Clustered Bar.
- Check that Stage is used for the category labels and that Spacer and Amount are the two series. If Excel arranged the data differently, use Chart Tools > Design > Select Data to correct the series and category ranges.
- Make the Spacer series invisible, then adjust the axes and labels as described below.
The spacer series must come before Amount in the stack. Because the helper table places Spacer in column B and Amount in column C, Excel normally uses that order when the table is selected as shown. If the colored amount bars begin at the chart axis instead of appearing centered, check the series order and confirm that the chart type is stacked.
Format the chart so it reads like a funnel
Click one of the spacer segments to select that series. Right-click and choose Format Data Series, then choose Fill > No fill in the formatting pane. If the spacer still has a border, set its line to No line as well. The spacer values remain part of the chart calculations even though their color is hidden; deleting the series would remove the centering effect.
Next, make the stage sequence read from top to bottom. Right-click the vertical category axis, choose Format Axis, and select Categories in reverse order if needed. Excel can reposition the horizontal value axis when you reverse categories, so check that the stage labels and bars are still easy to read. If the amount scale distracts from the shape, hide the value axis and its gridlines; retain enough context elsewhere, such as a chart title or labels, so readers know what the bar widths represent.
To label the actual values, select the colored Amount series, right-click, and choose Add Data Labels. Do not add labels to the invisible Spacer series: those numbers are layout aids, not business results. You can use the Chart Tools layout controls or the Format Data Labels pane to position and style the labels. A short title such as Leads by Sales Stage and clear units help explain the chart without making the bars carry too much text.
Finally, adjust the bar spacing if the bands look too far apart. Right-click a visible bar and open Format Data Series; the Gap Width option controls the space between categories. A smaller gap makes the chart look more continuous, while a small separation can make individual stages easier to distinguish. Preview the chart at its final size, since labels that fit on a large worksheet may overlap when the chart is placed in a report.
Limits and common problems
This method imitates the silhouette of a funnel, but it has trade-offs. Excel sees two stacked series, not a funnel. The invisible spacer can confuse someone editing the chart later, labels and colors require manual care, and changes to the input data may call for rechecking the axis scale and formatting. Add a note or use descriptive series headings so another workbook user understands why the Spacer series exists.
- The bars start at the left edge: Confirm that the chart is 2-D Stacked Bar, not Clustered Bar, and that Spacer is the first series.
- The chart looks lopsided: Check that the spacer formula refers to the largest amount in the full range and that the formula was copied to every stage.
- The first or last stage is in the wrong place: Reverse the category order in Format Axis, then check the axis crossing and label position.
- A label shows a spacer number: Remove labels from Spacer and add them only to Amount.
- The bars extend past the plot area: Check for unexpected negative values or a value-axis maximum that is smaller than the largest amount.
The formula assumes nonnegative amounts. A zero amount produces no visible colored bar, and negative values do not make sense for an ordinary conversion funnel. Values that rise at later stages can still be plotted, but the funnel shape may imply a one-way drop-off that the data does not support. Review the process and definitions before presenting the visual.
Choosing between the workaround and other options
Use the stacked-bar workaround when you need a funnel-like visual in an Excel 2013 workbook and can maintain a few helper values. It is suitable for a small, stable stage list where the main goal is to show relative size. Keep the source amounts in a clearly identified column and avoid typing spacer figures by hand; the formula recalculates the offsets when the amounts change.
If a native chart is important, open the workbook in Excel 2019 or Microsoft 365 and insert a Funnel chart from the appropriate Insert chart gallery. Check the resulting chart and labels before sharing: features and formatting behavior can depend on the Excel release, and colleagues using Excel 2013 may not be able to edit the newer chart as a native funnel. If the workbook must remain usable in Excel 2013, test it on that version before distributing it.
For a quick presentation graphic that does not need to update with worksheet data, you could draw tapered shapes or use a diagram tool. That can give you more control over appearance, but the shapes will not automatically track changing values. For precise comparisons, a regular bar chart is often a better alternative: it makes it easier to compare individual values because all bars share a common starting point. A table with conversion percentages can also add context that a funnel silhouette alone cannot provide.
Frequently Asked Questions
Does Excel 2013 have a funnel chart?
No. Excel 2013 does not include a built-in Funnel chart type. You can create a similar appearance with a stacked bar chart and an invisible spacer series, or use a version that includes the native chart.
Where is the Funnel chart in Excel 2013?
There is no Funnel command in Excel 2013’s Insert chart galleries. The funnel option shown in some tutorials applies to newer versions, not a hidden Excel 2013 menu.
Can I make a funnel chart without a formula?
Yes, but you would need to enter spacer values manually or create the appearance with shapes. A formula-based spacer is usually easier to maintain because it recalculates when the stage amounts change.
Why is my Excel funnel chart showing the spacer values?
The spacer series is a real chart series used to center the visible bars. Hide its fill and line, and add data labels only to the Amount series. Do not remove the spacer series if you want the bars to remain centered.
Will a funnel chart made in a newer Excel version work in Excel 2013?
A newer workbook may open in Excel 2013, but the native funnel chart may not remain fully editable as that chart type there. If the file must be edited in Excel 2013, use the stacked-bar workaround or check compatibility in the actual workbook before relying on the newer chart.
Related
- Simple Project Timeline in Excel: Build a Clear Schedule
- Vendor Quote Comparison Template: Build It in Excel
- Vendor Contact List Template Excel: Free Setup Guide
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Create an Org Chart From Excel Data in Microsoft ExcelYes—you can create an org chart from Excel data by organizing employee names and reporting levels, then inserting…
- DAX Formula in Pivot Table: Measures and ExamplesA DAX formula in an Excel PivotTable is usually a measure: a calculation stored in the workbook’s Data…
- Excel Trendline Equation in a Cell: How to Calculate ItYes. For a linear trendline, calculate its slope and intercept in worksheet cells, then use those values to…
- Excel Copy Chart Formatting to Another Chart QuicklyTo copy a chart’s formatting in Excel for Microsoft 365 on Windows, select the source chart and press…
- Excel Box Plot X-Axis Labels: Set and Fix ThemIn Excel for Microsoft 365 on Windows, a box plot’s x-axis labels normally come from the column headers…
- Excel Chart: Add a Vertical Line at a DateTo add a vertical line at a date in an Excel chart, create a helper series with the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.