SPARKLINE_4X
Metadata
ID
sparkline-4x
Catalog
chart-types
Source
spec/catalogs/chart-types/sparkline-4x.json
| Field | Value |
|---|---|
| label | Sparkline 4x |
| 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 |
| group | Sparkline |
| groupSort | 11 |
| series | 4 |
| seriesGroups | 2 |
| slideNumber | 63 |
| useSecondaryCategories | true |
| workbookRange | Sheet1!$A$1:$M$14 |
| complexity | normalized |
Source JSON
{
"$schema": "https://openpresentation.org/schema/opf-chart-type/v1",
"id": "sparkline-4x",
"name": "SPARKLINE_4X",
"label": "Sparkline 4x",
"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"
],
"group": "Sparkline",
"groupSort": 11,
"series": 4,
"seriesGroups": 2,
"slideNumber": 63,
"useSecondaryCategories": true,
"workbookRange": "Sheet1!$A$1:$M$14",
"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": "y",
"role": "helper",
"type": "number",
"position": "row5_col0"
},
{
"name": "Normalized 1",
"role": "helper",
"type": "number",
"position": "row6_col0"
},
{
"name": "Normalized 2",
"role": "helper",
"type": "number",
"position": "row7_col0"
},
{
"name": "Normalized 3",
"role": "helper",
"type": "number",
"position": "row8_col0"
},
{
"name": "Normalized 4",
"role": "helper",
"type": "number",
"position": "row9_col0"
},
{
"name": "y-Normalized 1",
"role": "helper",
"type": "number",
"position": "row10_col0"
},
{
"name": "y-Normalized 2",
"role": "helper",
"type": "number",
"position": "row11_col0"
},
{
"name": "y-Normalized 3",
"role": "helper",
"type": "number",
"position": "row12_col0"
},
{
"name": "y-Normalized 4",
"role": "helper",
"type": "number",
"position": "row13_col0"
}
],
"helperColumns": [
"y",
"Normalized 1",
"y-Normalized 1",
"Normalized 2",
"y-Normalized 2",
"Normalized 3",
"y-Normalized 3",
"Normalized 4",
"y-Normalized 4"
],
"sampleData": {
"headers": [
"Period",
"Jan",
"Feb",
"Mar",
"Apr",
"May",
"Jun",
"Jul",
"Aug",
"Sep",
"Oct",
"Nov",
"Dec"
],
"rows": [
[
"Category 1",
351100762,
352741011,
379496599,
387966832,
282312384,
311282670,
452151921,
379790805,
433333748,
384493624,
422399875,
417323155
],
[
"Category 2",
112746904,
221229196,
183077367,
149559096,
179550365,
213793767,
147945453,
227710269,
229965985,
174297265,
161163531,
183746340
],
[
"Category 3",
237548014,
134668693,
198704600,
207612874,
201403806,
147410128,
125604425,
201890459,
198475165,
249611663,
269899922,
220220298
],
[
"Category 4",
151483519,
143799732,
124809837,
255107244,
238648426,
290700676,
206450687,
161961806,
284636227,
166280805,
280244757,
229378769
]
]
}
}