clustered bar chart excel / Step-by-step workflow
Clustered Bar Chart in Excel: Data Format and Steps
To make a clustered bar chart in Excel, put categories in the first column, put each series in its own value column, select the table, then choose a clustered bar or clustered column chart.
- 01
Step 1: Prepare category and series columns
Use one category column and one numeric column for each series you want to compare side by side.
- 02
Step 2: Select the chart range
Include headers so Excel can build the legend automatically. Avoid merged cells and blank rows.
- 03
Step 3: Insert clustered bar or column
Open Insert, choose Bar Chart or Column Chart, then select the clustered option.
- 04
Step 4: Choose the best orientation
Use clustered bars for long labels and clustered columns for shorter labels or time-based categories.
- 05
Step 5: Compare with stacked charts
If your series are parts of a whole, consider a stacked chart. If you need direct side-by-side comparison, keep the clustered chart.
Copyable data
Use this starter table
Paste this into a spreadsheet or preview it in the chart tool before styling.
region,2024,2025,2026
North,120,140,165
South,95,110,130
West,105,128,150FAQ
What is a clustered bar chart in Excel?
It is an Excel bar chart where multiple series are shown side by side within each category.
What is the difference between clustered bar and clustered column?
Clustered bar charts are horizontal. Clustered column charts are vertical. The data structure can be the same.
When should I use stacked instead of clustered?
Use stacked charts when the series add up to a total. Use clustered charts when comparing series side by side is more important.
Last updated: 2026-07-06