{}OPF
DocsChart Types recordEdit on GitHub

SPARKLINE_4X

Metadata

ID

sparkline-4x

Catalog

chart-types

Source

spec/catalogs/chart-types/sparkline-4x.json

FieldValue
labelSparkline 4x
mappings{ "openxml": { "element": "lineChart", "composition": "single", "notes": "Presentation sparklines render as compact line charts." } }
categories12
columnsPeriod, Category 1, Category 2, Category 3, Category 4
groupSparkline
groupSort11
series4
seriesGroups2
slideNumber63
useSecondaryCategoriestrue
workbookRangeSheet1!$A$1:$M$14
complexitynormalized

Source JSON

sparkline-4x.json
{
  "$schema": "https://openpresentation.org/schema/opf-chart-type/v1",
  "id": "sparkline-4x",
  "name": "SPARKLINE_4X",
  "label": "Sparkline 4x",
  "mappings": {
    "openxml": {
      "element": "lineChart",
      "composition": "single",
      "notes": "Presentation sparklines render as compact line charts."
    }
  },
  "categories": 12,
  "columns": [
    "Period",
    "Category 1",
    "Category 2",
    "Category 3",
    "Category 4"
  ],
  "group": "Sparkline",
  "groupSort": 11,
  "series": 4,
  "seriesGroups": 2,
  "slideNumber": 63,
  "useSecondaryCategories": true,
  "workbookRange": "Sheet1!$A$1:$M$14",
  "complexity": "normalized",
  "dataColumns": [
    {
      "name": "Period",
      "role": "categoryLabel",
      "type": "string",
      "position": "row0_col0"
    },
    {
      "name": "Category 1",
      "role": "series",
      "type": "number",
      "position": "row1_col0"
    },
    {
      "name": "Category 2",
      "role": "series",
      "type": "number",
      "position": "row2_col0"
    },
    {
      "name": "Category 3",
      "role": "series",
      "type": "number",
      "position": "row3_col0"
    },
    {
      "name": "Category 4",
      "role": "series",
      "type": "number",
      "position": "row4_col0"
    },
    {
      "name": "y",
      "role": "helper",
      "type": "number",
      "position": "row5_col0"
    },
    {
      "name": "Normalized 1",
      "role": "helper",
      "type": "number",
      "position": "row6_col0"
    },
    {
      "name": "Normalized 2",
      "role": "helper",
      "type": "number",
      "position": "row7_col0"
    },
    {
      "name": "Normalized 3",
      "role": "helper",
      "type": "number",
      "position": "row8_col0"
    },
    {
      "name": "Normalized 4",
      "role": "helper",
      "type": "number",
      "position": "row9_col0"
    },
    {
      "name": "y-Normalized 1",
      "role": "helper",
      "type": "number",
      "position": "row10_col0"
    },
    {
      "name": "y-Normalized 2",
      "role": "helper",
      "type": "number",
      "position": "row11_col0"
    },
    {
      "name": "y-Normalized 3",
      "role": "helper",
      "type": "number",
      "position": "row12_col0"
    },
    {
      "name": "y-Normalized 4",
      "role": "helper",
      "type": "number",
      "position": "row13_col0"
    }
  ],
  "helperColumns": [
    "y",
    "Normalized 1",
    "y-Normalized 1",
    "Normalized 2",
    "y-Normalized 2",
    "Normalized 3",
    "y-Normalized 3",
    "Normalized 4",
    "y-Normalized 4"
  ],
  "sampleData": {
    "headers": [
      "Period",
      "Jan",
      "Feb",
      "Mar",
      "Apr",
      "May",
      "Jun",
      "Jul",
      "Aug",
      "Sep",
      "Oct",
      "Nov",
      "Dec"
    ],
    "rows": [
      [
        "Category 1",
        351100762,
        352741011,
        379496599,
        387966832,
        282312384,
        311282670,
        452151921,
        379790805,
        433333748,
        384493624,
        422399875,
        417323155
      ],
      [
        "Category 2",
        112746904,
        221229196,
        183077367,
        149559096,
        179550365,
        213793767,
        147945453,
        227710269,
        229965985,
        174297265,
        161163531,
        183746340
      ],
      [
        "Category 3",
        237548014,
        134668693,
        198704600,
        207612874,
        201403806,
        147410128,
        125604425,
        201890459,
        198475165,
        249611663,
        269899922,
        220220298
      ],
      [
        "Category 4",
        151483519,
        143799732,
        124809837,
        255107244,
        238648426,
        290700676,
        206450687,
        161961806,
        284636227,
        166280805,
        280244757,
        229378769
      ]
    ]
  }
}