Table of Contents
To create a stacked bar chart in Google Sheets, follow these steps:
1. Enter your data into a spreadsheet, with each category in a separate column and the corresponding values in the rows.
2. Select the data you want to include in the chart.
3. Click on the “Insert” tab and select “Chart” from the drop-down menu.
4. In the Chart Editor, under the “Chart type” section, select “Bar chart.”
5. Under the “Customize” tab, click on “Series.”
6. In the “Chart series” section, click on the drop-down menu next to “Chart type” and select “Stacked bar chart.”
7. Click “Save” to apply the changes and your stacked bar chart will be created.
This chart type is useful for visualizing and comparing data from multiple categories, as it allows for a clear representation of the total value for each category.
Create a Stacked Bar Chart in Google Sheets
A stacked bar chart is a type of chart that uses bars divided into a number of sub-bars to visualize the values of multiple variables at once.
The following step-by-step example shows how to create a stacked bar chart in Google Sheets.
Step 1: Enter Data
Suppose we send out a survey and ask 100 males and 100 females to choose their favorite sport between baseball, football, soccer, and basketball.
We can first enter the results of the survey in the following format:
Step 2: Create Stacked Bar Chart
To create a stacked bar chart to visualize this data, we can highlight the cells in the range A1:C5 and then click Insert and then click Chart:
A clustered bar chart will automatically appear.
To turn this into a stacked bar chart, click anywhere on the chart and then click on the three vertical dots in the top right corner, then click Edit:
In the Chart editor panel that appears on the right side of the screen, click the Stacking dropdown menu, then click Standard:
The chart will automatically be converted into a stacked bar chart:
Note: If you’d like each bar to add up to 100%, click the option that says 100% in the Stacking dropdown menu instead.
Step 3: Modify the Stacked Bar Chart
Feel free to click on individual elements in the chart to modify their appearance.
For example, we can change the title, the colors of the bars, and the location of the legend:
Additional Resources
The following tutorials explain how to create other common visualizations in Google Sheets:
Cite this article
stats writer (2024). How can I create a stacked bar chart in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-create-a-stacked-bar-chart-in-google-sheets/
stats writer. "How can I create a stacked bar chart in Google Sheets?." PSYCHOLOGICAL SCALES, 2 Jul. 2024, https://scales.arabpsychology.com/stats/how-can-i-create-a-stacked-bar-chart-in-google-sheets/.
stats writer. "How can I create a stacked bar chart in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-create-a-stacked-bar-chart-in-google-sheets/.
stats writer (2024) 'How can I create a stacked bar chart in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-create-a-stacked-bar-chart-in-google-sheets/.
[1] stats writer, "How can I create a stacked bar chart in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, July, 2024.
stats writer. How can I create a stacked bar chart in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.