A stacked bar chart is a bar chart that divides each bar into segments, where every segment represents a sub-category and the full bar shows the total. It's the standard way to show how parts add up to a whole across multiple categories at once.
Quick answer: Use a stacked bar chart when you need to compare totals across categories and see what each total is made of — for example, total revenue by quarter, broken down by product line. If you only care about comparing the individual sub-values side by side rather than the total, a grouped bar chart usually reads better; see our stacked vs. grouped bar chart comparison for that decision.
This guide covers the two stacked bar chart variants, how to read one correctly, real-world examples, the mistakes that make them hard to interpret, and how to build one from your own data with CleanChart.
What Is a Stacked Bar Chart?
A stacked bar chart represents each category as a single bar, split into colored segments. Each segment's length (or height, for vertical bars) is proportional to the value of that sub-category, and the segments stack end to end so the complete bar equals the category total.
This makes stacked bar charts useful for two things at once: comparing totals between categories, and showing the composition behind each total. A single glance answers both “which quarter had the highest revenue?” and “which product line drove that revenue?”
Stacked Bar Chart vs. Regular Bar Chart
A regular bar chart shows one value per bar. A stacked bar chart shows several values per bar, layered together. If your data has only one series (one number per category), you don't need a stacked chart — a plain bar chart is simpler and clearer.
Standard vs. 100% Stacked Bar Charts
There are two common versions of the stacked bar chart, and picking the right one changes what the chart communicates.
| Variant | What the bar height shows | Best for |
|---|---|---|
| Standard stacked bar | The actual total (sum of all segments) | Comparing both totals and composition across categories |
| 100% stacked bar (percentage stacked) | Always the same height — each segment is a share of 100% | Comparing composition only, when totals differ a lot or don't matter |
Choose 100% stacked when you want readers focused on proportions rather than magnitude — for example, comparing the share of traffic from each channel across months where total traffic varies widely. Choose standard stacked when the totals themselves are part of the story, like year-over-year revenue growth.
How to Read a Stacked Bar Chart
Reading a stacked bar chart correctly takes a bit more care than a regular bar chart, because you're extracting two kinds of information from the same bar.
- Read the whole bar first for the category total — this is the easiest comparison across bars.
- Read each segment against the legend to identify which sub-category it represents.
- Compare a specific segment across bars carefully. Only the bottom segment sits on a shared baseline of zero. Segments stacked higher up start at whatever value the segments below them end at, which makes their exact size harder to compare visually across bars — this is the single biggest source of misreading in stacked charts.
- Check the legend order. Most tools stack segments in the order the data columns appear, so the same category should keep a consistent position (and color) across every bar in the chart.
When Should You Use a Stacked Bar Chart?
Use a stacked bar chart when your data has a category (like month, region, or product), a total for each category, and a natural breakdown of that total into parts. If any one of those is missing, a different chart usually communicates better.
| Your situation | Recommended chart |
|---|---|
| Totals and composition both matter | Stacked bar chart |
| Only the totals matter, no breakdown needed | Bar chart |
| Comparing individual sub-values side by side, not the total | Grouped bar chart |
| Composition of a single snapshot in time, not across categories | Pie chart or donut chart |
| Composition changing continuously over time | Stacked area chart (see our area charts guide) |
For a full side-by-side breakdown of stacked against grouped bars specifically, including decision rules and more examples, see our stacked vs. grouped bar chart guide.
Stacked Bar Chart Examples
Stacked bar charts show up across almost every field that reports totals broken into parts:
- Revenue by product line, by quarter — each bar is a quarter, segments are product lines, bar height is total revenue.
- Website traffic by channel, by month — segments for organic, paid, referral, and direct traffic stacked into a monthly total.
- Survey responses by answer option — each bar is a survey question, segments are response categories like Strongly Agree through Strongly Disagree. A 100% stacked layout works especially well here; see our guide to charts for survey data for more on visualizing Likert-scale results.
- Headcount by department, by year — tracking how team composition shifts as a company grows.
- Budget allocation by category, by fiscal year — total spend broken into marketing, engineering, operations, and so on.
Common Mistakes to Avoid
Too Many Segments
Beyond five or six segments, colors become hard to distinguish and the chart turns into visual noise. Group smaller categories into an “Other” segment instead of stacking a dozen slivers.
Inconsistent Segment Order
If the stacking order of categories changes from bar to bar, readers can no longer track a single category's trend across the chart. Keep the same category in the same position in every bar.
Comparing Middle Segments by Eye
As noted above, only the bottom segment starts at zero. Don't ask readers to compare the size of a segment that's stacked in the middle of different bars — if that comparison matters, use a grouped bar chart or small multiples instead.
Using Stacked When You Need Grouped
If the real question is “which sub-category is bigger, this quarter vs. last?” rather than “what's the total?”, a stacked bar makes that comparison harder than it needs to be. That's exactly the distinction covered in our stacked vs. grouped comparison.
How to Create a Stacked Bar Chart
You can build a stacked bar chart from a spreadsheet or CSV without writing any code using CleanChart.
Step 1: Prepare Your Data
Structure your data with one row per category and one column per sub-category (for example, one row per quarter, one column per product line). CleanChart accepts CSV, Excel, ODS, JSON, XML, YAML, TSV, and plain text files. For a Google Sheet, download it as CSV or .xlsx first; there's no URL import or paste box.
Step 2: Upload and Choose the Chart Type
Upload your file and select the stacked bar chart type. CleanChart's automatic data cleaning handles common issues like missing values or inconsistent date formats before the chart is built, and offers a chart type recommendation with a confidence score if you're not sure stacked is the right fit.
Step 3: Customize and Export
Adjust colors, labels, gridlines, and annotations, then export as a PNG or SVG (or PDF on a paid plan). If you're starting from CSV specifically, our CSV to stacked bar chart converter goes straight from data to chart. If you copied cells from a spreadsheet, save them as a CSV file and upload that.
Frequently Asked Questions
What is a stacked bar chart used for?
A stacked bar chart is used to compare totals across categories while also showing what each total is composed of — for example, total sales by month broken down by product category. It answers “how big?” and “made of what?” in a single chart.
What is the difference between a stacked bar chart and a 100% stacked bar chart?
A standard stacked bar chart's height represents the actual total, so bar heights vary across categories. A 100% stacked bar chart normalizes every bar to the same height, showing each segment as a percentage of that category's whole rather than an absolute value.
When should I use a stacked bar chart instead of a grouped bar chart?
Use a stacked bar chart when the total matters and you want the composition alongside it. Use a grouped bar chart when you need to compare individual sub-values side by side rather than a combined total. See our full comparison for detailed decision rules.
How many categories can I stack in one bar?
Keep it to five or six segments at most. Beyond that, colors become difficult to tell apart and the chart is harder to read. Combine smaller categories into an “Other” segment if you have more than that.
Can I make a stacked bar chart from Excel or Google Sheets data?
Yes. CleanChart accepts Excel (.xls/.xlsx) files directly; for Google Sheets, download the sheet as CSV or .xlsx and upload that file. See our Google Sheets to chart guide for the Google Sheets workflow specifically.
Related CleanChart Resources
Chart Maker Pages
Converter Pages
- CSV to Stacked Bar Chart Converter
- Copied cells: save them as a CSV file, then use the CSV converter above
Related Blog Posts
- Stacked vs. Grouped Bar Charts: When Each One Actually Helps
- Different Chart Types Explained
- Area Charts: The Complete Guide
- How to Create a Bar Chart
- Google Sheets to Chart in 3 Minutes
External Resources
- Wikipedia — Bar Chart
- From Data to Viz: Bar Plot – Interactive decision guide for bar chart variants
- Storytelling with Data: Chart Chooser – Expert guide to selecting the right chart type
Last updated: July 28, 2026