{}OPF
DocsChart Types recordEdit on GitHub

SPARKLINE_6X

Metadata

ID

sparkline-6x

Catalog

chart-types

Source

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

FieldValue
labelSparkline 6x
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, Category 6
groupSparkline
groupSort11
series6
seriesGroups2
slideNumber65
useSecondaryCategoriestrue
workbookRangeSheet1!$A$1:$M$20
complexitynormalized

Source JSON

sparkline-6x.json
{
  "$schema": "https://openpresentation.org/schema/opf-chart-type/v1",
  "id": "sparkline-6x",
  "name": "SPARKLINE_6X",
  "label": "Sparkline 6x",
  "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",
    "Category 6"
  ],
  "group": "Sparkline",
  "groupSort": 11,
  "series": 6,
  "seriesGroups": 2,
  "slideNumber": 65,
  "useSecondaryCategories": true,
  "workbookRange": "Sheet1!$A$1:$M$20",
  "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": "Category 6",
      "role": "series",
      "type": "number",
      "position": "row6_col0"
    },
    {
      "name": "y",
      "role": "helper",
      "type": "number",
      "position": "row7_col0"
    },
    {
      "name": "Normalized 1",
      "role": "helper",
      "type": "number",
      "position": "row8_col0"
    },
    {
      "name": "Normalized 2",
      "role": "helper",
      "type": "number",
      "position": "row9_col0"
    },
    {
      "name": "Normalized 3",
      "role": "helper",
      "type": "number",
      "position": "row10_col0"
    },
    {
      "name": "Normalized 4",
      "role": "helper",
      "type": "number",
      "position": "row11_col0"
    },
    {
      "name": "Normalized 5",
      "role": "helper",
      "type": "number",
      "position": "row12_col0"
    },
    {
      "name": "Normalized 6",
      "role": "helper",
      "type": "number",
      "position": "row13_col0"
    },
    {
      "name": "y-Normalized 1",
      "role": "helper",
      "type": "number",
      "position": "row14_col0"
    },
    {
      "name": "y-Normalized 2",
      "role": "helper",
      "type": "number",
      "position": "row15_col0"
    },
    {
      "name": "y-Normalized 3",
      "role": "helper",
      "type": "number",
      "position": "row16_col0"
    },
    {
      "name": "y-Normalized 4",
      "role": "helper",
      "type": "number",
      "position": "row17_col0"
    },
    {
      "name": "y-Normalized 5",
      "role": "helper",
      "type": "number",
      "position": "row18_col0"
    },
    {
      "name": "y-Normalized 6",
      "role": "helper",
      "type": "number",
      "position": "row19_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",
    "Normalized 6",
    "y-Normalized 6"
  ],
  "sampleData": {
    "headers": [
      "Period",
      "Jan",
      "Feb",
      "Mar",
      "Apr",
      "May",
      "Jun",
      "Jul",
      "Aug",
      "Sep",
      "Oct",
      "Nov",
      "Dec"
    ],
    "rows": [
      [
        "Category 1",
        298857152,
        388866097,
        343702065,
        321373221,
        433801619,
        315484508,
        301751511,
        311629305,
        415708136,
        453758040,
        376922331,
        346208702
      ],
      [
        "Category 2",
        353367769,
        282036035,
        351400930,
        298937207,
        426118117,
        325722321,
        437696815,
        332358553,
        456126030,
        342310549,
        370874773,
        468411591
      ],
      [
        "Category 3",
        448744106,
        407324740,
        440175978,
        454265913,
        389144215,
        437646705,
        352815960,
        352686817,
        473015480,
        426036357,
        455001536,
        378358294
      ],
      [
        "Category 4",
        304384905,
        258205076,
        260693276,
        222851728,
        256622360,
        351930730,
        371226049,
        388657988,
        351120722,
        409791559,
        352554439,
        298515568
      ],
      [
        "Category 5",
        544744941,
        512268106,
        471720280,
        433756410,
        454441276,
        456497460,
        457594937,
        476508584,
        378555903,
        505462962,
        416328588,
        530129839
      ],
      [
        "Category 6",
        307827898,
        286106077,
        282459935,
        217024932,
        219974599,
        246698375,
        342041557,
        353848075,
        385024172,
        303245957,
        285109236,
        327442276
      ]
    ]
  }
}