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://openpresentation.org/schema/opf/v1",
"name": "PPTX.gallery — charts/clustered-column",
"description": "Clustered Column is an OPF column chart preset with canonical workbook metadata, sample data, and engine chart type mapping.",
"tags": [
"gallery:charts/clustered-column"
],
"slides": [
{
"id": "gallery-preview-1",
"layout": "data-visualization",
"title": "Clustered Column",
"subtitle": "Compare category values in a familiar vertical format.",
"chart": {
"type": "clustered-column",
"data": {
"columns": [
"Series 1",
"Q1 2024",
"Q2 2024",
"Q3 2024",
"Q4 2024",
"Q1 2025",
"Q2 2025",
"Q3 2025",
"Q4 2025"
],
"rows": [
[
"Value 1",
98696,
81482,
21395,
87397,
65302,
14165,
13905,
22280
],
[
"Value 2",
38657,
40495,
76237,
88907,
13478,
83563,
36062,
95181
]
]
}
}
}
]
}Open in OPF Playground
Preview this config live at pptx.dev/playground.