DOT_PLOT_5X
Metadata
ID
dot-plot-5x
Catalog
chart-types
Source
spec/catalogs/chart-types/dot-plot-5x.json
| Field | Value |
|---|---|
| label | Dot Plot 5x |
| 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 |
| group | XY (Scatter) |
| groupSort | 6 |
| series | 5 |
| seriesGroups | 2 |
| slideNumber | 38 |
| useSecondaryCategories | false |
| workbookRange | Sheet1!$A$1:$I$10 |
| complexity | calculated |
Source JSON
{
"$schema": "https://openpresentation.org/schema/opf-chart-type/v1",
"id": "dot-plot-5x",
"name": "DOT_PLOT_5X",
"label": "Dot Plot 5x",
"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"
],
"group": "XY (Scatter)",
"groupSort": 6,
"series": 5,
"seriesGroups": 2,
"slideNumber": 38,
"useSecondaryCategories": false,
"workbookRange": "Sheet1!$A$1:$I$10",
"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": "Spacing 1",
"role": "helper",
"type": "number",
"position": "row5_col0"
},
{
"name": "Spacing 2",
"role": "helper",
"type": "number",
"position": "row6_col0"
},
{
"name": "Spacing 3",
"role": "helper",
"type": "number",
"position": "row7_col0"
},
{
"name": "Spacing 4",
"role": "helper",
"type": "number",
"position": "row8_col0"
},
{
"name": "Spacing 5",
"role": "helper",
"type": "number",
"position": "row9_col0"
}
],
"helperColumns": [
"Spacing 1",
"Spacing 2",
"Spacing 3",
"Spacing 4",
"Spacing 5"
],
"sampleData": {
"headers": [
"Series",
"Item 1",
"Item 2",
"Item 3",
"Item 4",
"Item 5",
"Item 6",
"Item 7",
"Item 8"
],
"rows": [
[
"2020",
587455,
556732,
381433,
437960,
357420,
190872,
392477,
572700
],
[
"2021",
355709,
587282,
697530,
497399,
452737,
130094,
618317,
440802
],
[
"2022",
290672,
611233,
322423,
472060,
370902,
456871,
393243,
389688
],
[
"2023",
682789,
110644,
641722,
300337,
189771,
353080,
526170,
612311
],
[
"2024",
682144,
351997,
599219,
614663,
569945,
118080,
197573,
408528
]
]
}
}