How to Combine Stacked and Clustered Charts in Excel

Combining stacked and clustered column charts in Excel lets you tell a richer, more detailed story with your data. It’s a powerful way to compare totals across different categories while showing the composition of those totals at the same time. This guide will walk you through exactly how to build this useful chart, step by step.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Combine Clustered and Stacked Charts?

First, let's look at why you'd want to use this type of combination chart. A standard clustered column chart is great for comparing distinct categories. A stacked column chart is perfect for showing how individual parts make up a whole. By combining them, you get the best of both worlds.

Imagine you're reporting on quarterly sales for two different products: "Product A" and "Product B." You want to see:

• How the total sales of Product A compare to Product B each quarter (a clustered comparison).
• How much of each product's total sales came from "Online" versus "In-Store" channels (a stacked breakdown).

A clustered stacked chart visualizes this perfectly. Each quarter will have two columns side-by-side (one for Product A, one for Product B), and each of those columns will be a stack showing the online and in-store sales breakdown. You instantly see both the high-level comparison and the detailed composition in a single, clean visual.

Graphed

Still Building Reports Manually?

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

Watch the Demo

The Key: Structuring Your Data for Success

Excel doesn't have a one-click button for a "Clustered Stacked Chart." The magic behind creating one lies entirely in how you arrange your source data. We are essentially going to trick Excel's standard Stacked Column chart into creating visual clusters by using a blank "spacer" column.

Your data needs to be organized with your main clusters separated by completely empty columns. Importantly, you should also use a multi-row header to label your data cleanly. This makes the setup much easier and the final chart legend more readable.

Here’s what the correct data structure looks like for our example of comparing sales for two products with two sales channels:

In this layout:

• Top Header Row (Row 1): This contains your main cluster categories. We've merged cells C1 and D1 to create a single "Product A" label, and cells F1 and G1 for "Product B." This helps tame the chart legend.
• Second Header Row (Row 2): This holds the sub-categories for your stacks ("Online Sales" and "Retail Sales").
• Spacer Column (Column E): This column is left completely blank - no data, no header. This empty space is what tells Excel to create a gap between the Product A data and the Product B data, which forms our "clusters."
• First Column (Column A): This contains the labels for your horizontal axis (in this case, the quarters).

Taking a few moments to set up your sheet this way is the most important step and will save you a headache later.

Step-by-Step Guide to Creating the Chart

Once your data is structured correctly, creating the chart is straightforward. Just follow these steps.

Step 1: Insert a Stacked Column Chart

First, click and drag your cursor to select your entire data range. In our example table, this would be from cell A1 to G6. Be sure to include the two header rows, the data, and the blank spacer column.

Next, navigate to the Insert tab on Excel's ribbon. In the Charts section, click on the "Insert Column or Bar Chart" icon, and under the 2-D Column section, choose Stacked Column.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 2: Check the Initial Chart Output

Excel will instantly generate a chart that looks something like this:

At this stage, it doesn't look perfect, but we're on the right track! You can see the stacked columns for Product A are grouped together, followed by a gap (thanks to our spacer column), and then the stacked columns for Product B. The main thing we need to fix is the messed-up labels on the horizontal axis.

Step 3: Fix the Horizontal Axis Labels

Right now, the horizontal axis just shows numbers (1, 2, 3, 4) instead of our quarters (Q1, Q2, Q3, Q4).

Let's fix it:

1. Right-click anywhere inside the chart area and choose Select Data from the context menu.
2. A dialog box called Select Data Source will appear. On the right side, under Horizontal (Category) Axis Labels, you'll see the incorrect generic labels. Click the Edit button.
3. Another small window, Axis Labels, will pop up. Click inside the "Axis label range" text box. Now, select the range on your spreadsheet that contains your desired labels. In our case, that would be cells A3 through A6.
4. Click OK in the Axis Labels window, and then OK again in the Select Data Source window.

Your horizontal axis will now correctly display "Q1," "Q2," "Q3," and "Q4" under the appropriate data points.

Step 4: Clean Up the Design and Add Finishing Touches

The chart is functional, but it needs a few cosmetic tweaks to make it professional and easy to read.

Edit the Legend

The legend probably lists an entry for our blank spacer column. We need to remove it.

• Click on the chart legend to select it.
• Click a second time specifically on the legend entry for your spacer column (it may be labeled Column4, Spacer, or just show up as a blank entry). This selects only that one item.
• Press the Delete key on your keyboard. Poof! It’s gone.

Add a Chart Title

Your chart needs a clear and descriptive title. Double-click on the "Chart Title" placeholder text at the top and type in something meaningful, like "Quarterly Sales Performance: Product A vs. Product B."

Adjust Colors for Clarity

To make the comparisons even clearer, it’s a good idea to use a consistent color scheme. For example, make "Online Sales" blue for both Product A and Product B, and make "Retail Sales" orange for both.

To change a color:

• Single-click on one of the stacks you want to recolor. This will select all bars in that series (e.g., all "Retail Sales - Product B" bars).
• Right-click the selected bars and choose Format Data Series...
• In the pane that opens, go to the Fill & Line tab (the paint bucket icon).
• Under Fill, choose a new color.
• Repeat this process for the other series until your color scheme is consistent and easy to follow.

With those adjustments, you'll have a finished, professional-looking clustered stacked column chart, ready for any report or presentation.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Final Thoughts

Creating a combination clustered and stacked chart in Excel is an effective way to showcase complex data relationships in a single, digestible visual. The technique feels a bit like a workaround, but it all comes down to setting up your data correctly with a blank spacer column to create the necessary gaps.

Mastering these chart types is a fantastic skill, but we know that structuring the data and manually formatting the output still takes time. At Graphed, we’ve built tools to automate this entire reporting process. You can connect datasets like Google Analytics or your Shopify store, and then simply ask, "Create a chart comparing sales this quarter by product and channel." We handle the chart creation instantly, building live dashboards so you spend less time wrestling with spreadsheets and more time acting on your insights.