{}OPF
DocsChart Types recordEdit on GitHub

LINE_WITH_HIGH_LOW_AND_MARKERS

Metadata

ID

line-with-high-low-and-markers

Catalog

chart-types

Source

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

FieldValue
labelLine with High/Low and Markers
mappings{ "openxml": { "composition": "mixed", "series": [ { "element": "lineChart", "marker": true, "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
slideNumber8
useSecondaryCategoriesfalse
workbookRangeSheet1!$A$1:$M$5
complexitycalculated

Source JSON

line-with-high-low-and-markers.json
{
  "$schema": "https://openpresentation.org/schema/opf-chart-type/v1",
  "id": "line-with-high-low-and-markers",
  "name": "LINE_WITH_HIGH_LOW_AND_MARKERS",
  "label": "Line with High/Low and Markers",
  "mappings": {
    "openxml": {
      "composition": "mixed",
      "series": [
        {
          "element": "lineChart",
          "marker": true,
          "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": 8,
  "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",
        53,
        36,
        55,
        75,
        80,
        20,
        63,
        66,
        27,
        63,
        76,
        54
      ],
      [
        "High",
        66,
        51,
        63,
        89,
        98,
        30,
        82,
        71,
        40,
        73,
        84,
        68
      ],
      [
        "Low",
        38,
        23,
        41,
        67,
        73,
        10,
        56,
        53,
        14,
        58,
        62,
        44
      ]
    ]
  }
}