How to Create a Clustered Column Chart
Data Format
One row per category. Each value column becomes one bar placed side by side within that category's group.
| Category | Value 1 | Value 2 |
|---|---|---|
| Q1 | 38 | 45 |
| Q2 | 44 | 53 |
| Q3 | 41 | 50 |
| Q4 | 49 | 60 |
- Category (required): the label for each group of bars.
- Value 1, Value 2... (required, numeric): one column per bar in the group. Add more value columns to add more bars per category.
Chart Elements
A clustered column chart uses the same style panel as a stacked column chart, see the Stacked Column Chart guide for labels, axes, gridlines, and axis labels. What's different:
Bars
Set Mode to Grouped to place bars side by side instead of stacking them, this is the default for a new multi-series chart.
- Color - one row per series.
- Stroke / Stroke Width - bar border.
- Bar Width - width of each individual bar, not the whole group.
Labels
Unlike stacked mode, the Position control (Middle or Outside) does apply here, grouped bars aren't forced to the middle.
Stack Totals and Stack Connectors
These only exist in Stacked or 100% Stacked mode. In Grouped mode there's no combined total to show and nothing to connect, so these sections don't appear in the style panel at all.
Legend
Same behavior as the stacked variant: appears automatically once there are two or more value columns.