Histogram Chart Preset
Pareto
Pareto is an OPF histogram chart preset with canonical workbook metadata, sample data, and engine chart type mapping.
paretoOPF type: SERIES_OF_MIXED_TYPESsimple
Use Case
Show the shape and concentration of numeric distributions.
Data Requirements
1 series, 49 categories, flat category/series workbook, 2 series groups
Group
Distribution charts that reveal frequency, concentration, and skew.
Series
1 series across 49 categories
Workbook Range
Sheet1!$A$1:$AX$2
Source Slide
Slide 47 in the OPF chart gallery deck
When to Use
Use for analytical audiences comparing spread, skew, or process variation.
When to Avoid
Avoid when the audience needs individual category comparison rather than distribution shape.
Best Practices
1
Use meaningful bins
2
Annotate important thresholds
3
Avoid decorative gradients that hide frequency
Recommended Companions
OPF Config
charts:paretoOpen Presentation Format
{
"$schema": "https://pptx.dev/schema/opf/v1",
"version": "1.0",
"meta": {
"title": "PPTX.gallery — charts/pareto"
},
"design": {},
"slides": [
{
"id": "gallery-preview-1",
"layout": "chart",
"elements": [
{
"id": "gallery-chart-1",
"type": "chart",
"chartPreset": "pareto",
"data": {
"labels": [
"Cat 1",
"Cat 2",
"Cat 3",
"Cat 4",
"Cat 5",
"Cat 6",
"Cat 7",
"Cat 8",
"Cat 9",
"Cat 10",
"Cat 11",
"Cat 12",
"Cat 13",
"Cat 14",
"Cat 15",
"Cat 16",
"Cat 17",
"Cat 18",
"Cat 19",
"Cat 20",
"Cat 21",
"Cat 22",
"Cat 23",
"Cat 24",
"Cat 25",
"Cat 26",
"Cat 27",
"Cat 28",
"Cat 29",
"Cat 30",
"Cat 31",
"Cat 32",
"Cat 33",
"Cat 34",
"Cat 35",
"Cat 36",
"Cat 37",
"Cat 38",
"Cat 39",
"Cat 40",
"Cat 41",
"Cat 42",
"Cat 43",
"Cat 44",
"Cat 45",
"Cat 46",
"Cat 47",
"Cat 48",
"Cat 49"
],
"datasets": [
{
"label": "Series1",
"values": [
49857,
62757,
45683,
75597,
80776,
74722,
67377,
20543,
88385,
15224,
66626,
52247,
89129,
42816,
13390,
21970,
40005,
98381,
85392,
86955,
12719,
98117,
45325,
85529,
15273,
32962,
71669,
78021,
95394,
67963,
46458,
33788,
86720,
67132,
93202,
74451,
21959,
71605,
55607,
63523,
53687,
52081,
97835,
23710,
31079,
53228,
63955,
74942,
47777
]
}
]
}
}
]
}
]
}Open in OPF Playground
Preview this config live at pptx.dev/playground.