Sparkline Chart Preset
Sparkline 5x
Sparkline 5x is an OPF sparkline chart preset with canonical workbook metadata, sample data, and engine chart type mapping.
sparkline-5xOPF type: SERIES_OF_MIXED_TYPESnormalized
Use Case
Add trend context beside KPIs without consuming a full chart panel.
Data Requirements
5 series, 12 categories, normalized table workbook, 2 series groups, secondary categories
Group
Compact trend lines for dense dashboards and inline metric context.
Series
5 series across 12 categories
Workbook Range
Sheet1!$A$1:$M$17
Source Slide
Slide 64 in the OPF chart gallery deck
When to Use
Use when the exact values are secondary and direction or volatility is the signal.
When to Avoid
Avoid when axes, exact labels, or multiple annotations are required.
Best Practices
1
Pair with a headline metric
2
Keep the sparkline visually quiet
3
Avoid overexplaining tiny charts
Recommended Companions
OPF Config
charts:sparkline-5xOpen Presentation Format
{
"$schema": "https://pptx.dev/schema/opf/v1",
"version": "1.0",
"meta": {
"title": "PPTX.gallery — charts/sparkline-5x"
},
"design": {},
"slides": [
{
"id": "gallery-preview-1",
"layout": "chart",
"elements": [
{
"id": "gallery-chart-1",
"type": "chart",
"chartPreset": "sparkline-5x",
"data": {
"labels": [
"Jan",
"Feb",
"Mar",
"Apr",
"May",
"Jun",
"Jul",
"Aug",
"Sep",
"Oct",
"Nov",
"Dec"
],
"datasets": [
{
"label": "Category 1",
"values": [
394192109,
298791835,
291735757,
387547136,
285549617,
402554736,
416691818,
370896114,
338524862,
436475508,
450689044,
445346510
]
},
{
"label": "Category 2",
"values": [
184694692,
187026655,
243832637,
215693071,
282879921,
223502304,
262672508,
340961425,
244063499,
269927808,
172394131,
209079951
]
},
{
"label": "Category 3",
"values": [
407310440,
361244398,
363019404,
348933300,
412854772,
455414485,
396335652,
361436061,
448877666,
381689431,
463288538,
442714573
]
},
{
"label": "Category 4",
"values": [
397995978,
514303755,
385564250,
542703984,
525924909,
434505855,
538801568,
531604872,
472201924,
575190383,
462741434,
482489022
]
},
{
"label": "Category 5",
"values": [
191572637,
286844139,
254728898,
315419922,
294583213,
302197618,
204085411,
345307584,
283404222,
355759261,
340962092,
354360356
]
}
]
}
}
]
}
]
}Open in OPF Playground
Preview this config live at pptx.dev/playground.