Excel: Create Stacked Bar Chart with Subcategories

Often you may want to create a stacked bar chart in Excel with subcategories.

This tutorial provides a step-by-step example of how to create the following stacked bar chart with subcategories:

Let’s jump in!

Step 1: Enter the Data

First, let’s create the following dataset that shows the total sales of four different products at three different locations for some store:

Step 2: Insert the Stacked Bar Chart

Next, highlight the cell range A1:E4 and then click the Insert tab along the top ribbon, then click the icon titled Stacked Bar within the Charts group:

The following stacked bar chart will appear:

Step 3: Switch Rows and Columns

Next, right click anywhere on the chart and click Select Data from the dropdown menu:

In the new window that appears, click the button called Switch Row/Columns and click OK:

The stores will now be displayed along the y-axis and the individual products will be shown as subcategories within the bars:

Step 4: Customize the Chart (Optional)

Feel free to add a title, customize the colors, and adjust the width of the bars to make the plot more aesthetically pleasing:

Additional Resources

The following tutorials explain how to perform other common tasks in Excel:

How to Show Percentages in Stacked Column Chart in Excel
How to Create a Clustered Stacked Bar Chart in Excel
How to Add Total Values to Stacked Bar Chart in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *