
Short answer: use a grouped bar graph when readers must compare the individual parts across categories, and a stacked bar graph when they must compare category totals and see roughly what each total is made of. If only the mix matters, use a 100% stacked bar graph. Grouped bars win on precision because every bar starts from the same baseline; stacked bars win on totals and space.
Update note (October 29, 2026): We added a comparison table and a side-by-side diagram at the top, replaced the images with first-party examples, corrected the compound bar graph answer, re-checked the tool steps against current documentation, and replaced unrelated links with bar graph guides. On October 30 we updated the Microsoft Support chart-types link, which had moved.
| Grouped (clustered) bar graph | Stacked bar graph | 100% stacked bar graph | |
|---|---|---|---|
| Answers | How do the parts compare with each other? | How do totals compare, and what are they made of? | How does the mix (share of each part) differ? |
| Shared baseline | Every bar | Only the bottom segment and the total | Only the bottom and top segments |
| Shows totals | No (readers must add bars) | Yes, as bar length | No, every bar is 100% |
| Negative values | Handles them clearly | Confusing; avoid | Not suitable |
| Space | Wide; crowded past about 4 series | Compact | Compact |
| Labels | Value on each bar | Total at the end, a few key segments | Percent in each segment |

The example above uses the same fictional numbers twice. In the grouped panel it is easy to see that Product B sells best in South and Product A in West. In the stacked panel it is easy to see that South has the largest total (100) and West the smallest (70), but it is hard to tell whether Product C in North (20) is larger than Product B in West (20), because those segments start at different heights.
A grouped bar graph, also called a clustered bar graph (or clustered column chart when the bars are vertical), places one bar per sub-category next to each other inside each main category. A stacked bar graph, also called a segmented or composite bar graph, splits one bar per category into segments that add up to the category total.
The reason grouped bars are easier to compare comes from perception research. In Graphical Perception (Journal of the American Statistical Association, 1984), William Cleveland and Robert McGill found that people judge position along a common scale more accurately than lengths that are not aligned. In a grouped chart every bar sits on the same scale from zero. In a stacked chart only the bottom segment does; every other segment floats, so readers have to compare unaligned lengths.
This page is about choosing between the two. If you have already decided that a stacked chart fits and want to know when it works and when to avoid it, read when to use a stacked bar chart.

Answer these questions in order:
If you cannot decide, sketch both with a small slice of the data and ask a colleague what the main takeaway is. The chart that gets the right answer fastest is the better one.
Our bar graph design best practices checklist covers axes, sorting and color in more detail.
Arrange the data with categories in the first column and one column per series. Then:
| Tool | Grouped | Stacked | 100% stacked |
|---|---|---|---|
| Excel | Insert > Column or Bar > Clustered | Stacked Column or Stacked Bar | 100% Stacked Column or Bar |
| Google Sheets | Chart editor > Column or Bar chart | Setup > Stacking: Standard | Stacking: 100% |
| R (ggplot2) | geom_col(position = "dodge") | geom_col(position = "stack") (default) | geom_col(position = "fill") |
| Python (Matplotlib) | Offset each series' x positions by the bar width | Pass the running total to bottom= in ax.bar() | Divide by row totals first, then stack |
In ggplot2, map the series to fill (for example aes(x = region, y = units, fill = product)) with the data in long format. For step-by-step screenshots, see how to make a bar graph and how to make a bar graph in Google Sheets.
If you have not chosen a tool, see free bar graph makers compared, including which ones draw stacked and grouped bars.

A 100% stacked bar graph answers "is the mix different?" even when totals differ a lot. To build it by hand, divide each segment by its bar total and multiply by 100 (North's Product A: 40 / 90 = 44%). Rounded labels may not add to exactly 100. Because the totals disappear, add them to the category labels or a subtitle (for example "North, n = 90"). For when the mix alone is the right story, see when to use a 100% stacked bar chart.
Whatever you choose, use a title that states the finding ("South leads on total sales") rather than a label ("Sales by region").
A clustered stacked chart puts several stacked bars side by side in each group, for example budget and actual spend, each broken down by cost type, for every quarter. Use it only when readers truly need both comparisons, and keep it to two or three stacks per group and three or four segments per stack.
Excel has no built-in clustered stacked chart type. The common workaround is to lay out the data with blank rows between groups, build a stacked column chart from that range, and set the gap width so the stacks in each group sit together. In most cases two simpler charts, or small multiples, are easier to read.
If you plan charts with your team, you can sketch both versions on an AFFiNE whiteboard next to the data table and notes, then build the final chart in your spreadsheet or BI tool.
A grouped bar graph places one bar per sub-category side by side on a common baseline, so the parts are easy to compare. A stacked bar graph splits each category's bar into segments that add up to the total, so totals and rough composition are easy to see.
Use grouped bars when the main question is how the parts compare across categories. Use stacked bars when the main question is how the totals compare. Use 100% stacked bars when you want to compare shares.
They are good for comparing totals and the bottom segment, because those share a baseline. They are poor for comparing the middle and top segments precisely, because those segments start at different heights.
Usage varies. Many textbooks use "compound" or "component" bar graph for a stacked bar graph, while others use "compound" or "multiple" bar graph for grouped bars. Check which one your course or style guide means, and describe the chart by its layout if there is any doubt.
Yes. A clustered stacked chart shows several stacks side by side in each group. It works only with few stacks and segments; otherwise split it into simpler charts or small multiples.
How this guide was prepared: The regional sales data and all three diagrams are fictional and were drawn for this article. AFFiNE makes a docs and whiteboard workspace, so we have a commercial interest in mentioning it; any spreadsheet or charting tool works for the steps above. AI tools assisted with drafting, and the AFFiNE team reviewed the content.