Chart & Visualization Issues

Create an Advanced Funnel Chart in Excel with a Scatter Series

Chanuka GeekiyanageChanuka Geekiyanage Nov 18, 2026 868 views

Question details

Create an Excel funnel-style combination chart with numerical values on the horizontal axis and category labels on the vertical axis.

Create an Advanced Funnel Chart in Excel with a Scatter Series
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.
Before you start

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.

Solution 1Recommended

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.

1
Create helper columns

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.

2
Insert stacked bars

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.

3
Add the boundary series

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.

4
Set the scatter coordinates

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.

5
Align the axes

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.

6
Match the category order

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.

Combine stacked bars with scatter boundary lines
Check chart-type availability: Combo chart options can vary by Excel version. The scatter series must use the secondary axes for its numerical coordinates to align with the bar chart.
Free Microsoft Office alternative

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.

Organize funnel stages, values, and helper columns in WPS Spreadsheet.Open and edit Microsoft Excel formats, including XLSX and XLS.Use a familiar spreadsheet interface for an easier transition from Excel.Work with a free, lightweight Office alternative.
microsoft office alternative - wps office

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.