How To Make A Stacked Bar Chart In Google Sheets

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:

Step 1

The first column should contain labels for the main categories

Step 2

The following columns should contain the data corresponding to each subcategory you’d like to chart

Step 3

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:

Step 1

Select the data you want to chart, including the headers, and open the Insert menu, then choose Chart

Step 2

In the Chart Editor, under Chart Type, choose the Stacked Bar Chart option

Step 3

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

Step 4

The stacked bar chart will display as a floating element over the cells. Drag and drop to position it as needed

Summary

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.