
Short answer: use a stacked bar chart when each bar is a total that matters and you want to show roughly what it is made of, with two to five parts and only positive values. Use a 100% stacked bar chart when only the mix matters and the totals do not. Avoid stacked bars when readers must compare one middle segment precisely, when there are many segments, or when values can be negative: grouped bars, small multiples or a line chart will read better.
Update note (October 31, 2026): We built the example chart in a real spreadsheet (LibreOffice Calc) and added what we learned: how to put totals on top of the bars, two settings that went wrong on the first try, and a downloadable sample workbook. We also added a chart showing why the key segment belongs at the bottom, sorted the survey example by agreement, and answered three more common questions. The main rewrite was on October 29, 2026.
A stacked bar chart (also called a segmented bar chart) is the standard choice for part-to-whole data across a few categories; for other jobs, see choosing the right chart type. It splits each bar into colored segments laid end to end. The full bar shows a category's total; each segment shows one part of it. It answers two questions at once: which total is biggest? and what is each total made of?
The catch is the baseline. Only the bottom segment and the total sit on a common baseline. Every other segment starts at a different height, so readers have to judge its length rather than its position. Cleveland and McGill's graphical perception experiments (1984) found that people judge position along a common scale more accurately than unaligned lengths, which is why middle segments are hard to compare across bars.
| Use a stacked bar chart when | Avoid it when |
|---|---|
| The parts add up to a meaningful total (budget, tickets, revenue) | The parts do not sum to anything meaningful (for example, "select all that apply" answers) |
| Totals and rough composition are both part of the story | Readers must compare one middle segment exactly across bars |
| There are about two to five segments | There are more than five or six segments, or many tiny ones |
| All values are positive | Some values are negative |
| Categories are discrete (regions, teams, quarters) | You need to show a smooth trend over many time points |

Both panels use the same fictional totals. On the left, three segments and printed totals let a reader see at a glance that tickets grew each quarter and that email is the largest channel. On the right, seven segments without labels turn the chart into a color-matching exercise.
Good use cases
Poor use cases

Ask these questions in order:
If your real question is whether to stack or group, the short version is: grouped bars are better when readers must compare the individual parts, and stacked bars are better when the totals matter most. For a full comparison table, a side-by-side example and tool steps, see our guide to stacked vs grouped bar graphs.
A 100% stacked bar chart makes every bar the same length and shows each segment as a share of its own bar. Use it when the totals differ a lot or do not matter, and the story is about the mix: survey answers, market share, or the split of time across activities. For a single whole with only a few parts, a pie or donut can also work; see donut chart vs pie chart for when each fits.

Tips for 100% stacked charts:
What the switch hides, from our example data: we turned the support-ticket chart into a 100% stacked chart. Chat looked like it peaked in Q3 (30%, 29%, 35%, 28% of tickets in Q1 to Q4). But in raw counts, Q4 chat (40 tickets) was higher than Q2 (35); its share only fell because email grew faster. Both readings are correct; they answer different questions. That is why the rest of this guide asks whether the totals matter before you choose.
If the total also matters, keep a standard stacked chart, or show the totals in a small table or a separate bar next to the chart.

For general bar chart styling, see our bar graph design best practices.
Lay out the data with categories in the first column and one column per segment:
| Quarter | Chat | Phone | |
|---|---|---|---|
| Q1 | 50 | 30 | 20 |
| Q2 | 60 | 35 | 25 |
| Q3 | 55 | 45 | 30 |
| Q4 | 70 | 40 | 35 |
Before charting, check that segment names are consistent, that each row's parts add up to the total you expect, and that blanks are real zeros rather than missing data. (In R or Python, a long format with one row per category, segment and value is easier to stack.)
Excel: select the table, open the Insert tab, choose the column or bar chart button, and pick Stacked Column, Stacked Bar, or the 100% Stacked version. For a full walk-through of the Excel menus, see how to make a bar graph in Excel.
Google Sheets: select the table, click Insert > Chart, then in the Chart editor under Chart type choose Stacked bar chart or 100% stacked bar chart (or the column versions). For a step-by-step walkthrough, see how to make a bar graph in Google Sheets, and for the full build process, how to make a bar graph.
Stacked charts label each segment but not the bar's total, and the total is often the number readers want first. We built the example chart above with totals, and this is the method that worked:
=SUM(B2:D2) in each row. Do not type the totals by hand; they will drift when the data changes.In Google Sheets it is one setting: in the Chart editor, open Customize > Series and tick Total data labels. You do not need the extra column.

Two things that went wrong on our first try:
Download the sample workbook (XLSX). It has the table, the Total formulas, the stacked chart with totals, and a 100% stacked version on a second sheet. It opens in Excel, Google Sheets, Numbers and LibreOffice.
If you want to agree on the chart with your team first, you can sketch a stacked and a grouped version side by side on an AFFiNE whiteboard next to the data and notes, then build the final chart in your spreadsheet or BI tool.
Need a tool that draws both layouts? See our bar graph maker comparison.
When each bar is a total that matters and you want to show its two to five parts at the same time, for example quarterly spend split by cost type. If the parts do not add up to a meaningful total, use a simple or grouped bar chart instead.
Add a Total column with =SUM() for each row, include it in the chart, change only the Total series to a line chart, set the line to No line, and show its data labels Above. Then delete Total from the legend. In Google Sheets, tick Total data labels under Customize > Series instead.
It can be drawn, but it reads badly: negative segments hang below the axis, and the bar length no longer equals the total. For gains and losses, use a diverging bar chart or a waterfall chart.
For one whole with two to five parts, a pie or donut chart is fine. When you compare the make-up of several totals, such as four quarters or three regions, stacked bars are better because the bars line up on one axis. See our pie vs donut chart guide for the single-whole case.
Use a standard stacked chart when the totals matter. Use a 100% stacked chart when only the proportions matter, especially when totals differ a lot, and state the base (such as the number of respondents) because the chart hides it.
Combine small segments into "Other", keep about five segments or fewer, sort the bars, switch to horizontal bars for long labels, and label totals directly. If readers still cannot compare the parts, split the chart into small multiples, or compare the parts with grouped bars.
How this guide was prepared: The support-ticket and survey data and all diagrams are fictional and were drawn for this article. On October 31, 2026 we built the example chart, the totals method and the 100% version in LibreOffice Calc 26.8 on macOS; the screenshot and the sample workbook come from that test. Excel and Google Sheets menu names were checked against Microsoft and Google documentation rather than tested in those apps. 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.