How to Make a Stacked Bar Chart in Excel

A stacked bar chart is one of the most effective ways to show how different parts contribute to a whole across multiple categories. Instead of getting lost in rows of spreadsheet data, this chart gives you an immediate visual command of your information. This guide will walk you through exactly how and when to use a stacked bar chart in Excel and provide tips on making it look professional.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What Exactly is a Stacked Bar Chart?

A stacked bar chart visualizes data by stacking segments end-to-end within horizontal bars. Each bar represents a primary category, and the different colored segments within that bar represent sub-categories, or parts of a whole. This makes it incredibly easy to see two things at once: the total for each main category (the full length of the bar) and the contribution of each sub-category within it.

In Excel, you’ll typically encounter two variations:

• Stacked Bar Chart: Each bar's length is determined by the sum of its segments. This is best when you need to compare both the total value across categories and the breakdown of those totals. For example, comparing total quarterly sales, while also seeing the contribution of each product line.
• 100% Stacked Bar Chart: Each bar is the same length, representing 100%. The segments show the relative percentage of each sub-category. This is ideal when your main goal is to compare the proportions or percentage contribution across categories, rather than the absolute totals. For instance, comparing the percentage of website traffic from different countries across several months.

When Should You Use a Stacked Bar Chart?

Stacked bar charts are incredibly versatile, but they shine brightest in specific scenarios. You should reach for one when you want to:

• Show a Parts-to-Whole Relationship: This is a stacked bar chart's primary job. It’s perfect for visualizing budget breakdowns, regional sales contributions, or any data where sub-categories add up to a meaningful total.
• Compare Totals and Their Composition: If you sell three products in four different regions, a stacked bar chart lets you quickly see which region has the highest total sales and which product is the bestseller in each of those regions.
• Analyze Composition Changes Over Time: By using a time period (like months or quarters) as your main category, you can see how the mix of your data changes. For example, you can track if traffic from social media is growing as a percentage of your total website visitors each month.
• Visualize Survey Data: Stacked bar charts are great for Likert scale responses (e.g., Strongly Agree, Agree, Neutral, Disagree). You can quickly grasp the overall sentiment for each survey question.

However, avoid using a stacked bar chart if you have too many sub-categories (more than four or five makes it hard to read) or if the main goal is to precisely compare the size of a single sub-category across all the main categories. In that case, a standard clustered bar chart might be easier to interpret.

Graphed

Still Building Reports Manually?

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

Watch the Demo

How to Structure Your Data in Excel

Before you even think about creating the chart, getting your data organized correctly is the most important step. A poorly structured table will lead to a nonsensical chart and a lot of frustration. For a stacked bar chart, you need a simple, grid-like layout.

Your data table should be set up like this:

• Your main categories should be listed in the first column. These will become the individual bars on your chart (e.g., Q1, Q2, Q3, Q4 or North, South, East, West).
• Your sub-categories (the "segments") should be in the subsequent column headers. These will become the colored sections within each bar (e.g., Product A, Product B, Product C).
• The numerical values for each sub-category should fill the grid below their respective headers.

Here’s an example of a perfectly structured table for charting quarterly sales by product line:

Once your data looks like this, building the chart takes just a few clicks.

Step-by-Step Guide: Creating a Stacked Bar Chart in Excel

With your data prepped and ready, follow these simple steps to bring your chart to life.

Step 1: Select Your Data

Click and drag your cursor to highlight the entire data set you want to visualize, including the column headers and row labels. In our example above, you would select the range from "Quarter" down to "$11,000."

Pro Tip: Make sure not to include any "Total" rows or columns in your selection. Excel will try to chart those as well, which will skew your visualization. The chart calculates the totals for you automatically.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 2: Navigate to the Insert Tab

At the top of the Excel window, click on the Insert tab in the ribbon.

Step 3: Choose the Bar Chart Option

