Create an Advanced Funnel Chart in Excel with a Scatter Series
Question details
Create an Excel funnel-style combination chart with numerical values on the horizontal axis and category labels on the vertical axis.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A funnel visualization combines horizontal bars with boundary lines and secondary axes.
- Observed behavior
- The desired chart displays category labels alongside bars while plotting numerical boundary coordinates on the X-axis.
Arrange the funnel stages and their numerical values in worksheet columns, and decide on a common maximum value for the horizontal scale. The steps below use positive values and position the first category at the top of the chart.
Combine stacked bars with scatter boundary lines
Use horizontal stacked bars for category labels and XY scatter series for numerical boundary coordinates.
The invisible spacer centers each visible bar. Two scatter series connect the left and right edges using numerical X coordinates and category-position numbers as Y coordinates.
In the worksheet, add columns for Spacer, Left boundary, Right boundary, and Position beside your stage and value columns. For each stage, calculate Spacer and Left boundary as (maximum value − stage value) / 2, and Right boundary as (maximum value + stage value) / 2. Number the Position column 1 through the number of stages.
Select the stage, Spacer, and value columns, then choose Insert > Bar Chart > Stacked Bar. Format the Spacer series with no fill so only the centered value bars remain visible.
Right-click the chart and choose Select Data > Add. Add a left boundary series and a right boundary series, then use Change Chart Type > Combo to set each boundary series to XY Scatter with straight lines on the secondary axis.
In Select Data, edit each scatter series: set its X values to the corresponding Left boundary or Right boundary helper column and its Y values to the Position column. Keep the stage names as the bar chart's category labels.
Use Chart Elements > Axes to show the secondary horizontal and vertical axes. In Format Axis, set both horizontal value axes to the same minimum and maximum, such as 0 and the chosen maximum. Set the secondary vertical axis minimum to 0.5, maximum to the number of stages plus 0.5, and major unit to 1.
In Format Axis for the primary category axis, select Categories in reverse order to place the first stage at the top. Reverse the secondary vertical value axis as well so Position 1 aligns with that stage; check that the horizontal axes still share the same plot area before hiding the secondary axis labels.

Explore funnel chart data in WPS Spreadsheet
WPS Office is a free, lightweight alternative for working with Excel spreadsheets in a familiar interface. Open compatible workbooks and continue editing your chart data as you move between applications; check complex chart formatting after opening.

Frequently Asked Questions
Why use an XY scatter series for the funnel boundaries?
An XY scatter series accepts numerical X and Y coordinates. Use the boundary helper columns for X values and stage-position numbers for Y values, while the bar series supplies the category labels.
How do I center the bars in the funnel?
Calculate a spacer as (maximum value − stage value) / 2 for each stage. Insert a stacked bar chart with the spacer and stage value, then format the spacer series with no fill.
Why are the boundary lines misaligned with the bars?
Check Format Axis for both horizontal axes and give them identical bounds. For the secondary vertical axis, use bounds of 0.5 and the number of stages plus 0.5, then match its direction to the primary category order.
How can I put the first funnel stage at the top?
Open Format Axis for the primary category axis and select Categories in reverse order. Reverse the secondary vertical value axis too, so the scatter point at Position 1 remains aligned with the first stage.




