{}OPF
DocsChart Types recordEdit on GitHub

SPARKLINE_2X

Metadata

ID

sparkline-2x

Catalog

chart-types

Source

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

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

Source JSON

sparkline-2x.json
{
  "$schema": "https://openpresentation.org/schema/opf-chart-type/v1",
  "id": "sparkline-2x",
  "name": "SPARKLINE_2X",
  "label": "Sparkline 2x",
  "mappings": {
    "openxml": {
      "element": "lineChart",
      "composition": "single",
      "notes": "Presentation sparklines render as compact line charts."
    }
  },
  "categories": 12,
  "columns": [
    "Period",
    "Category 1",
    "Category 2"
  ],
  "group": "Sparkline",
  "groupSort": 11,
  "series": 2,
  "seriesGroups": 2,
  "slideNumber": 61,
  "useSecondaryCategories": true,
  "workbookRange": "Sheet1!$A$1:$M$8",
  "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": "y",
      "role": "helper",
      "type": "number",
      "position": "row3_col0"
    },
    {
      "name": "Normalized 1",
      "role": "helper",
      "type": "number",
      "position": "row4_col0"
    },
    {
      "name": "Normalized 2",
      "role": "helper",
      "type": "number",
      "position": "row5_col0"
    },
    {
      "name": "y-Normalized 1",
      "role": "helper",
      "type": "number",
      "position": "row6_col0"
    },
    {
      "name": "y-Normalized 2",
      "role": "helper",
      "type": "number",
      "position": "row7_col0"
    }
  ],
  "helperColumns": [
    "y",
    "Normalized 1",
    "y-Normalized 1",
    "Normalized 2",
    "y-Normalized 2"
  ],
  "sampleData": {
    "headers": [
      "Period",
      "Jan",
      "Feb",
      "Mar",
      "Apr",
      "May",
      "Jun",
      "Jul",
      "Aug",
      "Sep",
      "Oct",
      "Nov",
      "Dec"
    ],
    "rows": [
      [
        "Category 1",
        127301224,
        160244644,
        230927220,
        209331614,
        235620392,
        198005536,
        271681313,
        253350193,
        183354651,
        223625868,
        280697637,
        283835394
      ],
      [
        "Category 2",
        347783209,
        350482613,
        294886422,
        277234281,
        390601900,
        364494634,
        380304637,
        389986295,
        263586140,
        326645109,
        336897908,
        406511445
      ]
    ]
  }
}