Grouped vs stacked bar charts: which should you use?

Both charts start from the same data: categories, a few series, and a value for each. The choice decides what the reader can compare easily, and what they’ll struggle with. Here’s how to pick in under a minute.

What a grouped bar chart is

A grouped bar chart draws one bar per series inside each category. Brightside Bikes, a fictional retailer, might show units sold by North, South and West across four quarters: twelve bars, in four clusters of three. Every bar starts on the baseline, so comparing West across quarters, or West against North in Q4, is as easy as reading a simple bar chart.

Excel calls this a clustered column chart when the bars are vertical and a clustered bar chart when they’re horizontal. With two series, like 2025 vs 2026, teachers often call it a double bar graph. Same chart, different names.

What a stacked bar chart is

A stacked bar chart piles the series into a single bar per category, so the bar’s height is the total and each segment is a part of it. The same Brightside data becomes four bars, each split into North, South and West. You can see total units per quarter at a glance, plus a rough sense of the mix.

The cost is precision. Only the bottom segment shares a baseline, so the middle and top segments float. Stacked bars are great at totals and quietly terrible at everything in the middle. Our segmented bar graph guide goes deeper, including the 100% stacked variant.

A worked example

Brightside Bikes sold 1,240 units in the North in Q1 and 1,620 in Q4. The West went from 610 to 1,540. South moved from 980 to 1,190. Two stories hide in those twelve numbers.

Story one: “West nearly caught up with North.” That’s a comparison between two series, so it needs a grouped bar chart. In Q4, the West bar stands almost as tall as the North bar right beside it, and the gap that was obvious in Q1 has all but closed.

Story two: “Total sales grew 54% in a year.” Totals went from 2,830 to 4,350. That’s a composition story, so it needs a stacked bar chart, where each quarter’s bar height is the total and the growing West segment shows where the growth came from.

Same data, two charts, two different slides. If both stories matter, show both, and give each its own title.

How to choose: four questions

1. Does the total mean something?

Revenue by product line adds up to total revenue, a meaningful number, so stacking works. Conversion rates by channel don’t add up to anything, so stacking them would invent a meaningless total. Group them.

2. Which comparison matters most?

If the story is “West caught up with North”, the reader needs to compare two series directly, so group. If the story is “Q4 was our biggest quarter”, the reader needs totals, so stack.

3. How many series are there?

Grouped bars get thin fast. Past four series, consider stacking, splitting into small multiples, or keeping only the series that matter.

4. Are there negative values?

Stacking positive and negative values in one bar is hard to read. Grouped bars handle negatives cleanly.

Clustered column or clustered bar?

Both layouts come in two orientations. Vertical bars (columns) suit time periods and short category names: four quarters, three regions. Horizontal bars suit long names and longer lists, like ten product lines compared across two years. The grouped-vs-stacked decision and the orientation decision are independent, so make them one at a time: first comparison or composition, then which way the bars should point.

Common mistakes

• Stacking things that don’t add up, like rates, averages or percentages of different bases.
• Grouping eight series. If your legend has more entries than your chart has clusters, something has gone sideways.
• Changing colors between charts. Keep each series the same color across the whole report, ideally from one saved palette.
• Leaving totals unlabeled on stacked bars. Add a total label above each bar.
• Forgetting orientation. Long category names read better as horizontal bars; see horizontal vs vertical bar charts.

How to make grouped and stacked bar charts in Lightchart

You don’t have to commit up front. In the Lightchart grouped bar chart maker, the same data switches between layouts in one click:

1. Paste three columns: category (Quarter), series (Region) and value (Units).
2. Open the bar settings and set Bar Mode to Grouped, Stacked or Stacked %.
3. Pick the version that makes your point, apply your palette, and export a 2× PNG.

For the stacked version, the stacked bar chart maker adds total labels and 100% stacking. Comparison or composition: pick one, and let the title say which.