All posts
Allen
Author, Content Operations Manager·Originally published Dec 8, 2025 · Updated Oct 31, 2026
When to use a stacked bar chart: use it when parts add up to a total that matters, use 100% stacked when only the mix matters, avoid it for many parts, beside a sample stacked chart

When to Use a Stacked Bar Chart (and When Not To)

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.

Understand Stacked Bars and What They Show

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 whenAvoid 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 storyReaders must compare one middle segment exactly across bars
There are about two to five segmentsThere are more than five or six segments, or many tiny ones
All values are positiveSome values are negative
Categories are discrete (regions, teams, quarters)You need to show a smooth trend over many time points

Good and Bad Stacked Bar Chart Examples

Two stacked bar charts of the same fictional quarterly support tickets with totals of 100, 120, 130 and 145. The left chart splits each quarter into three labeled segments, email, chat and phone, with the total printed above each bar, and is easy to read. The right chart splits the same totals into seven unlabeled colored segments, which makes the middle segments impossible to compare.

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

  • Budget or spend by category over a few periods: total spend per quarter, split into staff, software and travel.
  • Sales by product line for each region: which region sells the most, and roughly which products drive it.
  • Survey responses on a rating scale: the share of each answer for several questions, usually as a 100% stacked chart (see below, or the full walk-through on charting survey results).
  • Headcount or tickets by team or channel: totals per month with a small number of fixed groups.

Poor use cases

  • Comparing one middle part precisely. If the question is "did chat tickets grow between Q2 and Q3?", stacking hides it. Put that series in its own chart or use grouped bars.
  • Many segments. Beyond about five, colors get hard to tell apart and small segments disappear.
  • Negative values. Profit and loss, or gains and losses, make segments extend in both directions and the total becomes unclear. A diverging bar chart or a waterfall chart shows ups and downs more honestly.
  • Multi-select survey questions. Answers can sum to more than 100%, so the stack has no real total.
  • Long, continuous time series. For dozens of points, a line chart (or a stacked area chart, if the total matters) shows the trend more clearly.

A Decision Framework to Choose Stacked Bars

Decision chart titled Should you use a stacked bar chart, with four yes or no questions in order. One: do the parts add up to a total that matters? If no, use simple or grouped bars. Two: are values all positive with about 2 to 5 parts? If no, group small parts into Other, use small multiples or a line. Three: must readers compare one middle part exactly? If yes, use grouped bars or small multiples. Four: do the totals differ in a way that matters? If yes, use a stacked bar chart; if no, use a 100% stacked bar chart.

Ask these questions in order:

  1. Do the parts add up to a total that matters? If not, a stacked chart has nothing to stack. Use a simple bar chart, or grouped bars for several series.
  2. Are the values all positive, with about two to five parts? If not, combine small parts into "Other", split the chart into small multiples, or switch chart type.
  3. Must readers compare one middle part exactly across bars? If yes, give that part a shared baseline: grouped bars, small multiples, or move it to the bottom of the stack.
  4. Do the totals themselves differ in a way that matters? If yes, use a standard stacked bar chart. If only the proportions matter, use a 100% stacked bar chart.

Stacked Versus Grouped Bars

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.

When to Use a 100% Stacked Bar Chart

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.

Fictional 100% stacked horizontal bar chart of survey answers from 200 respondents to four statements. Each bar runs from strongly disagree in dark red through disagree, neutral in gray, agree and strongly agree in dark blue, with a percentage in every segment. The bars are sorted by agreement: Support is fast has the most at 70 percent agree or strongly agree, Onboarding was clear and I would recommend it follow at 55 percent, and Docs answer my questions has the least at 35 percent.

Tips for 100% stacked charts:

  • Say what 100% is. Note the base (for example, "200 respondents") in the subtitle or a caption, because the chart hides counts.
  • Order the segments logically. For rating scales, run from negative to positive with neutral in the middle, and use a diverging palette.
  • Label percentages, not raw values. Readers compare shares here.
  • Do not use it for multi-select questions or any data where parts do not sum to the whole.

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.

Design Rules to Improve Readability and Trust

Two stacked column charts of the same fictional quarterly support tickets with totals of 100, 120, 130 and 145. On the left, chat sits in the middle of each bar between email and phone, so its values of 30, 35, 45 and 40 float at different heights and are hard to compare. On the right, chat is moved to the bottom of the stack, so the same values start from the zero baseline and the rise to Q3 and dip in Q4 are easy to see.
Same data and totals. Only the order of the segments changed.
  • Put the most important part at the bottom. It is the only segment (apart from the total) that sits on the baseline, so it is the easiest to compare.
  • Keep the same segment order and color in every bar, and keep the legend in the same order as the stack.
  • Sort the bars with intent: by total for a ranking, or in natural order for time.
  • Label totals at the end of each bar and label only the segments that matter; direct labels beat a distant legend.
  • Limit segments to about five. Group small ones into "Other" and say what "Other" contains.
  • Go horizontal for long category names so labels do not rotate. Columns (vertical bars) suit time on the x-axis.
  • Do not rely on color alone. WCAG 1.4.1 says color should not be the only way information is conveyed, so add labels, and use a palette that stays distinct for color-blind readers. Thin white borders help small segments stand out.
  • Start the axis at zero. A stacked bar's length is the total, so a cropped axis misrepresents it.

For general bar chart styling, see our bar graph design best practices.

Make a Stacked Bar Chart in Excel or Google Sheets

Lay out the data with categories in the first column and one column per segment:

QuarterEmailChatPhone
Q1503020
Q2603525
Q3554530
Q4704035

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.

Add Totals on Top of a Stacked Bar Chart

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:

  1. Add a Total column next to the data, with a formula such as =SUM(B2:D2) in each row. Do not type the totals by hand; they will drift when the data changes.
  2. Move the series you care about to the first column (we put Chat first). The first series is drawn at the bottom of the stack, on the baseline.
  3. Chart all four columns as a stacked column chart, then change only the Total series to a line. In Excel, right-click the Total series and choose Change Series Chart Type, then set Total to Line. Set the line to No line and turn on its data labels with the position Above. The labels now float over each bar while the line itself is invisible.
  4. Remove Total from the legend. Click the legend once, click the Total entry, and press Delete, so readers do not look for a fourth color.

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.

LibreOffice Calc sheet with the fictional quarterly ticket table, a Total column calculated with SUM, and a stacked column chart below it. Chat is the bottom segment of each bar, then email, then phone, every segment shows its value, and the totals 100, 120, 130 and 145 are printed above the bars. The legend lists only chat, email and phone.
Our test chart, built and rendered in LibreOffice Calc 26.8 with the steps above.

Two things that went wrong on our first try:

  • The labels were cluttered. The first version printed "Q1; Chat; 30" inside every segment, because the category name and series name were switched on alongside the value. Showing the value only made the chart readable again.
  • Total showed up in the legend with no color swatch, which looked like a mistake. Deleting that one legend entry (step 4) fixed it.

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.

Frequently Asked Questions

When is a stacked bar graph the most appropriate option?

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.

How do I add totals to a stacked bar chart in Excel?

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.

Can a stacked bar chart have negative values?

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.

Is a stacked bar chart better than a pie 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.

Should I use a 100% stacked bar chart or a standard one?

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.

How can you make a stacked bar chart readable with many categories or segments?

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.

Sources

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.