Each row becomes one bar and each column a coloured segment, with the value written inside when it fits. Download SVG or PNG with no account and no watermark.
How to make a stacked bar chart
- Put one bar per row: the bar’s name in the first column.
- Put one segment per column: the segment’s name in the header, its values below.
- Paste the cells in the Data panel. The page opens with “Stacked” selected.
- Turn on value labels to write each value inside its segment, and download.
What stacking shows
A stacked bar answers two questions at once: how big is the total, and what is it made of. The total is the full height of the bar and is read against the axis. The bottom segment is also easy to read, because it starts at zero. The segments above it float, so their sizes can be compared only roughly.
That decides the order of your columns. Put the series that matters most first, so it sits on the axis. Keep the same order in every bar; the chart does that for you and gives each series one colour throughout.
Stacked, grouped or 100%
- Stacked: totals first, composition second.
- Grouped: compare the parts with each other; the total is not shown. Switch with “Side by side” in the Design panel, or open the bar chart maker.
- 100% stacked: compare the mix when totals differ a lot. Enter the shares of each row as percentages that add up to 100 and choose the Percent format.
Labels and colour
A value is written inside its segment when the segment is large enough, in white or dark ink depending on the fill, so it stays readable on every colour of the palette. For series with an order, such as low, medium and high, the “Blues” palette goes from dark to light and makes the order visible. For unrelated categories keep a categorical palette.
Sorting
“Largest first” sorts the bars by their total. Leave the order alone for weeks, months or any sequence. For a continuous period with many steps, an area chart shows the same composition as a flowing shape.