XY (Scatter) Chart Preset
Dot Plot 5x
Dot Plot 5x is an OPF xy (scatter) chart preset with canonical workbook metadata, sample data, and engine chart type mapping.
Use Case
Explore relationships between two numeric variables or compare many points without bars.
Data Requirements
5 series, 8 categories, calculated helper workbook, 2 series groups
Group
Point-based relationship charts for correlation, distribution, and paired measures.
Series
5 series across 8 categories
Workbook Range
Sheet1!$A$1:$I$10
Source Slide
Slide 38 in the OPF chart gallery deck
When to Use
Use for correlation, outlier detection, and paired-value analysis.
When to Avoid
Avoid when the audience needs a simple ranked comparison or when points cannot be labeled clearly.
Best Practices
Explain both axes clearly
Highlight outliers intentionally
Avoid overplotting with too many points
Recommended Companions
Color Schemes
OPF Config
charts:dot-plot-5x{
"$schema": "https://pptx.dev/schema/opf/v1",
"version": "1.0",
"meta": {
"title": "PPTX.gallery — charts/dot-plot-5x"
},
"design": {},
"slides": [
{
"id": "gallery-preview-1",
"layout": "chart",
"elements": [
{
"id": "gallery-chart-1",
"type": "chart",
"chartPreset": "dot-plot-5x",
"data": {
"labels": [
"Item 1",
"Item 2",
"Item 3",
"Item 4",
"Item 5",
"Item 6",
"Item 7",
"Item 8"
],
"datasets": [
{
"label": "2020",
"values": [
587455,
556732,
381433,
437960,
357420,
190872,
392477,
572700
]
},
{
"label": "2021",
"values": [
355709,
587282,
697530,
497399,
452737,
130094,
618317,
440802
]
},
{
"label": "2022",
"values": [
290672,
611233,
322423,
472060,
370902,
456871,
393243,
389688
]
},
{
"label": "2023",
"values": [
682789,
110644,
641722,
300337,
189771,
353080,
526170,
612311
]
},
{
"label": "2024",
"values": [
682144,
351997,
599219,
614663,
569945,
118080,
197573,
408528
]
}
]
}
}
]
}
]
}Preview this config live at pptx.dev/playground.