{
"$schema": "https://openpresentation.org/schema/opf-chart-type/v1",
"id": "dumbbell",
"name": "DUMBBELL",
"label": "Dumbbell",
"mappings": {
"openxml": {
"composition": "mixed",
"series": [
{
"element": "scatterChart",
"scatterStyle": "marker",
"composition": "single"
},
{
"element": "lineChart",
"composition": "single"
}
],
"notes": "Dumbbell charts combine point markers with connector lines."
}
},
"categories": 6,
"columns": [
"Category",
"Value 1",
"Value 2",
"Y-axis",
"Error bar length 1",
"Error bar length 2"
],
"group": "Other",
"groupSort": 13,
"series": 5,
"seriesGroups": 2,
"slideNumber": 76,
"useSecondaryCategories": true,
"workbookRange": "Sheet1!$A$1:$G$6",
"complexity": "calculated",
"dataColumns": [
{
"name": "Category",
"role": "categoryLabel",
"type": "string",
"position": "row0_col0"
},
{
"name": "Value 1",
"role": "series",
"type": "number",
"position": "row1_col0"
},
{
"name": "Value 2",
"role": "series",
"type": "number",
"position": "row2_col0"
},
{
"name": "Y-axis",
"role": "series",
"type": "number",
"position": "row3_col0"
},
{
"name": "Error bar length 1",
"role": "series",
"type": "number",
"position": "row4_col0"
},
{
"name": "Error bar length 2",
"role": "series",
"type": "number",
"position": "row5_col0"
}
],
"helperColumns": [
"Start",
"End",
"Connector Low",
"Connector High"
],
"sampleData": {
"headers": [
"Category",
"Q1 2024",
"Q2 2024",
"Q3 2024",
"Q4 2024",
"Q1 2025",
"Q2 2025"
],
"rows": [
[
"Value 1",
59111,
70015,
48673,
79308,
79056,
81367
],
[
"Value 2",
59420,
45335,
64996,
45674,
50281,
82993
]
]
}
}