{}OPF
DocsChart Types recordEdit on GitHub

DOT_PLOT_6X

Metadata

ID

dot-plot-6x

Catalog

chart-types

Source

spec/catalogs/chart-types/dot-plot-6x.json

FieldValue
labelDot Plot 6x
mappings{ "openxml": { "element": "scatterChart", "scatterStyle": "marker", "composition": "single", "notes": "Dot plots render as scatter markers in Open XML." } }
categories8
columns2023, 2024, 2025, 2026, 2027, 2028
groupXY (Scatter)
groupSort6
series6
seriesGroups2
slideNumber39
useSecondaryCategoriesfalse
workbookRangeSheet1!$A$1:$I$12
complexitycalculated

Source JSON

dot-plot-6x.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
      ]
    ]
  }
}