Column Chart Preset
Clustered Column
Clustered Column is an OPF column chart preset with canonical workbook metadata, sample data, and engine chart type mapping.
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
Start the value axis at zero
Keep series counts modest
Label important values directly
Recommended Companions
OPF Config
charts:clustered-column{
"$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
]
]
}
},
"design": {
"contentBox": false,
"contentAlignment": "left",
"titleAlignment": "left",
"contentDirection": "horizontal"
}
}
],
"catalogs": {
"layouts": {
"records": [
{
"$schema": "https://openpresentation.org/schema/opf-layout/v1",
"id": "data-visualization",
"name": "Data_Visualization",
"label": "Data Visualization",
"summary": "Clean charts and graphs with supporting text. Present complex data in digestible formats.",
"description": "Clean charts and graphs with supporting text. Present complex data in digestible formats.",
"tags": [
"Charts",
"Analytics",
"Data"
],
"master": "Gallery",
"masterSlideIndex": 3,
"groupHash": "153f444c25792e384c219fafc5ca1a0324103c782fa01f0902391c0014076cad",
"groupDefault": true,
"contentType": "Chart",
"contentMultiple": "1x",
"contentAlignment": "Left",
"contentBox": false,
"contentTypeChartPrimary": "None",
"contentTypeImageFill": "None",
"contentTypeListBullet": "None",
"contentTypeListHeading": false,
"slideTitle": true,
"slideTitleAlignment": "Left",
"slideImage": false,
"slideImageAlignment": "None",
"slideLayoutDirection": "Horizontal",
"zones": [
{
"role": "title",
"placeholder": "title"
},
{
"role": "chart",
"placeholder": "chart content 2"
},
{
"role": "text",
"placeholder": "text content 3"
}
],
"preview": {},
"details": "Clean charts and graphs with supporting text. Present complex data in digestible formats. OPF placeholders: title, chart, text.",
"category": "data-analysis",
"spatialCategory": "2 zone row",
"contentTypeTags": [
"comparison",
"mixed",
"chart"
],
"placeholders": [
{
"type": "title"
},
{
"type": "chart"
},
{
"type": "text"
}
],
"composition": {
"mode": "row"
},
"slideSubtitle": false
}
]
}
}
}Preview this config live at pptx.dev/playground, or load it in the gallery visual editor.