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