What is a dumbbell chart?

A dumbbell chart, also called a connected dot plot or range plot, shows two values per category connected by a horizontal line. The dots mark the two data points and the line between them makes the gap immediately visible. It is ideal for comparing before vs after, plan vs actual, or two time periods across multiple categories.

What data does a dumbbell chart show?

Dumbbell charts show two data points per category, connected by a line. The gap between the dots represents the difference. For example, revenue last year vs this year, or target vs actual performance for each team.

Can I import data from Excel or Google Sheets?

Yes. Import from Excel or Google Sheets directly into the editor. First column is the category name. The second and third columns are the two values to compare. AECharts maps each row to a dumbbell automatically.

What export formats are available?

Every chart exports ready to use in PowerPoint or Google Slides, or as an image for reports.

Can I customize the colors?

Yes. Each endpoint dot gets its own color, fully customizable. The connecting line color is also adjustable. You can match your brand palette exactly or use a built-in color scheme.

What is a dumbbell chart used for?

Dumbbell charts are best for comparing exactly two values across multiple categories: before vs after, this year vs last year, target vs actual. They show both the individual values and the gap between them more clearly than a grouped bar chart, without the visual clutter of multiple bars per category.

What is the difference between a dumbbell chart and a grouped bar chart?

Both compare two values per category, but a dumbbell chart uses dots connected by a line rather than two bars side by side. The connecting line makes the gap between the two values immediately obvious. Dumbbell charts are cleaner than grouped bars when the focus is on the difference rather than the absolute values.

How many categories should a dumbbell chart have?

Five to fifteen categories is the sweet spot. Fewer than five is fine but may not need a chart. More than twenty categories makes the chart hard to scan. Consider filtering to the most significant differences or using a table.

Do I need design skills?

No. Templates are professionally designed. Import your data and adjust colors if needed. Most users create their first dumbbell chart in under a minute.

Is there a free plan?

Yes. AECharts is free to start. Pro plan starts at $12/month billed annually and removes the watermark. No credit card required to start.

Dumbbell Chart

A dumbbell chart, also called a dumbbell plot, connected dot plot, range plot, or barbell chart, shows two values per category connected by a horizontal line. The dots mark the two endpoints and the line makes the gap between them immediately visible. Use AECharts to build dumbbell charts from your Excel or Google Sheets data for before/after comparisons, target vs actual analysis, and year-over-year performance.

Dumbbell Chart Maker Features

Easy Data Import: Import from Excel or Google Sheets. Three columns: category, first value, second value. AECharts builds the connected dot chart automatically.
Custom Colors per Endpoint: Each endpoint dot gets its own color. Use contrasting colors to make the gap immediately visible.
Export Straight to PowerPoint: Export and drop it directly into PowerPoint, Google Slides, or reports.
Labels & Values: Show exact values next to each dot. Control number formatting, prefix, suffix, and label position from the editor.
Real-time Preview: See every change instantly. What you see in the editor is exactly what exports.
No Design Skills Needed: Templates are professionally designed. Import your data, adjust colors, and export. Most users are done in under a minute.

When to Use a Dumbbell Chart

Dumbbell charts work best when you have exactly two values per category and the gap between them is the story.

Before vs After: Show the impact of a change, revenue before and after a product launch, churn before and after a retention campaign, NPS before and after a redesign.
Target vs Actual: Quota vs closed deals by rep. Budget vs actual spend by department. OKR target vs current result by team. The gap tells the story.
Year-over-Year Comparison: Revenue, headcount, or key metrics this year vs last year across multiple segments, regions, or product lines in a single clean chart.
Plan vs Result: Forecast vs actual at the end of the quarter. Show where you outperformed and where you missed across multiple lines of business.
Competitive Benchmarking: Your metric vs industry average across categories: NPS, gross margin, CAC, churn. Each category gets a dot for you and a dot for the benchmark.
Survey Comparison: Employee satisfaction scores this year vs last year by department. Or pre-survey vs post-survey results after an intervention.

Dumbbell Chart vs Grouped Bar Chart

Both compare two values per category, but they emphasize different things.

Dumbbell Chart

Best for: Highlighting the gap between two values: before/after, plan/actual, this year/last year.
Strength: The connecting line makes the difference immediately visible. Cleaner and less cluttered than two bars per category.
Use when: The change or gap is the headline, not the absolute values.

Grouped Bar Chart

Best for: Comparing absolute values side by side when both values matter equally.
Strength: Bar height is easy to compare and familiar to most audiences.
Use when: You want readers to compare both values individually, not just the gap.

AECharts supports both. Switch between dumbbell and grouped bar to find the right format for your data.

How to Create a Dumbbell Chart

Select the dumbbell chart type. Open the AECharts editor and select Dumbbell Chart from the chart type picker. If you want a different visual style, browse the template explorer on the right panel and click any template to apply it instantly.
Enter your data. Click "Edit Data" in the top-right corner to open the spreadsheet. The first column holds your category names, each row becomes one dumbbell. The second column is the first value (for example, last year or the target) and the third column is the second value (for example, this year or the result). Import directly from Excel or Google Sheets, or upload a CSV or Excel file.
Adjust styling. Use the top menu bar to customize the look. Set a color for each endpoint dot independently so the two values are visually distinct. Adjust the connecting line color and width, and the dot radius. Show value labels next to each dot and control the number format, prefix, and suffix. The usual label, tick, axis, and grid options including font, size, and color are all available. Every change previews instantly.
Export. When you're ready, export ready for PowerPoint or Google Slides. Drop into slides, reports, or share directly.

Frequently Asked Questions

Other chart makers

100% Stacked Bar Chart Maker 100% Stacked Column Chart Maker Area Chart Maker Bar Chart Maker Bar Mekko Chart Maker Box Whisker Plot Maker Bubble Chart Maker Bullet Chart Maker Bump Chart Maker Candlestick Chart Maker Chord Diagram Maker Circle Packing Chart Maker Concentric Circle Chart Maker Cycle Diagram Maker Fishbone Diagram Maker Funnel Chart Maker Gantt Chart Maker Gauge Chart Maker Grouped Bar Chart Maker Half Donut Chart Maker Heatmap Maker Histogram Maker Horizontal Bar Chart Maker Line Chart Maker Mekko Chart Maker (Marimekko)Nightingale Rose Chart Maker Pareto Chart Maker Pictograph Maker Pie Chart Maker Population Pyramid Maker Pyramid Chart Maker Radar Chart Maker Radial Bar Chart Maker Ridgeline Chart Maker Sankey Chart Maker Scatter Plot Maker Segmented Bar Chart Maker Semicircle Pie Chart Maker Slope Chart Maker Stacked Area Chart Maker Stacked Column Chart Maker Stacked Waterfall Chart Maker Step Chart Maker Stream Graph Maker Sunburst Chart Maker Tornado Chart Maker Treemap Chart Maker Trellis Chart Maker Venn Diagram Maker Waffle Chart Maker Waterfall Chart Maker