How to make a dumbbell chart
Choose one category column and exactly two numeric columns. Name the columns in the order you want readers to compare them: for example, Country, 2000, 2023. The first value uses a circle and the second a diamond, so color is not the only identifier. Up to 30 categories are accepted.
- Upload CSV, TSV, TXT or Excel, or paste cells from your spreadsheet. Select the sheet, row range, headers and number convention.
- Choose the labels and numeric series. Inspect the complete selection before applying it; errors preserve the current chart.
- Write a descriptive headline, unit, source credit and date. Attach an optional note to a specific row and series.
- Check the preview and source table, then choose the publication size and download format. Keep the editable project if you want to revise it later.
Read the endpoints, then the gap
The horizontal positions encode the original values. The connector spans the interval between them; it is not a third measurement. Subtract the first value from the second to describe signed change. A value moving left is a decrease, even if another category moves right. Nothing is sorted, averaged or combined automatically.
Choose comparable units
Both columns must measure the same quantity on the same scale. Counts and percentages cannot share a meaningful comparison axis simply because both are numbers. For percentages, subtracting endpoints gives percentage points, not percent change. Relative percent change requires division by the starting value and is undefined when that value is zero.
When a line chart says more
Two endpoints can conceal a peak, a reversal or a disruption between them. If that intermediate path changes the story, include the full annual series in a line chart or small multiples. A before-and-after difference alone does not demonstrate that an intervention caused the change.
Keep the comparison readable
Zero is optional because position, rather than bar length, carries the value. The numeric axis remains visible. Turn on direct labels for a small table, and check close or identical endpoints at the size your article will display. For crowded charts, reduce the selected categories explicitly or increase the canvas size; this tool never removes categories to make them fit.
Choose a finished design
Explore four editable dumbbell chart examples, with source data, interpretation and downloads. Replace the data while retaining the design.
Try a sourced example
Start with the World Bank life expectancy comparison. It includes source values, the selected years and countries, calculations, download files and the limitations of each view.
Questions before publishing
Is this the same as a dot plot?
It is a paired comparison plot. Our distribution dot plot stacks individual observations at their numeric values; it answers a different question. A dumbbell links two measurements belonging to the same category.
Can I upload a wide spreadsheet?
Yes. Upload CSV, TSV, TXT or Excel and select the category plus the two columns you need. Choose the sheet, row range and number convention before applying. Extra columns are not plotted unless selected.
Can I show a decrease or a negative number?
Yes. Negative values are supported. Endpoint order is retained, and the numeric axis includes both extremes. The connector has no implied direction beyond the two named series.
What can I download?
Vector SVG, fixed-size PNG, a PDF containing a raster chart, source CSV, a versioned editable JSON project, and self-contained static HTML with a caption and data table. HTML has no chart scripts or tracking and can be hosted by your publication. See the publishing and accessibility guide. Spreadsheet files are limited to 8 MB, 2,000 preview rows and 100 columns; the smaller chart-specific limits above apply to the selected data.
Built by SupaMakers. Inspect and reuse the source code. Compare the editorial chart types. Reviewed September 9, 2026.