Google Sheets: Create a Clustered Stacked Bar Chart


A clustered stacked bar chart is a type of bar chart that is both clustered and stacked.

It’s particularly useful for visualizing data values that have multiple groups and span several time periods.

This tutorial provides a step-by-step example of how to create the following clustered stacked bar chart in Google Sheets:

Google Sheets clustered stacked bar chart

Step 1: Enter the Data

First, let’s enter the following dataset that shows the sales of various products at different retail stores during different years:

Step 2: Create the Clustered Stacked Bar Chart

Next, highlight the cell range C1:E16, then click the Insert tab along the top ribbon, then click Insert, then click Chart:

In the Chart editor panel that appears on the right side of the screen, choose Stacked column chart as the chart type:

The following clustered stacked bar chart will appear:

Step 3: Customize the Clustered Stacked Bar Chart

Next, we need to insert custom labels on the x-axis.

To do so, click the Setup tab in the Chart editor, then click Add X-axis, then click the tiny grid icon:

Then type B1:B15 as the data range and click OK:

Then click the three vertical dots next to the X-axis range and then click Add labels:

Then type A1:A15 as the data range and click OK:

The following labels will be added to the chart:

Lastly, feel free to add a title and move the legend to the bottom of the chart:

Google Sheets clustered stacked bar chart

The clustered stacked bar chart is now complete.

The sales at each store are clustered by year and the specific fruit categories are stacked based on store location.

Additional Resources

The following tutorials explain how to create other common visualizations in Google Sheets:

How to Create a Stacked Bar Chart in Google Sheets
How to Create a Double Bar Graph in Google Sheets
How to Add Error Bars to Charts in Google Sheets

Leave a Reply

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