{}OPF
DocsChart Types recordEdit on GitHub

LINE_WITH_HIGH_LOW

Metadata

ID

line-with-high-low

Catalog

chart-types

Source

spec/catalogs/chart-types/line-with-high-low.json

FieldValue
labelLine with High/Low
mappings{ "openxml": { "composition": "mixed", "series": [ { "element": "lineChart", "marker": false, "composition": "single" }, { "element": "barChart", "barDir": "col", "grouping": "clustered", "composition": "single" } ], "notes": "High/low variants combine the main line with auxiliary range series." } }
categories12
columnsSeries 1, Value, High, Low
groupLine
groupSort2
series3
seriesGroups2
slideNumber7
useSecondaryCategoriesfalse
workbookRangeSheet1!$A$1:$M$5
complexitycalculated

Source JSON

line-with-high-low.json
{
  "$schema": "https://openpresentation.org/schema/opf-chart-type/v1",
  "id": "line-with-high-low",
  "name": "LINE_WITH_HIGH_LOW",
  "label": "Line with High/Low",
  "mappings": {
    "openxml": {
      "composition": "mixed",
      "series": [
        {
          "element": "lineChart",
          "marker": false,
          "composition": "single"
        },
        {
          "element": "barChart",
          "barDir": "col",
          "grouping": "clustered",
          "composition": "single"
        }
      ],
      "notes": "High/low variants combine the main line with auxiliary range series."
    }
  },
  "categories": 12,
  "columns": [
    "Series 1",
    "Value",
    "High",
    "Low"
  ],
  "group": "Line",
  "groupSort": 2,
  "series": 3,
  "seriesGroups": 2,
  "slideNumber": 7,
  "useSecondaryCategories": false,
  "workbookRange": "Sheet1!$A$1:$M$5",
  "complexity": "calculated",
  "dataColumns": [
    {
      "name": "Series 1",
      "role": "categoryLabel",
      "type": "string",
      "position": "row0_col0"
    },
    {
      "name": "Value",
      "role": "series",
      "type": "number",
      "position": "row1_col0"
    },
    {
      "name": "High",
      "role": "series",
      "type": "number",
      "position": "row2_col0"
    },
    {
      "name": "Low",
      "role": "series",
      "type": "number",
      "position": "row3_col0"
    },
    {
      "name": "Band",
      "role": "helper",
      "type": "number",
      "position": "row4_col0"
    }
  ],
  "helperColumns": [
    "Band"
  ],
  "sampleData": {
    "headers": [
      "Series 1",
      "Q1 2024",
      "Q2 2024",
      "Q3 2024",
      "Q4 2024",
      "Q1 2025",
      "Q2 2025",
      "Q3 2025",
      "Q4 2025",
      "Q1 2026",
      "Q2 2026",
      "Q3 2026",
      "Q4 2026"
    ],
    "rows": [
      [
        "Value",
        76,
        65,
        40,
        33,
        61,
        51,
        45,
        76,
        78,
        61,
        49,
        29
      ],
      [
        "High",
        89,
        74,
        52,
        46,
        79,
        68,
        61,
        88,
        87,
        81,
        56,
        35
      ],
      [
        "Low",
        70,
        58,
        25,
        26,
        46,
        40,
        31,
        70,
        67,
        50,
        35,
        17
      ]
    ]
  }
}