Column Chart Preset
Clustered Column
Clustered Column is an OPF column chart preset with canonical workbook metadata, sample data, and engine chart type mapping.
clustered-columnOPF type: CLUSTERED_COLUMNsimple
Use Case
Compare category values in a familiar vertical format.
Data Requirements
2 series, 8 categories, flat category/series workbook
Group
Vertical comparisons across categories, time periods, or grouped series.
Series
2 series across 8 categories
Workbook Range
Sheet1!$A$1:$I$3
Source Slide
Slide 2 in the OPF chart gallery deck
When to Use
Use when categories are short, sequence matters, or the audience expects a conventional business comparison.
When to Avoid
Avoid when labels are long or when too many series would make the columns visually dense.
Best Practices
1
Start the value axis at zero
2
Keep series counts modest
3
Label important values directly
Recommended Companions
OPF Config
charts:clustered-columnOpen Presentation Format
{
"$schema": "https://pptx.dev/schema/opf/v1",
"version": "1.0",
"meta": {
"title": "PPTX.gallery — charts/clustered-column"
},
"design": {},
"slides": [
{
"id": "gallery-preview-1",
"layout": "chart",
"elements": [
{
"id": "gallery-chart-1",
"type": "chart",
"chartPreset": "clustered-column",
"data": {
"labels": [
"Q1 2024",
"Q2 2024",
"Q3 2024",
"Q4 2024",
"Q1 2025",
"Q2 2025",
"Q3 2025",
"Q4 2025"
],
"datasets": [
{
"label": "Value 1",
"values": [
98696,
81482,
21395,
87397,
65302,
14165,
13905,
22280
]
},
{
"label": "Value 2",
"values": [
38657,
40495,
76237,
88907,
13478,
83563,
36062,
95181
]
}
]
}
}
]
}
]
}Open in OPF Playground
Preview this config live at pptx.dev/playground.