{}OPF
DocsChart Types recordEdit on GitHub

SPARKLINE_5X

Metadata

ID

sparkline-5x

Catalog

chart-types

Source

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

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

Source JSON

sparkline-5x.json
{
  "$schema": "https://openpresentation.org/schema/opf-chart-type/v1",
  "id": "sparkline-5x",
  "name": "SPARKLINE_5X",
  "label": "Sparkline 5x",
  "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",
    "Category 5"
  ],
  "group": "Sparkline",
  "groupSort": 11,
  "series": 5,
  "seriesGroups": 2,
  "slideNumber": 64,
  "useSecondaryCategories": true,
  "workbookRange": "Sheet1!$A$1:$M$17",
  "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": "Category 5",
      "role": "series",
      "type": "number",
      "position": "row5_col0"
    },
    {
      "name": "y",
      "role": "helper",
      "type": "number",
      "position": "row6_col0"
    },
    {
      "name": "Normalized 1",
      "role": "helper",
      "type": "number",
      "position": "row7_col0"
    },
    {
      "name": "Normalized 2",
      "role": "helper",
      "type": "number",
      "position": "row8_col0"
    },
    {
      "name": "Normalized 3",
      "role": "helper",
      "type": "number",
      "position": "row9_col0"
    },
    {
      "name": "Normalized 4",
      "role": "helper",
      "type": "number",
      "position": "row10_col0"
    },
    {
      "name": "Normalized 5",
      "role": "helper",
      "type": "number",
      "position": "row11_col0"
    },
    {
      "name": "y-Normalized 1",
      "role": "helper",
      "type": "number",
      "position": "row12_col0"
    },
    {
      "name": "y-Normalized 2",
      "role": "helper",
      "type": "number",
      "position": "row13_col0"
    },
    {
      "name": "y-Normalized 3",
      "role": "helper",
      "type": "number",
      "position": "row14_col0"
    },
    {
      "name": "y-Normalized 4",
      "role": "helper",
      "type": "number",
      "position": "row15_col0"
    },
    {
      "name": "y-Normalized 5",
      "role": "helper",
      "type": "number",
      "position": "row16_col0"
    }
  ],
  "helperColumns": [
    "y",
    "Normalized 1",
    "y-Normalized 1",
    "Normalized 2",
    "y-Normalized 2",
    "Normalized 3",
    "y-Normalized 3",
    "Normalized 4",
    "y-Normalized 4",
    "Normalized 5",
    "y-Normalized 5"
  ],
  "sampleData": {
    "headers": [
      "Period",
      "Jan",
      "Feb",
      "Mar",
      "Apr",
      "May",
      "Jun",
      "Jul",
      "Aug",
      "Sep",
      "Oct",
      "Nov",
      "Dec"
    ],
    "rows": [
      [
        "Category 1",
        394192109,
        298791835,
        291735757,
        387547136,
        285549617,
        402554736,
        416691818,
        370896114,
        338524862,
        436475508,
        450689044,
        445346510
      ],
      [
        "Category 2",
        184694692,
        187026655,
        243832637,
        215693071,
        282879921,
        223502304,
        262672508,
        340961425,
        244063499,
        269927808,
        172394131,
        209079951
      ],
      [
        "Category 3",
        407310440,
        361244398,
        363019404,
        348933300,
        412854772,
        455414485,
        396335652,
        361436061,
        448877666,
        381689431,
        463288538,
        442714573
      ],
      [
        "Category 4",
        397995978,
        514303755,
        385564250,
        542703984,
        525924909,
        434505855,
        538801568,
        531604872,
        472201924,
        575190383,
        462741434,
        482489022
      ],
      [
        "Category 5",
        191572637,
        286844139,
        254728898,
        315419922,
        294583213,
        302197618,
        204085411,
        345307584,
        283404222,
        355759261,
        340962092,
        354360356
      ]
    ]
  }
}