How to Make a Dumbbell Chart in Excel
Build a dumbbell chart in Excel with one scatter plot and one error bar — the simplest reliable method. Before/after comparisons without add-ins.
How to Make a Dumbbell Chart in Excel
When you need to show before and after across a set of categories — conversion rates by region last year versus this year, salaries by role before and after a review, satisfaction scores pre- and post-launch — the dumbbell chart is the right tool, and a clustered bar chart is the wrong one. Two dots connected by a line show the change directly: the gap between dots is the story, read as pure distance. Paired bars force your reader to compare the tops of adjacent rectangles, which humans are measurably worse at.
Excel has no built-in dumbbell type, and most tutorials compensate with fragile constructions: multiple scatter series, drawn lines, or paid add-ins. There’s a simpler build that uses one scatter chart and one error bar, and it’s the method this guide teaches. Fifteen minutes, no add-ins, fully data-linked. A working file with the finished chart is linked at the end.
Not sure a dumbbell fits your data? Two time points across categories is the sweet spot — see our chart decision guide for the boundaries. (Three or more time points wants a line chart; one time point wants a bar.)
Step 1: Set Up the Data
Lay out four columns and one helper. Convert the range to an Excel Table (Ctrl+T) so the chart tracks new rows:
| Region | 2025 | 2026 | Position | Delta |
|---|---|---|---|---|
| Northeast | 3.1 | 4.6 | 6 | =C2-B2 |
| Southeast | 2.8 | 3.9 | 5 | =C3-B3 |
| Midwest | 4.0 | 4.2 | 4 | =C4-B4 |
| Southwest | 2.2 | 3.8 | 3 | =C5-B5 |
| Mountain | 3.5 | 3.1 | 2 | =C6-B6 |
| Pacific | 4.4 | 5.5 | 1 | =C7-B7 |
- Position is the vertical slot for each category, numbered from the bottom up (largest number = top row of the chart).
- Delta is the after-minus-before difference — this single column will draw every connector line.
One deliberate choice here: order the rows by something meaningful. Sorting by the size of the change (Delta) usually tells the strongest story; alphabetical order tells none.
Step 2: Plot the “Before” Series
- Select nothing, then Insert > Charts > Scatter (plain markers, no lines).
- Right-click the empty chart > Select Data > Add.
- Series name: cell B1 (“2025”). Series X values: the 2025 column. Series Y values: the Position column.
You’ll get one column of dots — each region’s before-value at its assigned height.
Step 3: Add the “After” Series
Repeat: Add a second series named “2026,” X values from the 2026 column, Y values from the same Position column. Now every region has two dots on one horizontal line. Format the two series with distinct marker colors — muted for before, saturated for after — and bump marker size to 8–10 so the dots read as endpoints, not specks.
Step 4: Connect the Dots with One Error Bar
This is the move that replaces every hack you’ll find elsewhere:
- Click once on the 2025 (before) series to select it.
- Chart Elements (the + button) > check Error Bars, then open More Options.
- Delete the vertical error bars (click one, press Delete).
- Select the horizontal error bars > Format Error Bars: Direction Plus, End Style No Cap, Error Amount Custom > Specify Value, and set the Positive Error Value to the Delta column.
Each before-dot now extends a line exactly as far as its after-dot — including backwards for categories that declined, since a negative delta draws in the minus direction automatically. Format the error bars gray, 1.5–2pt. The dumbbells are done, and because the connectors are driven by the Delta formulas, they move when the data does.
Step 5: Clean Up the Chart
- Delete the vertical axis — the position numbers are scaffolding, not information.
- Label the categories with data labels on one series: select the before series > Data Labels > More Options > check Value From Cells > point at the Region column, position Left, and pad the X-axis minimum so labels don’t clip.
- Fix the X-axis min/max to sensible round numbers, drop gridlines to a faint gray, and delete the legend in favor of two small colored labels (“2025” / “2026”) placed directly above the top dumbbell.
- Title with the finding: “Every region improved except Mountain” beats “Conversion rate by region.”
If dots or connectors don’t move when you edit the table, the chart has lost its references — our guide to Excel charts that won’t update covers the fixes.
Faster Route: Ask Copilot for the Skeleton
If you’re on Microsoft 365 with Copilot, prompting it to “create a scatter chart with 2025 and 2026 as X values and Position as Y values” gets you through Steps 2–3 in one shot; the error-bar connector in Step 4 you’ll still do by hand, since it’s a formatting operation Copilot handles unreliably. Prompt patterns that work are in our complete guide to Copilot charts in Excel.
Download the Working File
The workbook dumbbell-chart-before-after.xlsx contains the sample regional data, the finished chart, and an instructions tab. Swap in your own categories and values; positions and deltas recalculate, and the chart follows.
FAQ
Dumbbell chart vs. slope chart — which one? Same job, different geometry. Slope charts (two vertical axes, connecting lines) excel when crossovers and rank changes are the story; dumbbells scale better past ~8 categories and read more naturally left-to-right. With many categories and a “how much did each change” question, choose the dumbbell.
Can I show three time points? You can add a third series, but the chart degrades fast — connectors become ambiguous. Three or more periods is line-chart territory.
Why are my connector lines missing for some rows? Almost always a Delta reference problem: the custom error value range doesn’t match the number of data rows. Re-specify the Positive Error Value against the full Delta column.
Does this work in Google Sheets? The scatter setup works; Sheets’ error-bar options are more limited, so connectors typically need a workaround. A native Sheets version behaves differently enough to deserve its own walkthrough.