In this tutorial, you will learn how to make a stacked bar chart in google sheets.
A Stacked Bar Chart is a type of graph used to show the breakdown of categories into two or more subcategories. They’re a common data visualization because they’re easy to read and make it simple to understand the composition of datasets. They’re also one of the many built-in presets in Google Sheets, so it’s easy to add them to your spreadsheet in a few simple steps. Read on to learn how.
Prepping the Data
Before making the chart, ensure your data is arranged properly. Here’s how:
The first column should contain labels for the main categories
The following columns should contain the data corresponding to each subcategory you’d like to chart
Be sure to include headers at the top of the columns as these will appear as labels on the chart
Making the Stacked Bar Chart
Once your data is set up, here’s how to insert a stacked bar chart:
Select the data you want to chart, including the headers, and open the Insert menu, then choose Chart
In the Chart Editor, under Chart Type, choose the Stacked Bar Chart option
If your dataset contains multiple rows for each category, you may need to aggregate the data. Choose the label column from the dropdown under Y-axis and check the box to Aggregate the data based on that column
The stacked bar chart will display as a floating element over the cells. Drag and drop to position it as needed
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to make a stacked bar chart in google sheets. Want more? Check out all the Google Sheets Tutorials.