SPARKLINE_5X
Metadata
ID
sparkline-5x
Catalog
chart-types
Source
spec/catalogs/chart-types/sparkline-5x.json
| Field | Value |
|---|---|
| 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 |
Source 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
]
]
}
}