What is a Stacked Bar Chart in Excel?

A stacked bar chart in Excel is an excellent tool for showing how a larger category breaks down into smaller parts. They allow you to instantly visualize part-to-whole relationships, making them perfect for comparing compositions across different groups or over time. This article will walk you through what a stacked bar chart is, when you should use one, and exactly how to build a clear, effective chart in Excel step-by-step.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What is a Stacked Bar Chart?

Imagine you have a single bar that represents total quarterly sales. Now, imagine that bar is divided into colored segments, with each segment showing where those sales came from - like Clothing, Electronics, and Home Goods. That’s a stacked bar chart.

Unlike a standard bar chart that only compares total values, a stacked bar chart does double duty: it shows you the total and it illustrates the relative contribution of each component within that total. The segments are "stacked" end to end within each bar, creating a visual breakdown of the data.

There are two primary types of stacked charts you’ll find in Excel:

• Stacked Bar Chart: Each segment in the bar has a value, and the total length of the bar is the sum of those values. This is great for comparing both the total size of each bar and the component parts within it.
• 100% Stacked Bar Chart: This variation makes every bar the same total length (representing 100%). Each segment represents the percentage it contributes to the total. This type is ideal when you care more about comparing the proportions between categories rather than their absolute amounts.

When to Use a Stacked Bar Chart

So, when does it make sense to reach for this chart type instead of a pie chart or a simple bar chart? Here are a few common scenarios where stacked bar charts shine.

Comparing Part-to-Whole Relationships

This is the classic use case. Stacked bar charts are perfect for illustrating how different components make up a total across several categories. For example, a marketing team could use one to show the total lead volume from different regions, with each bar segmented by lead source (e.g., Organic Search, Paid Ads, Social Media). This makes it easy to see not only which region generated the most leads but also which sources were most effective in each region.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Showing Composition Changes Over Time

Because they are organized along an axis, stacked bars are fantastic for telling a story over a period of time. You could track your company's revenue each year, with each bar segmented by business line. Over five years, you might see that a new business line that started as a thin sliver has grown to become the dominant segment of the total revenue bar, telling a clear story about business growth and focus.

Visualizing Survey Results or Budgets

Stacked charts can also simplify complex data like survey responses. Imagine you asked customers to rate their satisfaction on a scale from "Very Unsatisfied" to "Very Satisfied." You could create a 100% stacked bar chart for each customer segment (e.g., New vs. Returning). This would quickly reveal if, for instance, returning customers have a much higher percentage of "Very Satisfied" responses compared to new customers.

Similarly, you could visualize a department's budget allocation. Each bar could represent a quarter, with segments showing spending on salaries, marketing, software, and office supplies. It would provide a clear snapshot of how resources are being used over the year.

When to Avoid a Stacked Bar Chart

While powerful, stacked bar charts aren’t always the right tool for the job. Using them in the wrong situation can lead to confusion rather than clarity.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

When You Have Too Many Categories

If your "whole" is made up of ten or more "parts," a stacked bar chart becomes a cluttered, unreadable mess. Trying to distinguish between a dozen thin, colorful slivers is nearly impossible. As a general rule, try to stick to five or fewer segments per bar for maximum readability.

When Comparing Specific Segments is More Important

One major drawback of stacked bar charts is that it's difficult to compare segments that aren't on the baseline. The lowest segment in each bar is easy to compare because they all start from zero. But the other segments start at different points in each bar, making direct visual comparison tricky. If your primary goal is to compare the performance of a single sub-category across all your main categories (e.g., to see exactly how your "Electronics" sales trended each quarter), a line chart or a simple clustered bar chart might be a better choice.

When Your Data Includes Negative Values

Excel struggles to display stacked bar charts in a coherent way when negative values are involved. Mixing positive and negative numbers can create visually broken and misleading graphics. If you need to visualize contributions that include both gains and losses, consider using a waterfall chart instead.

How to Create a Stacked Bar Chart in Excel: A Step-by-Step Guide

Now for the fun part: let's build one. We'll use a straightforward example: tracking quarterly sales for an e-commerce store broken down by product category.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Arrange Your Data Correctly

How you structure your data is the most critical step. For a stacked bar chart, you’ll want your main categories (the labels for each bar) in the first column and your sub-categories (the segments within each bar) as the headers for the subsequent columns.

Here’s our example data:

Step 2: Insert the Stacked Bar Chart

With your data neatly arranged, creating the chart takes just a few clicks.

1. Highlight your entire data range, including the headers (in our example, this would be A1 through D5).
2. Navigate to the Insert tab on the Excel ribbon.
3. In the Charts group, click the icon for Insert Column or Bar Chart.
4. A dropdown menu will appear. Under the 2-D Bar section, hover over the options. You’ll see icons for "Stacked Bar" and "100% Stacked Bar." Select Stacked Bar.

Excel will instantly generate a basic stacked bar chart on your worksheet.

Step 3: Customize Your Chart for Clarity

The default chart is a great start, but a little customization turns it from a simple graph into a professional reporting tool.

• Add a Descriptive Title: The default "Chart Title" doesn't say much. Click on it and change it to something clear, like "Quarterly Sales by Product Category."
• Add Data Labels: Click anywhere on the chart area to bring up the chart tools. Click the green plus symbol (+) to the upper-right of the chart and check the box for Data Labels. This adds the numeric value to each segment, making the chart much easier to interpret at a glance.
• Improve the Legend: Excel automatically adds a legend that decodes the colors. Ensure it's clearly visible and not obstructing your chart data. You can click and drag it to a better position (e.g., top or bottom).
• Adjust Colors: If the default colors clash or lack meaning, you can easily change them. Right-click on one of the segments in your chart, click Format Data Series..., and use the paint bucket icon to select a new Fill color. You only have to change the color for one segment, and Excel will apply it to all segments of that same category.

Tips for Creating Effective Stacked Bar Charts

Want to take your charts to the next level? Here are a few pro-tips to keep in mind.

• Keep Your Segments Minimal: Remember, clarity is key. If you have more than four or five segments, your chart will become hard to read. Consider grouping smaller, less important categories into an "Other" segment.
• Order Your Segments Logically: The arrangement of segments within the bar matters. Try stacking them in a logical order, such as from largest to smallest. Or, place the most important segment at the bottom (against the baseline) to make it the easiest one to compare bar-to-bar.
• Use Color with Purpose: Colors should enhance understanding, not create confusion. Use sequential colors (e.g., light blue to dark blue) for data that has a logical order. Use contrasting colors for distinct categories. Above all, ensure there is enough contrast for a viewer to easily tell the segments apart.
• Switch Axes When Appropriate: In our example, we used a horizontal stacked bar chart. You could also use a vertical stacked column chart (the same principles apply). Horizontal bars are often better when you have long category labels on the Y-axis.

Final Thoughts

A stacked bar chart is a powerful Excel feature that helps you tell a compelling story about your data. By visualizing not just the totals but the pieces that make them up, you can uncover trends, compare compositions, and gain deeper insights that are often not visible in simple spreadsheets.

We understand that building these kinds of reports, especially when you have to export data from multiple platforms, can become a tedious weekly chore. That's why we wanted to create a more streamlined process. For instance, Graphed connects directly to your data sources like Google Analytics, Shopify, and your CRM, so you're always working with live data. Instead of wasting time recreating charts in Excel, you can use simple language to ask for the visual you need, and we build an interactive dashboard for you automatically.