Other Chart Preset
Dumbbell
Dumbbell is an OPF other chart preset with canonical workbook metadata, sample data, and engine chart type mapping.
Use Case
Use a specialized visual when standard bars, lines, and areas would obscure the pattern.
Data Requirements
5 series, 6 categories, calculated helper workbook, 2 series groups, secondary categories
Group
Specialty chart presets for variance, flow, distribution, or comparison cases.
Series
5 series across 6 categories
Workbook Range
Sheet1!$A$1:$G$6
Source Slide
Slide 76 in the OPF chart gallery deck
When to Use
Use when the chart type directly matches the analytical question and the audience can read it quickly.
When to Avoid
Avoid specialty visuals when a simpler chart would make the same point with less explanation.
Best Practices
Explain the encoding in the title or subtitle
Keep annotations close to the data
Prefer clarity over novelty
Recommended Companions
OPF Config
charts:dumbbell{
"$schema": "https://pptx.dev/schema/opf/v1",
"version": "1.0",
"meta": {
"title": "PPTX.gallery — charts/dumbbell"
},
"design": {},
"slides": [
{
"id": "gallery-preview-1",
"layout": "chart",
"elements": [
{
"id": "gallery-chart-1",
"type": "chart",
"chartPreset": "dumbbell",
"data": {
"labels": [
"Q1 2024",
"Q2 2024",
"Q3 2024",
"Q4 2024",
"Q1 2025",
"Q2 2025"
],
"datasets": [
{
"label": "Value 1",
"values": [
59111,
70015,
48673,
79308,
79056,
81367
]
},
{
"label": "Value 2",
"values": [
59420,
45335,
64996,
45674,
50281,
82993
]
}
]
}
}
]
}
]
}Preview this config live at pptx.dev/playground.