What is a dumbbell chart?

A dumbbell chart, also called a connected dot 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?

Export as PNG, JPEG, PPTX, or MP4. All formats work in PowerPoint, Google Slides, and reports. Image export is available on all plans.

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 $19/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, 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.

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 as PNG, JPEG, PPTX, or MP4. Drop into slides, reports, or share directly.

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 for Any Format

Export as PNG, JPEG, PPTX, or MP4. Works in PowerPoint, Google Slides, and 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.

Frequently Asked Questions

Create Your Dumbbell Chart Today

Import your data, pick a template, and export in under a minute. Free to start, no credit card required.

Other chart makers

Bar Chart Maker Line Chart Maker Pie Chart Maker Scatter Plot Maker Waterfall Chart Maker Sankey Chart Maker Funnel Chart Maker Gauge Chart Maker Waffle Chart Maker Radar Chart Maker Treemap Maker Heatmap Maker Pareto Chart Maker Mekko Chart Maker