{"id":17715,"date":"2025-03-10T08:12:08","date_gmt":"2025-03-10T03:12:08","guid":{"rendered":"https:\/\/chartexpo.com\/blog\/?p=17715"},"modified":"2025-12-19T18:28:42","modified_gmt":"2025-12-19T13:28:42","slug":"how-to-make-a-stacked-bar-chart-in-google-sheets","status":"publish","type":"post","link":"https:\/\/chartexpo.com\/blog\/how-to-make-a-stacked-bar-chart-in-google-sheets","title":{"rendered":"How to Make a Stacked Bar Chart in Google Sheets?"},"content":{"rendered":"<p>Data visualization is the go-to method when you want quick insights into your raw data. However, not any type of visualization design can be used in your data storytelling.<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"size-full wp-image-4345 aligncenter\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/how-to-make-a-stacked-bar-chart-in-google-sheets.jpg\" alt=\"how to make a stacked bar chart in google sheets\" width=\"650\"><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbyswMDgr\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/10\/bar-chart-generator-in-google-sheets-2.jpg\" alt=\"\" width=\"319\" height=\"149\"><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbyswMDgr\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/10\/bar-chart-generator-in-excel-2.jpg\" alt=\"\" width=\"319\" height=\"149\"><\/a><\/div>\n<p>Some charts are designed to visualize information in an exploratory way. Others are designed to display the composition of sub-variables contributing to the whole of your data.<\/p>\n<p>So if your goal is to display part-to-whole relationships in your data, your go-to chart should be the Stacked Bar Chart.<\/p>\n<p>Popular and widely used visualization tools, such as Google Sheets, lack ready-made Charts.<\/p>\n<p>But you can transform the spreadsheet into a reliable tool by installing third-party add-ons to access <em>visually appealing and how to make <\/em>Stacked Bar charts in Google Sheets.<\/p>\n<p>In this blog, you&#8217;ll learn:<\/p>\n<h3>Table of Content:<\/h3>\n<ol>\n<li><a href=\"#what-is-a-stacked-bar-chart-in-google-sheets\">What is a Stacked Bar Chart in Google Sheets?<\/a><\/li>\n<li><a href=\"#video-tutorial\">Video Tutorial: How to Make a Stacked Bar Chart in Google Sheets<\/a><\/li>\n<li><a href=\"#what-does-google-sheets-stacked-bar-chart-look-like\">What Does a Google Sheets Stacked Bar Chart Look Like?<\/a><\/li>\n<li><a href=\"#how-to-create-stacked-bar-chart-in-google-sheets\">How To Create a Stacked Bar Chart in Google Sheets?<\/a>\n<ul>\n<li><a href=\"#step-1-prepare-your-data\">Step 1: Prepare Your Data<\/a><\/li>\n<li><a href=\"#step-2-select-the-data-for-your-stacked-bar-chart\">Step 2: Select the Data for Your Stacked Bar Chart<\/a><\/li>\n<li><a href=\"#step-3-choose-and-insert-a-chart\">Step 3: Choose and Insert a Chart<\/a><\/li>\n<li><a href=\"#step-4-customize-your-chart\">Step 4: Customize Your Chart<\/a><\/li>\n<li><a href=\"#step-5-stacked-bar-chart-created-successfully\">Step 5: Stacked Bar Chart Created Successfully!<\/a><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"#stacked-bar-chart-in-google-sheets-using-add-in\">How to Make a Stacked Bar Chart in Google Sheets Using ChartExpo Add-in?<\/a>\n<ul>\n<li><a href=\"#step-1-install-the-chartexpo-in-google-sheets\">Step 1: Install the ChartExpo in Google Sheets<\/a><\/li>\n<li><a href=\"#step-2-add-new-chart\">Step 2: Add New Chart<\/a><\/li>\n<li><a href=\"#step-3-select-a-chart-template\">Step 3: Select a Chart Template<\/a><\/li>\n<li><a href=\"#step-4-export-data-select-stacked-bar-chart\">Step 4: Export Data &amp; Select Stacked Bar Chart<\/a><\/li>\n<li><a href=\"#step-5-select-data-add-metrics-dimensions\">Step 5: Select Data, Add Metrics &amp; Dimensions<\/a><\/li>\n<li><a href=\"#step-6-click-create-chart-to-finish\">Step 6: Click &#8220;Create Chart&#8221; to Finish<\/a><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"#advantages-of-stacked-bar-chart-in-google-sheets\">Advantages of Stacked Bar Chart in Google Sheets<\/a><\/li>\n<li><a href=\"#faqs\">FAQs About Stacked Bar Chart in Google Sheets<\/a><\/li>\n<li><a href=\"#wrap-up\">Wrap Up<\/a><\/li>\n<\/ol>\n<p>Before we delve right into the how-to guide, let&#8217;s define the chart we&#8217;ll be talking about throughout the blog.<\/p>\n<h2 id=\"what-is-a-stacked-bar-chart-in-google-sheets\">What is a Stacked Bar Chart in Google Sheets?<\/h2>\n<p><strong>Definition:<\/strong> A Stacked Bar Chart is a variant of the <a href=\"https:\/\/chartexpo.com\/charts\/bar-charts\" target=\"_blank\" rel=\"noopener noreferrer\">Bar Graphs<\/a> you can use to compare individual data points relative to aggregate values.<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"size-full wp-image-4345 aligncenter\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/what-is-a-stacked-bar-chart-008.jpg\" alt=\"what is a stacked bar chart 008\" width=\"650\"><\/div>\n<p>A typical Bar Chart compares individual data points. Conversely, in a Stacked Bar Chart, each bar is divided into several sub-bars stacked end to end. More so, each subsection in the bars has the same color to make formatting easier.<\/p>\n<p>The chart allows you to see even minor changes in key variables in your data points. Use a Stacked Bar Chart if your goal is to compare key variables in your raw data.<\/p>\n<h2 id=\"video-tutorial\">Video Tutorial: How to Make a Stacked Bar Chart in Google Sheets<\/h2>\n<p><iframe title=\"YouTube video player\" src=\"https:\/\/www.youtube.com\/embed\/T9anzgp9qRg?si=t7h-G0RbVmdxwLeg\" width=\"650\" height=\"365\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<h2 id=\"what-does-google-sheets-stacked-bar-chart-look-like\">What Does a Google Sheets Stacked Bar Chart Look Like?<\/h2>\n<p>A <strong>Stacked Bar Chart<\/strong> in Google Sheets uses bars to display key data points across a range of different dimensional values.<\/p>\n<p>Take a look at the tabular data below. Can you provide insights into the data without taking significant amounts of time?<\/p>\n<table class=\"static\" style=\"table-layout: fixed; overflow-x: auto; border: 1px; font-size: 17px;\">\n<tbody>\n<tr>\n<td width=\"351\"><strong>Subjects<\/strong><\/td>\n<td width=\"102\"><strong>2018<\/strong><\/td>\n<td width=\"84\"><strong>2019<\/strong><\/td>\n<td width=\"90\"><strong>2020<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"351\">Mathematics<\/td>\n<td width=\"102\">60<\/td>\n<td width=\"84\">80<\/td>\n<td width=\"90\">90<\/td>\n<\/tr>\n<tr>\n<td width=\"351\">Chemistry<\/td>\n<td width=\"102\">75<\/td>\n<td width=\"84\">50<\/td>\n<td width=\"90\">40<\/td>\n<\/tr>\n<tr>\n<td width=\"351\">Physics<\/td>\n<td width=\"102\">60<\/td>\n<td width=\"84\">70<\/td>\n<td width=\"90\">75<\/td>\n<\/tr>\n<tr>\n<td width=\"351\">Computer<\/td>\n<td width=\"102\">70<\/td>\n<td width=\"84\">60<\/td>\n<td width=\"90\">50<\/td>\n<\/tr>\n<tr>\n<td width=\"351\">Biology<\/td>\n<td width=\"102\">80<\/td>\n<td width=\"84\">50<\/td>\n<td width=\"90\">45<\/td>\n<\/tr>\n<tr>\n<td width=\"351\">English<\/td>\n<td width=\"102\">50<\/td>\n<td width=\"84\">75<\/td>\n<td width=\"90\">80<\/td>\n<\/tr>\n<tr>\n<td width=\"351\">Arts<\/td>\n<td width=\"102\">70<\/td>\n<td width=\"84\">50<\/td>\n<td width=\"90\">45<\/td>\n<\/tr>\n<tr>\n<td width=\"351\">Economics<\/td>\n<td width=\"102\">80<\/td>\n<td width=\"84\">60<\/td>\n<td width=\"90\">70<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Now, note the difference after visualizing the data using this chart.<\/p>\n<p>We hope you&#8217;ll note why we use this chart to visualize data with more than two numerical columns.<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"size-full wp-image-4345 aligncenter\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/stacked-bar-chart-in-google-sheets-008.jpg\" alt=\"stacked bar chart in google sheets 008 \" width=\"650\"><\/div>\n<p>Let&#8217;s take a look at a different example. Can you provide a meaningful conclusion from the data set below?<\/p>\n<table class=\"static\" style=\"table-layout: fixed; overflow-x: auto; border: 1px; font-size: 17px;\">\n<tbody>\n<tr>\n<td width=\"213\"><strong>Class<\/strong><\/td>\n<td width=\"180\"><strong>Subjects<\/strong><\/td>\n<td width=\"66\"><strong>2018<\/strong><\/td>\n<td width=\"72\"><strong>2019<\/strong><\/td>\n<td width=\"78\"><strong>2020<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"213\">Grade-7<\/td>\n<td width=\"180\">Mathematics<\/td>\n<td width=\"66\">20<\/td>\n<td width=\"72\">20<\/td>\n<td width=\"78\">50<\/td>\n<\/tr>\n<tr>\n<td width=\"213\">Grade-8<\/td>\n<td width=\"180\">Mathematics<\/td>\n<td width=\"66\">15<\/td>\n<td width=\"72\">40<\/td>\n<td width=\"78\">20<\/td>\n<\/tr>\n<tr>\n<td width=\"213\">Grade-9<\/td>\n<td width=\"180\">Mathematics<\/td>\n<td width=\"66\">25<\/td>\n<td width=\"72\">20<\/td>\n<td width=\"78\">20<\/td>\n<\/tr>\n<tr>\n<td width=\"213\">Grade-7<\/td>\n<td width=\"180\">Computer<\/td>\n<td width=\"66\">40<\/td>\n<td width=\"72\">10<\/td>\n<td width=\"78\">10<\/td>\n<\/tr>\n<tr>\n<td width=\"213\">Grade-8<\/td>\n<td width=\"180\">Computer<\/td>\n<td width=\"66\">20<\/td>\n<td width=\"72\">20<\/td>\n<td width=\"78\">15<\/td>\n<\/tr>\n<tr>\n<td width=\"213\">Grade-9<\/td>\n<td width=\"180\">Computer<\/td>\n<td width=\"66\">10<\/td>\n<td width=\"72\">30<\/td>\n<td width=\"78\">25<\/td>\n<\/tr>\n<tr>\n<td width=\"213\">Grade-7<\/td>\n<td width=\"180\">Arts<\/td>\n<td width=\"66\">20<\/td>\n<td width=\"72\">20<\/td>\n<td width=\"78\">15<\/td>\n<\/tr>\n<tr>\n<td width=\"213\">Grade-8<\/td>\n<td width=\"180\">Arts<\/td>\n<td width=\"66\">30<\/td>\n<td width=\"72\">10<\/td>\n<td width=\"78\">10<\/td>\n<\/tr>\n<tr>\n<td width=\"213\">Grade-9<\/td>\n<td width=\"180\">Arts<\/td>\n<td width=\"66\">20<\/td>\n<td width=\"72\">20<\/td>\n<td width=\"78\">20<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>You&#8217;ll agree when we say that raw data is better served when visualized with easy-to-interpret visualization designs, such as the <a href=\"https:\/\/chartexpo.com\/blog\/stacked-bar-diagram\" target=\"_blank\" rel=\"noopener noreferrer\">Stacked Bar Diagram<\/a>.<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"size-full wp-image-4345 aligncenter\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/stacked-bar-graph-in-google-sheets-008.jpg\" alt=\"stacked bar graph in google sheets 008 \" width=\"650\"><\/div>\n<p>Check out our final example below. How convenient is it for you to tell a story from the tabular data below?<\/p>\n<table class=\"static\" style=\"table-layout: fixed; overflow-x: auto; border: 1px; font-size: 17px;\">\n<tbody>\n<tr>\n<td width=\"97\"><strong>Teacher<\/strong><\/td>\n<td width=\"114\"><strong>Class<\/strong><\/td>\n<td width=\"132\"><strong>Subjects<\/strong><\/td>\n<td width=\"78\"><strong>2018<\/strong><\/td>\n<td width=\"96\"><strong>2019<\/strong><\/td>\n<td width=\"96\"><strong>2020<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"97\">Abe<\/td>\n<td width=\"114\">Grade-7<\/td>\n<td width=\"132\">Mathematics<\/td>\n<td width=\"78\">20<\/td>\n<td width=\"96\">20<\/td>\n<td width=\"96\">50<\/td>\n<\/tr>\n<tr>\n<td width=\"97\">Abe<\/td>\n<td width=\"114\">Grade-8<\/td>\n<td width=\"132\">Mathematics<\/td>\n<td width=\"78\">15<\/td>\n<td width=\"96\">40<\/td>\n<td width=\"96\">20<\/td>\n<\/tr>\n<tr>\n<td width=\"97\">Abe<\/td>\n<td width=\"114\">Grade-9<\/td>\n<td width=\"132\">Mathematics<\/td>\n<td width=\"78\">25<\/td>\n<td width=\"96\">20<\/td>\n<td width=\"96\">20<\/td>\n<\/tr>\n<tr>\n<td width=\"97\">Bif<\/td>\n<td width=\"114\">Grade-7<\/td>\n<td width=\"132\">Computer<\/td>\n<td width=\"78\">40<\/td>\n<td width=\"96\">10<\/td>\n<td width=\"96\">10<\/td>\n<\/tr>\n<tr>\n<td width=\"97\">Bif<\/td>\n<td width=\"114\">Grade-8<\/td>\n<td width=\"132\">Computer<\/td>\n<td width=\"78\">20<\/td>\n<td width=\"96\">20<\/td>\n<td width=\"96\">15<\/td>\n<\/tr>\n<tr>\n<td width=\"97\">Bif<\/td>\n<td width=\"114\">Grade-9<\/td>\n<td width=\"132\">Computer<\/td>\n<td width=\"78\">10<\/td>\n<td width=\"96\">30<\/td>\n<td width=\"96\">25<\/td>\n<\/tr>\n<tr>\n<td width=\"97\">Ann<\/td>\n<td width=\"114\">Grade-7<\/td>\n<td width=\"132\">Arts<\/td>\n<td width=\"78\">20<\/td>\n<td width=\"96\">20<\/td>\n<td width=\"96\">15<\/td>\n<\/tr>\n<tr>\n<td width=\"97\">Ann<\/td>\n<td width=\"114\">Grade-8<\/td>\n<td width=\"132\">Arts<\/td>\n<td width=\"78\">30<\/td>\n<td width=\"96\">10<\/td>\n<td width=\"96\">10<\/td>\n<\/tr>\n<tr>\n<td width=\"97\">Ann<\/td>\n<td width=\"114\">Grade-9<\/td>\n<td width=\"132\">Arts<\/td>\n<td width=\"78\">20<\/td>\n<td width=\"96\">20<\/td>\n<td width=\"96\">20<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>After visualizing the data above, you can easily point out the most and least popular subjects among the students based on their enrollment rates.<\/p>\n<p>For instance, Mathematics was the most enrolled subject in 2020 among seventh graders.<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"size-full wp-image-4345 aligncenter\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/stacked-bar-in-google-sheets-008.jpg\" alt=\"stacked bar in google sheets 008\" width=\"650\"><\/div>\n<h2 id=\"how-to-create-stacked-bar-chart-in-google-sheets\">How To Create a Stacked Bar Chart in Google Sheets?<\/h2>\n<div>\n<h3 id=\"step-1-prepare-your-data\">Step 1: Prepare Your Data<\/h3>\n<p>Before creating your <a href=\"https:\/\/chartexpo.com\/blog\/stacked-bar-chart\" target=\"_blank\" rel=\"noopener\">stacked bar chart<\/a>, ensure your data is properly organized.<\/p>\n<h4>Step 1.1: Label the Headers<\/h4>\n<p>Label each column with appropriate headers to ensure data is well-organized.<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/stacked-bar-chart-1.jpg\" alt=\"Stacked Bar Chart 1\" width=\"650\"><\/div>\n<h4>Step 1.2: Add Your Data<\/h4>\n<p>Enter the relevant data into your Google Sheets.<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/stacked-bar-chart-2.jpg\" alt=\"Stacked Bar Chart 2\" width=\"650\"><\/div>\n<h4>Step 1.3: Verify Data Format<\/h4>\n<p>Ensure all data entries are formatted correctly for accurate chart visualization.<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/stacked-bar-chart-3.jpg\" alt=\"Stacked Bar Chart 3\" width=\"650\"><\/div>\n<h3 id=\"step-2-select-the-data-for-your-stacked-bar-chart\">Step 2: Select the Data for Your Stacked Bar Chart<\/h3>\n<p>Highlight the data range you want to represent in your stacked bar chart.<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/stacked-bar-chart-4.jpg\" alt=\"Stacked Bar Chart 4\" width=\"650\"><\/div>\n<h3 id=\"step-3-choose-and-insert-a-chart\">Step 3: Choose and Insert a Chart<\/h3>\n<h4>Step 3.1: Insert a Chart<\/h4>\n<p>In the toolbar, click on &#8220;Insert&#8221; and then choose &#8220;Chart&#8221; to add one to your sheet.<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/stacked-bar-chart-5.jpg\" alt=\"Stacked Bar Chart 5\" width=\"650\"><\/div>\n<h4>Step 3.2: Choose the Chart Type<\/h4>\n<p>In the chart editor, select &#8220;Stacked Bar Chart&#8221; as the chart type.<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/stacked-bar-chart-6.jpg\" alt=\"Stacked Bar Chart 6\" width=\"650\"><\/div>\n<h4>Step 3.3: Modify the Placement of Your Chart<\/h4>\n<p>Drag and resize the chart to fit your workspace.<\/p>\n<h3 id=\"step-4-customize-your-chart\">Step 4: Customize Your Chart<\/h3>\n<h4>Step 4.1: Open the Chart Editor<\/h4>\n<p>Click on the chart to open the editor for customization.<\/p>\n<h4>Step 4.2: Navigate to the Customization Tab<\/h4>\n<p>Go to the &#8220;Customize&#8221; tab in the chart editor to personalize the appearance.<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/09\/stacked-bar-chart-8.jpg\" alt=\"Stacked Bar Chart 8\" width=\"350\"><\/div>\n<h4>Step 4.3: Customize Chart and Axis Titles<\/h4>\n<p>Add or modify the titles to make the chart more informative.<\/p>\n<h4>Step 4.4: Customize the Legend<\/h4>\n<p>Edit the legend&#8217;s placement and style for better clarity.<\/p>\n<h4>Step 4.5: Personalize the Color of Each Data Series<\/h4>\n<p>Adjust the colors for each series to improve the visual differentiation.<\/p>\n<h3 id=\"step-5-stacked-bar-chart-created-successfully\">Step 5: Stacked Bar Chart Created Successfully!<\/h3>\n<p>Your stacked bar chart is now complete and ready for use, providing a clear visual summary of your data.<\/p>\n<\/div>\n<h2 id=\"stacked-bar-chart-in-google-sheets-using-add-in\">How to Make a Stacked Bar Chart in Google Sheets Using ChartExpo Add-in?<\/h2>\n<p>Data visualization designs, such as Stacked Bar Charts in Google Sheets, make it easier for business owners and professionals to make reliable decisions. Google Sheets has built-in charts you can use to extract answers from your data.<\/p>\n<p>However, you&#8217;ll never find a ready-to-use simple Stacked Bar or a <a href=\"https:\/\/chartexpo.com\/blog\/clustered-stacked-bar-chart\" target=\"_blank\" rel=\"noopener noreferrer\"><span data-sheets-root=\"1\">Clustered Stacked Bar Chart<\/span><\/a> in Google Sheets for your analysis. The most viable option available for you is installing a particular third-party add-on (we&#8217;ll talk about it later) to access ready-made graphs.<\/p>\n<p>You don&#8217;t need to replace Google Sheets with other expensive tools.<\/p>\n<p>We recommend\u00a0<span style=\"box-sizing: border-box; margin: 0px; padding: 0px;\">trying the ChartExpo\u00a0<a href=\"https:\/\/chartexpo.com\/tools\/google-sheets\" target=\"_blank\" rel=\"noopener\">add-on for Google Sheets<\/a> for<\/span>\u00a0the reasons listed below.<\/p>\n<p>ChartExpo does not require coding or programming skills, unlike other <a href=\"https:\/\/chartexpo.com\/blog\/data-visualization-guide\" target=\"_blank\" rel=\"noopener noreferrer\">data visualization<\/a>-based add-ons. More so, it has an ultra-friendly user interface (UI) for everyone to use.<\/p>\n<p>This tool comes pre-loaded with many advanced charts to offset the missing ones in Google Sheets. Use ChartExpo to produce charts that are incredibly <strong>easy to read and understand<\/strong>.<\/p>\n<p>Use ChartExpo to overcome this. You&#8217;ll learn more about this cutting-edge tool in the next section.<\/p>\n<p><strong>So what is ChartExpo?<\/strong><\/p>\n<p data-start=\"48\" data-end=\"325\">ChartExpo comes as an add-on for Google Sheets. Essentially, it turns your Google Sheets into a usable <a href=\"https:\/\/chartexpo.com\/blog\/best-tools-for-data-visualization\" target=\"_blank\" rel=\"noopener\">data visualization tool<\/a> capable of delivering hidden insights into your data, including creating a <a href=\"https:\/\/chartexpo.com\/charts\/pareto-chart\" target=\"_blank\" rel=\"noopener\">Pareto chart in Google Sheets<\/a>, irrespective of the size or complexity.<\/p>\n<p data-start=\"327\" data-end=\"402\">The premium Stacked Bar graph maker comes with a 7-day free trial period.<\/p>\n<p data-start=\"404\" data-end=\"606\" data-is-last-node=\"\" data-is-only-node=\"\">The key benefit of ChartExpo is the fact that it produces charts that are easy to read and interpret. More so, it allows you to save charts in the world&#8217;s most recognized formats, namely PNG and JPG.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbyswMDgr\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/10\/bar-chart-generator-in-google-sheets-3.jpg\" alt=\"\" width=\"319\" height=\"149\"><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbyswMDgr\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/10\/bar-chart-generator-in-excel-3.jpg\" alt=\"\" width=\"319\" height=\"149\"><\/a><\/div>\n<h3 id=\"step-1-install-the-chartexpo-in-google-sheets\">Step 1: Install the <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbyswMDgr\" target=\"_blank\" rel=\"noopener nofollow noreferrer\">ChartExpo in Google Sheets<\/a><\/h3>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/open-chartexpo-in-google-sheets.jpg\" alt=\"open chartexpo in google sheets\" width=\"650\"><\/div>\n<h3 id=\"step-2-add-new-chart\">Step 2: Add New Chart<\/h3>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/add-new-chart-in-google-sheets.jpg\" alt=\"add new chart in google sheets\" width=\"650\"><\/div>\n<h3 id=\"step-3-select-a-chart-template\">Step 3: Select a Chart Template<\/h3>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/list-of-charts-graphs-google-sheets.jpg\" alt=\"list of charts graphs google sheets\" width=\"650\"><\/div>\n<h3 id=\"step-4-export-data-select-stacked-bar-chart\">Step 4: Export Data &amp; Select Stacked Bar Chart<\/h3>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"size-full wp-image-4345 aligncenter\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/search-stacked-bar-chart-in-google-sheets-008.jpg\" alt=\"search stacked bar chart in google sheets 008\" width=\"650\"><\/div>\n<h3 id=\"step-5-select-data-add-metrics-dimensions\">Step 5: Select Data, Add Metrics &amp; Dimensions<\/h3>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"size-full wp-image-4345 aligncenter\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/select-stacked-bar-chart-in-google-sheets-008.jpg\" alt=\"select stacked bar chart in google sheets 008\" width=\"650\"><\/div>\n<h3 id=\"step-6-click-create-chart-to-finish\">Step 6: Click &#8220;Create Chart&#8221; to Finish<\/h3>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"size-full wp-image-4345 aligncenter\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/create-stacked-bar-chart-in-google-sheets-008.jpg\" alt=\"create stacked bar chart in google sheets 008\" width=\"650\"><\/div>\n<p>You can customize the chart by clicking on the <strong>Edit Chart<\/strong> button as shown above. How to make this chart in Google Sheets is not complex. ChartExpo makes the whole process seamless and easy.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbyswMDgr\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/10\/bar-chart-generator-in-google-sheets-2.jpg\" alt=\"\" width=\"319\" height=\"149\"><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbyswMDgr\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/10\/bar-chart-generator-in-excel-2.jpg\" alt=\"\" width=\"319\" height=\"149\"><\/a><\/div>\n<ul>\n<li>Add a title to your chart<\/li>\n<li>Click the <strong>Edit Chart <\/strong>button to get started.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"size-full wp-image-4345 aligncenter\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/edit-stacked-bar-chart-in-google-sheets-1-008.jpg\" alt=\"edit stacked bar chart in google sheets 1\" width=\"650\"><\/div>\n<ul>\n<li>Once the <strong>Chart Header Properties window<\/strong> shows, click the <strong>Line 1 <\/strong>button and fill in your heading.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"size-full wp-image-4345 aligncenter\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/edit-stacked-bar-chart-in-google-sheets-2-008.jpg\" alt=\"edit stacked bar chart in google sheets 2\" width=\"650\"><\/div>\n<ul>\n<li>Complete the simple process by <strong>c<\/strong>licking the <strong>Apply <\/strong>and the<strong> Save <\/strong>buttons, respectively, as shown above.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"size-full wp-image-4345 aligncenter\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/edit-stacked-bar-chart-in-google-sheets-3-008.jpg\" alt=\"edit stacked bar chart in google sheets 3\" width=\"650\"><\/div>\n<p>To change the legend of the Stacked Bar Chart, follow the simple steps below.<\/p>\n<ul>\n<li>Click the <strong>Settings <\/strong>button, as shown below.<\/li>\n<li>Once the <strong>Chart Setting drop-down<\/strong> pops up, click the <strong>Misc <\/strong>button<strong>.<\/strong><\/li>\n<li>Select either <strong>Value Base or Percentage Base<\/strong> in the drop-down menu.<\/li>\n<li>Complete the process by clicking the <strong>Apply <\/strong>button<strong>.<\/strong><\/li>\n<\/ul>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"size-full wp-image-4345 aligncenter\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/edit-stacked-bar-chart-in-google-sheets-4-008.jpg\" alt=\"edit stacked bar chart in google sheets 4\" width=\"650\"><\/div>\n<ul>\n<li>To add a percentage sign on the chart, follow the steps below:<\/li>\n<li>To change the chart&#8217;s legend, click the<strong> Edit Chart <\/strong>button, as shown below.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"size-full wp-image-4345 aligncenter\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/edit-stacked-bar-chart-in-google-sheets-5-008.jpg\" alt=\"edit stacked bar chart in google sheets 5\" width=\"650\"><\/div>\n<ul>\n<li>Once the <strong>Bar &amp; label properties window<\/strong> shows, click either <strong>Prefix or Postfix<\/strong> to add your legends.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/edit-stacked-bar-chart-in-google-sheets-6-008.jpg\" alt=\"edit stacked bar chart in google sheets 6\" width=\"650\"><\/div>\n<ul>\n<li>Complete the process by clicking the<strong> Apply All <\/strong>button<strong>.<\/strong><\/li>\n<\/ul>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/stacked-bar-chart-in-chartexpo-google-sheets-008.jpg\" alt=\"stacked bar chart in chartexpo google sheets 008 \" width=\"650\"><\/div>\n<p>Take advantage of ChartExpo to supercharge your Google Sheets today. You can also use ChartExpo to <a href=\"https:\/\/chartexpo.com\/blog\/how-to-make-a-stacked-bar-chart-in-excel-with-multiple-data\" target=\"_blank\" rel=\"noopener noreferrer\">Create Stacked Bar Charts in Excel<\/a>.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbyswMDgr\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/10\/bar-chart-generator-in-google-sheets-3.jpg\" alt=\"\" width=\"319\" height=\"149\"><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbyswMDgr\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/10\/bar-chart-generator-in-excel-3.jpg\" alt=\"\" width=\"319\" height=\"149\"><\/a><\/div>\n<h2 id=\"advantages-of-stacked-bar-chart-in-google-sheets\">Advantages of Stacked Bar Chart in Google Sheets<\/h2>\n<h3>1.\u00a0<strong>Visualizes Part-to-Whole Relationships<\/strong><\/h3>\n<p>Stacked bar charts are perfect for showing how individual components contribute to the total value of a category. Each bar represents a total, and the segments within the bar display the proportion of each subcategory, making it easy to understand the composition of the data.<\/p>\n<h3>2.\u00a0<strong>Compares Multiple Categories and Subcategories<\/strong><\/h3>\n<p>They allow you to compare both the totals and the individual subcategories across different groups in a single chart. This is especially useful when analyzing data with multiple dimensions, such as sales by product and region.<\/p>\n<h3>3.\u00a0<strong>Efficient Use of Space<\/strong><\/h3>\n<p>Stacked bar charts display multiple data series in a single chart, saving space compared to using multiple standard bar charts. This makes them ideal for dashboards or reports with limited space.<\/p>\n<h3>4.\u00a0<strong>Highlights Trends Over Time<\/strong><\/h3>\n<p>When used with time-series data, stacked bar charts can effectively show how the composition of a total changes over time. For example, you can track monthly sales contributions from different product categories.<\/p>\n<h3>5.\u00a0<strong>Easy to Create and Customize in Google Sheets<\/strong><\/h3>\n<p>Google Sheets makes it simple to create and customize stacked bar charts. You can easily adjust colors, add data labels, and format axes to make the chart more informative and visually appealing.<\/p>\n<h2 id=\"faqs\">FAQs About Stacked Bar Chart in Google Sheets<\/h2>\n<h3>Why is a Bar Graph ineffective?<\/h3>\n<p>Bar Charts are ineffective because they provide general features of the data. Besides, they show very little about the data at a micro-level.<\/p>\n<p>They leave a lot to the imagination of the viewer. Visualizing continuous data types using Bar Charts is challenging compared to ordinal and nominal types.<\/p>\n<h3>Are Bar Charts categorical or quantitative?<\/h3>\n<p>Bar Charts are best suited to <a href=\"https:\/\/chartexpo.com\/blog\/best-graphs-for-categorical-data\" target=\"_blank\" rel=\"noopener noreferrer\">visualize categorical data<\/a> due to their simplicity and general structure. You can use the graph if your goal is to display the comparison insights into categorical data types.<\/p>\n<p>To make your charts easier to interpret, use highly contrasting colors to create a variation effect.<\/p>\n<h4 id=\"wrap-up\">Wrap Up<\/h4>\n<p>Visualizing data with more than two columns of numerical values is easier said than done.<\/p>\n<p>To succeed, you need the best-suited graph to extract reliable insights. In other words, you need this chart.<\/p>\n<p>Displaying hidden insights within sub-categories is one of the major reasons why we use charts in analysis.<\/p>\n<p>Google Sheets should not be your go-to visualization tool if you want to leverage the Stacked Bar Graph for in-depth insights. The application lacks <em>ready-to-use and visually appealing<\/em> charts.<\/p>\n<p>We recommend you install third-party apps, such as ChartExpo into your Google Sheets to access <em>ready-made and visually appealing charts<\/em>.<\/p>\n<p>ChartExpo is an add-on with <em>insightful and easy-to-interpret Stacked Bar Charts,<\/em> plus over 50 more visualization designs. You don&#8217;t require programming skills to visualize your data using the application.<\/p>\n<p>Sign up for a 7-day free trial today to access <em>ready-made and visually appealing<\/em> charts for your data story.<\/p>\n","protected":false},"excerpt":{"rendered":"<p><p>Learn how to create a stacked bar chart in Google Sheets with our step-by-step guide. Input data, select chart type, customize, and insert for insightful visualizations.<\/p>\n&nbsp;&nbsp;<a href=\"https:\/\/chartexpo.com\/blog\/how-to-make-a-stacked-bar-chart-in-google-sheets\"><\/a><\/p>","protected":false},"author":1,"featured_media":17854,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[743],"tags":[759],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>How to Make a Stacked Bar Chart in Google Sheets? -<\/title>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/chartexpo.com\/blog\/how-to-make-a-stacked-bar-chart-in-google-sheets\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:title\" content=\"How to Make a Stacked Bar Chart in Google Sheets? -\" \/>\r\n<meta name=\"twitter:description\" content=\"Learn how to create a stacked bar chart in Google Sheets with our step-by-step guide. Input data, select chart type, customize, and insert for insightful visualizations.\" \/>\r\n<meta name=\"twitter:image\" content=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/feature-008-200x200-1.jpg\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"16 minutes\" \/>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Make a Stacked Bar Chart in Google Sheets? -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/chartexpo.com\/blog\/how-to-make-a-stacked-bar-chart-in-google-sheets","twitter_card":"summary_large_image","twitter_title":"How to Make a Stacked Bar Chart in Google Sheets? -","twitter_description":"Learn how to create a stacked bar chart in Google Sheets with our step-by-step guide. Input data, select chart type, customize, and insert for insightful visualizations.","twitter_image":"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/feature-008-200x200-1.jpg","twitter_misc":{"Written by":"admin","Est. reading time":"16 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/chartexpo.com\/blog\/how-to-make-a-stacked-bar-chart-in-google-sheets","url":"https:\/\/chartexpo.com\/blog\/how-to-make-a-stacked-bar-chart-in-google-sheets","name":"How to Make a Stacked Bar Chart in Google Sheets? -","isPartOf":{"@id":"http:\/\/localhost\/blog\/#website"},"datePublished":"2025-03-10T03:12:08+00:00","dateModified":"2025-12-19T13:28:42+00:00","author":{"@id":"http:\/\/localhost\/blog\/#\/schema\/person\/6aceeb7c948a3f66ff6439ce5c24a280"},"breadcrumb":{"@id":"https:\/\/chartexpo.com\/blog\/how-to-make-a-stacked-bar-chart-in-google-sheets#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/chartexpo.com\/blog\/how-to-make-a-stacked-bar-chart-in-google-sheets"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/chartexpo.com\/blog\/how-to-make-a-stacked-bar-chart-in-google-sheets#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/localhost\/blog"},{"@type":"ListItem","position":2,"name":"How to Make a Stacked Bar Chart in Google Sheets?"}]},{"@type":"WebSite","@id":"http:\/\/localhost\/blog\/#website","url":"http:\/\/localhost\/blog\/","name":"","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/localhost\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"http:\/\/localhost\/blog\/#\/schema\/person\/6aceeb7c948a3f66ff6439ce5c24a280","name":"admin","url":"https:\/\/chartexpo.com\/blog\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/17715"}],"collection":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/comments?post=17715"}],"version-history":[{"count":44,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/17715\/revisions"}],"predecessor-version":[{"id":57118,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/17715\/revisions\/57118"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/media\/17854"}],"wp:attachment":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/media?parent=17715"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/categories?post=17715"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/tags?post=17715"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}