DUMBBELL

{
  "$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
      ]
    ]
  }
}