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
| Field | Value |
|---|---|
| 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 |
Source 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
]
]
}
}