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:
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:
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.
The following tutorials explain how to create other common visualizations in Google Sheets: