DOT_PLOT_6X
Metadata
ID
dot-plot-6x
Catalog
chart-types
Source
spec/catalogs/chart-types/dot-plot-6x.json
| Field | Value |
|---|---|
| label | Dot Plot 6x |
| mappings | { "openxml": { "element": "scatterChart", "scatterStyle": "marker", "composition": "single", "notes": "Dot plots render as scatter markers in Open XML." } } |
| categories | 8 |
| columns | 2023, 2024, 2025, 2026, 2027, 2028 |
| group | XY (Scatter) |
| groupSort | 6 |
| series | 6 |
| seriesGroups | 2 |
| slideNumber | 39 |
| useSecondaryCategories | false |
| workbookRange | Sheet1!$A$1:$I$12 |
| complexity | calculated |
Source JSON
{
"$schema": "https://openpresentation.org/schema/opf-chart-type/v1",
"id": "dot-plot-6x",
"name": "DOT_PLOT_6X",
"label": "Dot Plot 6x",
"mappings": {
"openxml": {
"element": "scatterChart",
"scatterStyle": "marker",
"composition": "single",
"notes": "Dot plots render as scatter markers in Open XML."
}
},
"categories": 8,
"columns": [
"2023",
"2024",
"2025",
"2026",
"2027",
"2028"
],
"group": "XY (Scatter)",
"groupSort": 6,
"series": 6,
"seriesGroups": 2,
"slideNumber": 39,
"useSecondaryCategories": false,
"workbookRange": "Sheet1!$A$1:$I$12",
"complexity": "calculated",
"dataColumns": [
{
"name": "2023",
"role": "categoryLabel",
"type": "string",
"position": "row0_col0"
},
{
"name": "2024",
"role": "series",
"type": "number",
"position": "row1_col0"
},
{
"name": "2025",
"role": "series",
"type": "number",
"position": "row2_col0"
},
{
"name": "2026",
"role": "series",
"type": "number",
"position": "row3_col0"
},
{
"name": "2027",
"role": "series",
"type": "number",
"position": "row4_col0"
},
{
"name": "2028",
"role": "series",
"type": "number",
"position": "row5_col0"
},
{
"name": "Spacing 1",
"role": "helper",
"type": "number",
"position": "row6_col0"
},
{
"name": "Spacing 2",
"role": "helper",
"type": "number",
"position": "row7_col0"
},
{
"name": "Spacing 3",
"role": "helper",
"type": "number",
"position": "row8_col0"
},
{
"name": "Spacing 4",
"role": "helper",
"type": "number",
"position": "row9_col0"
},
{
"name": "Spacing 5",
"role": "helper",
"type": "number",
"position": "row10_col0"
},
{
"name": "Spacing 6",
"role": "helper",
"type": "number",
"position": "row11_col0"
}
],
"helperColumns": [
"Spacing 1",
"Spacing 2",
"Spacing 3",
"Spacing 4",
"Spacing 5",
"Spacing 6"
],
"sampleData": {
"headers": [
"Series",
"Item 1",
"Item 2",
"Item 3",
"Item 4",
"Item 5",
"Item 6",
"Item 7",
"Item 8"
],
"rows": [
[
"2020",
332360,
524045,
355123,
421080,
486945,
596249,
680358,
656711
],
[
"2021",
460455,
546173,
677124,
446859,
468900,
575786,
384076,
421517
],
[
"2022",
363615,
341736,
226516,
301939,
430876,
225362,
661894,
294143
],
[
"2023",
300845,
326895,
607719,
389930,
650121,
396745,
205409,
303547
],
[
"2024",
410636,
338533,
478411,
288158,
416950,
114835,
660081,
232731
],
[
"2025",
387636,
147726,
157174,
680238,
406327,
232413,
614723,
207570
]
]
}
}