In the "Charts" section of the ribbon, find and click the icon that looks like a horizontal bar chart, labelled "Insert Bar or Column Chart."

Step 4: Select "Stacked Bar"

A dropdown menu will appear with several chart options. Under the "2-D Bar" section, hover your mouse over the second option. It will be labelled "Stacked Bar." Click it.

And that's it! Excel will instantly generate a stacked bar chart on your worksheet based on the data you selected.

How to Make a 100% Stacked Bar Chart

Creating a 100% stacked bar chart is almost identical. This variation is fantastic when you're more interested in the proportional relationship between parts, not their absolute values.

Follow steps 1-3 from above. For Step 4, simply select the third option in the "2-D Bar" section labelled "100% Stacked Bar." Excel will automatically convert your values into percentages and display them within bars of equal length, making it very easy to compare the compositional mix across your categories.

Customizing Your Chart for Impact and Clarity

A default Excel chart gets an 'A' for effort but an 'F' for presentation. To make your chart truly useful and professional, a little customization goes a long way. After creating your chart, click on it, and two new tabs, "Chart Design" and "Format," will appear on the ribbon.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Adding Essential Chart Elements

On the Chart Design tab, click the "Add Chart Element" button on the far left. From here, you can add:

• Chart Title: Always use a clear, descriptive title. "Sales Performance" is okay, but "2023 Quarterly Sales by Product Line" is much better.
• Axis Titles: Label your horizontal (X) axis with what the values represent (e.g., "Total Sales Revenue") and the vertical (Y) axis if needed (e.g., "Quarter"), though the categories themselves are often clear enough on the Y-axis.
• Data Labels: This is a game-changer for readability. You can add the actual numerical values directly onto each segment in your bars. This gives your audience exact figures without them having to guess based on the axis. Choose "Center" or "Inside End" for a clean look.
• Legend: The legend is crucial for explaining what each color represents. You can move its position (Top, Bottom, Right, Left) to suit your layout.

Improving the Visual Design

• Color Palette: Still on the Chart Design tab, the "Change Colors" button lets you quickly apply professionally designed color schemes. Choose one that has good contrast between segments.
• Individual Colors: To change a single segment's color, click once on any bar to select the whole series, then click a second time on just the segment you want to change. Right-click, select "Format Data Point," and use the paint can icon to choose a new fill color.
• Gap Width: Right-click any bar and select "Format Data Series." You'll see an option for "Gap Width." Reducing this percentage makes your bars thicker and can make your chart look more substantial.

Common Mistakes to Avoid

Knowing what not to do is just as important as knowing what to do. Avoid these common pitfalls:

• Too Many Segments: Resist the temptation to show every detail. A bar with ten tiny colored stripes (often called a "rainbow chart") becomes impossible to decipher. If you have more than 4-5 categories, consider grouping smaller ones together into an "Other" category.
• Inconsistent Ordering: The order of segments within each bar should be logical and consistent. For instance, always arrange them from largest to smallest, or in a natural order (e.g., Beginner, Intermediate, Advanced). This makes comparisons much easier. You can change the order by right-clicking the chart, choosing "Select Data," and re-ordering the series in the dialog box.
• Starting the Value Axis Above Zero: The whole point of the chart is to compare totals visually by the bar's length. Starting the horizontal axis at a value other than zero will distort this comparison and is misleading.

Final Thoughts

Once you get the hang of organizing your data, creating a stacked bar chart in Excel is a quick and powerful method for showing parts-to-whole relationships across categories. They transform overwhelming tables into clear stories, helping you and your team quickly identify trends, compare performance, and make smarter decisions based on data.

Of course, manually building these visuals in Excel every week for your reports can be a huge time-sink. We built Graphed to take that tedious work off your plate. By connecting your sales and marketing platforms directly, you can simply ask for the chart you need in plain English - like "create a stacked bar chart showing sessions by device category from Google Analytics for the last quarter" - and get a live, interactive dashboard built in seconds, not hours.