{"id":17638,"date":"2025-07-07T07:52:43","date_gmt":"2025-07-07T02:52:43","guid":{"rendered":"https:\/\/chartexpo.com\/blog\/?p=17638"},"modified":"2026-02-04T15:59:14","modified_gmt":"2026-02-04T10:59:14","slug":"how-to-make-a-stacked-bar-chart-in-excel-with-multiple-data","status":"publish","type":"post","link":"https:\/\/chartexpo.com\/blog\/how-to-make-a-stacked-bar-chart-in-excel-with-multiple-data","title":{"rendered":"How to Make a Stacked Bar Chart in Excel With Multiple Data?"},"content":{"rendered":"<p>Analyzing part-to-whole relationships of key variables within your data is easier said than done. The situation is further made worse by the increase in the size of data.<\/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-excel-with-multiple-data.jpg\" alt=\"how to make a stacked bar chart in excel with multiple data\" width=\"650\"><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbyswMDcr\" 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><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbyswMDcr\" 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><\/div>\n<p>You need a chart that&#8217;s primarily designed to help show comparison insights between categories within your data without clutter. Tables are not recommended, especially if the size of your data is enormous.<\/p>\n<p>In other words, you need a <em><strong>Stacked Bar Chart in Excel with multiple datasets<\/strong>.<\/em><\/p>\n<p>The visualization design can help you display how a variable is divided into smaller sub-variables. Each bar in a Stacked Bar Chart Excel represents the whole. And the segments within the bars represent different parts that contribute to the whole.<\/p>\n<p>Data visualization tools, such as Excel, come with a pretty basic Excel Stacked Bar Chart. Essentially, you have to perform multiple customizations, which takes a significant amount of time.<\/p>\n<p>It turns out you can transform Excel into a reliable tool by installing a particular third-party add-on (we&#8217;ll talk about it later in the blog).<\/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-stacked-bar-chart-in-excel-with-multiple-data\">What is a Stacked Bar Chart in Excel With Multiple Data?<\/a><\/li>\n<li><a href=\"#video-tutorial-stacked-bar-chart-in-excel-with-multiple-data\">Video Tutorial: How to Make a Stacked Bar Chart in Excel With Multiple Data<\/a><\/li>\n<li><a href=\"#types-of-stacked-bar-charts-in-excel-with-multiple-data\">Types of Stacked Bar Charts in Excel With Multiple Data<\/a><\/li>\n<li><a href=\"#best-tool-to-create-stacked-bar-chart-in-excel-with-multiple-data\">Best Tool to Create a Stacked Bar Chart in Excel With Data<\/a><\/li>\n<li><a href=\"#how-to-create-stacked-bar-chart-in-excel-with-multiple-data\">How to Create a Stacked Bar Chart in Excel with Multiple Data?<\/a>\n<ul>\n<li><a href=\"#prepare-your-data-for-stacked-bar-chart-in-excel\">Step #1: Prepare your data<\/a><\/li>\n<li><a href=\"#insert-stacked-bar-chart-in-excel\">Step #2: Insert Stacked Bar Chart<\/a><\/li>\n<li><a href=\"#select-data-and-create-stacked-bar-chart-in-excel\">Step #3: Select Data &amp; Create Chart<\/a><\/li>\n<li><a href=\"#final-stacked-bar-chart-in-excel-with-multiple-data\">Step #4: Final Chart Below<\/a><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"#how-to-edit-stacked-bar-chart-in-excel-with-multiple-data\">How to Edit the Stacked Bar Chart in Excel With Multiple Data?<\/a><\/li>\n<li><a href=\"#why-analysts-use-excel-stacked-bar-chart-with-multiple-data\">Why Do Analysts use the Excel Stacked Bar Chart with Multiple Data?<\/a><\/li>\n<li><a href=\"#tips-for-using-stacked-bar-chart-in-excel-with-multiple-datasets\">Keep in Mind When Using a Stack Bar Chart in Excel With Multiple Datasets<\/a><\/li>\n<li><a href=\"#stacked-bar-chart-in-excel-with-multiple-data-faqs\">How to Create a Stacked Bar Chart in Excel With Multiple Data &#8211; FAQs<\/a><\/li>\n<li><a href=\"#wrap-up\">Wrap Up<\/a><\/li>\n<\/ol>\n<p>Before we dive right into the how-to guide, let&#8217;s define the visualization design.<\/p>\n<h2 id=\"what-is-stacked-bar-chart-in-excel-with-multiple-data\">What is a Stacked Bar Chart in Excel With Multiple Data?<\/h2>\n<p><strong>Definition<\/strong>: The Stacked Bar Chart in Excel with multiple data is essentially an extension of the standard <a href=\"https:\/\/chartexpo.com\/blog\/bar-chart\" target=\"_blank\" rel=\"noopener\">Bar Chart<\/a>. Each bar in this chart is divided into several sub-bars stacked end-to-end.<\/p>\n<div style=\"text-align: center;\">\n<p><img decoding=\"async\" class=\"aligncenter wp-image-4345 size-full\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/what-is-a-stacked-bar-chart-007.jpg\" alt=\"what is a stacked bar chart?\" width=\"464\" height=\"316\"><\/p>\n<\/div>\n<p>The Stacked <a href=\"https:\/\/chartexpo.com\/blog\/multiple-bar-graph-in-excel\" target=\"_blank\" rel=\"noopener noreferrer\">Bar Chart with multiple data<\/a> points is best suited for tracking the trends of key data points over time. Besides, it outperforms other visualization designs in displaying part-to-whole relationships. If we have negative and positive data series, then a Stacked waterfall chart in Excel becomes invaluable.<\/p>\n<p>This type of chart elegantly showcases the cumulative effect of both positive and negative values, offering a comprehensive view of the overall trend and the individual contributions of each data point<\/p>\n<p><em>Why?<\/em><\/p>\n<p>This chart is easy to read and interpret. Besides, it can handle bulky data without appearing cluttered. You can leverage the<a href=\"https:\/\/chartexpo.com\/blog\/segmented-bar-graph\" target=\"_blank\" rel=\"noopener noreferrer\"> Segmented Bar Graph<\/a> to display how the composition of the subcategories changes over time.<\/p>\n<p>How to make a Stacked Bar Chart in Excel with multiple data sets should never be a stressful or time-consuming affair. Keep reading to discover more.<\/p>\n<h2 id=\"video-tutorial-stacked-bar-chart-in-excel-with-multiple-data\">Video Tutorial: How to Make a Stacked Bar Chart in Excel With Multiple Data<\/h2>\n<p>In the following video, you will learn how to create a stacked bar chart in Excel with multiple groups:<\/p>\n<p><iframe title=\"YouTube video player\" src=\"https:\/\/www.youtube.com\/embed\/1R9ZOeKdwu0?si=SgYH1jVSeqvV5MZG\" width=\"650\" height=\"365\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\" data-mce-fragment=\"1\"><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<p>In the next section, we&#8217;ll explore the types of Stacked Bar Chart Excel with multiple datasets and how you can use them to gain more from your raw data.<\/p>\n<h2 id=\"types-of-stacked-bar-charts-in-excel-with-multiple-data\">Types of Stacked Bar Charts in Excel With Multiple Data<\/h2>\n<p>There are 3 different types of Stacked Bar Charts in Excel with multiple data, namely:<\/p>\n<ol>\n<li style=\"font-size: 25px; font-weight: 500;\">\n<h3>Simple Stacked Bars<\/h3>\n<\/li>\n<\/ol>\n<p>The Simple Stacked Bar chart places the absolute value of each subcategory after or over the previous one.<\/p>\n<p>You can use the graph to show the absolute value of each subcategory and its totals relative to the aggregate value of the category. To <a href=\"https:\/\/chartexpo.com\/blog\/how-to-make-a-graph-from-a-table\" target=\"_blank\" rel=\"noopener noreferrer\">create a graph from a table<\/a>, simply input your data and select the appropriate chart type. Usually, the bars will have varying heights or lengths.<\/p>\n<p>Like a typical Bar Chart, the bars in this visualization design can be oriented horizontally (with primary categories on the vertical axis) or vertically (with primary categories on the horizontal axis).<\/p>\n<p>Take a look at the tabular data below. Can you extract meaningful insights from the look of the table?<\/p>\n<table class=\"static\" style=\"table-layout: fixed; overflow-x: auto; border: 1px; font-size: 17px;\">\n<tbody>\n<tr>\n<td width=\"147\"><strong>Locations<\/strong><\/td>\n<td width=\"90\"><strong>Q1<\/strong><\/td>\n<td width=\"78\"><strong>Q2<\/strong><\/td>\n<td width=\"114\"><strong>Q3<\/strong><\/td>\n<td width=\"120\"><strong>Q4<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"147\">Boston<\/td>\n<td width=\"90\">825<\/td>\n<td width=\"78\">705<\/td>\n<td width=\"114\">421<\/td>\n<td width=\"120\">759<\/td>\n<\/tr>\n<tr>\n<td width=\"147\">Austin<\/td>\n<td width=\"90\">1026<\/td>\n<td width=\"78\">616<\/td>\n<td width=\"114\">510<\/td>\n<td width=\"120\">678<\/td>\n<\/tr>\n<tr>\n<td width=\"147\">Miami<\/td>\n<td width=\"90\">641<\/td>\n<td width=\"78\">617<\/td>\n<td width=\"114\">608<\/td>\n<td width=\"120\">392<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Now, note the difference after visualizing the data (above).<\/p>\n<div style=\"text-align: center;\">\n<p><img decoding=\"async\" class=\"aligncenter wp-image-4345 size-full\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/simple-stacked-bar-007..jpg\" alt=\"simple stacked Bar Chart \" width=\"618\" height=\"354\"><\/p>\n<\/div>\n<ol start=\"2\">\n<li style=\"font-size: 25px; font-weight: 500;\">\n<h3>Hierarchical Stacked Bar Chart<\/h3>\n<\/li>\n<\/ol>\n<p>Suppose variables in your data represent the whole that has been subdivided into parts across two major categorical variables. In this case, your go-to <a href=\"https:\/\/chartexpo.com\/blog\/hierarchical-data-visualization\" target=\"_blank\" rel=\"noopener noreferrer\"><span data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Hierarchical Data Visualization&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:60,&quot;5&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:0}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;6&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:0}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;7&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:0}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;8&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:0}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]}}\" data-sheets-formula=\"=Blogs!R[0]C[0]\">hierarchical data visualization <\/span><\/a>should be the <strong>Hierarchical Stacked Bar Chart.<\/strong><\/p>\n<p>A Hierarchical Stacked Bar Chart in Excel is made up of bars split into subcategories. Each of the primary bars may have a similar height but vary within subcategories. The aforementioned is easier, especially when <a href=\"https:\/\/chartexpo.com\/blog\/types-of-comparison-charts\" target=\"_blank\" rel=\"noopener noreferrer\">comparing multiple categories<\/a> for in-depth insights.<\/p>\n<p>Take a look at the data below. Can you extract meaningful insights without taking 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=\"153\"><strong>Locations<\/strong><\/td>\n<td width=\"96\"><strong>Brands<\/strong><\/td>\n<td width=\"66\"><strong>Q1<\/strong><\/td>\n<td width=\"90\"><strong>Q2<\/strong><\/td>\n<td width=\"102\"><strong>Q3<\/strong><\/td>\n<td width=\"120\"><strong>Q4<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"153\">Boston<\/td>\n<td width=\"96\">Mobile<\/td>\n<td width=\"66\">536<\/td>\n<td width=\"90\">399<\/td>\n<td width=\"102\">318<\/td>\n<td width=\"120\">475<\/td>\n<\/tr>\n<tr>\n<td width=\"153\">Boston<\/td>\n<td width=\"96\">TV<\/td>\n<td width=\"66\">289<\/td>\n<td width=\"90\">306<\/td>\n<td width=\"102\">103<\/td>\n<td width=\"120\">284<\/td>\n<\/tr>\n<tr>\n<td width=\"153\">Austin<\/td>\n<td width=\"96\">Mobile<\/td>\n<td width=\"66\">680<\/td>\n<td width=\"90\">431<\/td>\n<td width=\"102\">369<\/td>\n<td width=\"120\">509<\/td>\n<\/tr>\n<tr>\n<td width=\"153\">Austin<\/td>\n<td width=\"96\">TV<\/td>\n<td width=\"66\">346<\/td>\n<td width=\"90\">185<\/td>\n<td width=\"102\">141<\/td>\n<td width=\"120\">169<\/td>\n<\/tr>\n<tr>\n<td width=\"153\">Miami<\/td>\n<td width=\"96\">Mobile<\/td>\n<td width=\"66\">368<\/td>\n<td width=\"90\">439<\/td>\n<td width=\"102\">230<\/td>\n<td width=\"120\">279<\/td>\n<\/tr>\n<tr>\n<td width=\"153\">Miami<\/td>\n<td width=\"96\">TV<\/td>\n<td width=\"66\">273<\/td>\n<td width=\"90\">178<\/td>\n<td width=\"102\">378<\/td>\n<td width=\"120\">113<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Now, note the difference after visualizing the data (above).<\/p>\n<div style=\"text-align: center;\">\n<p><img decoding=\"async\" class=\"aligncenter wp-image-4345 size-full\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/hierarchical-stacked-bar-1-007.jpg\" alt=\"hierarchical stacked bar 1 \" width=\"607\" height=\"340\"><\/p>\n<\/div>\n<p>The key advantage of a Stacked Bar Chart Excel with multiple datasets is that you can display subcategories within bars without using extra charts.<\/p>\n<p>Take a look at the data below. Can you tell what&#8217;s going on without the aid of a chart?<\/p>\n<table class=\"static\" style=\"table-layout: fixed; overflow-x: auto; border: 1px; font-size: 17px;\">\n<tbody>\n<tr>\n<td width=\"123\"><strong>Locations<\/strong><\/td>\n<td width=\"126\"><strong>Products<\/strong><\/td>\n<td width=\"96\"><strong>Brands<\/strong><\/td>\n<td width=\"48\"><strong>Q1<\/strong><\/td>\n<td width=\"54\"><strong>Q2<\/strong><\/td>\n<td width=\"60\"><strong>Q3<\/strong><\/td>\n<td width=\"90\"><strong>Q4<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"123\">Boston<\/td>\n<td width=\"126\">Mobile<\/td>\n<td width=\"96\">Samsung<\/td>\n<td width=\"48\">274<\/td>\n<td width=\"54\">219<\/td>\n<td width=\"60\">152<\/td>\n<td width=\"90\">372<\/td>\n<\/tr>\n<tr>\n<td width=\"123\">Boston<\/td>\n<td width=\"126\">Mobile<\/td>\n<td width=\"96\">Xiaomi<\/td>\n<td width=\"48\">262<\/td>\n<td width=\"54\">180<\/td>\n<td width=\"60\">166<\/td>\n<td width=\"90\">103<\/td>\n<\/tr>\n<tr>\n<td width=\"123\">Boston<\/td>\n<td width=\"126\">TV<\/td>\n<td width=\"96\">LG<\/td>\n<td width=\"48\">289<\/td>\n<td width=\"54\">306<\/td>\n<td width=\"60\">103<\/td>\n<td width=\"90\">284<\/td>\n<\/tr>\n<tr>\n<td width=\"123\">Austin<\/td>\n<td width=\"126\">Mobile<\/td>\n<td width=\"96\">Samsung<\/td>\n<td width=\"48\">373<\/td>\n<td width=\"54\">292<\/td>\n<td width=\"60\">210<\/td>\n<td width=\"90\">193<\/td>\n<\/tr>\n<tr>\n<td width=\"123\">Austin<\/td>\n<td width=\"126\">Mobile<\/td>\n<td width=\"96\">Xiaomi<\/td>\n<td width=\"48\">307<\/td>\n<td width=\"54\">139<\/td>\n<td width=\"60\">159<\/td>\n<td width=\"90\">316<\/td>\n<\/tr>\n<tr>\n<td width=\"123\">Austin<\/td>\n<td width=\"126\">TV<\/td>\n<td width=\"96\">LG<\/td>\n<td width=\"48\">346<\/td>\n<td width=\"54\">185<\/td>\n<td width=\"60\">141<\/td>\n<td width=\"90\">169<\/td>\n<\/tr>\n<tr>\n<td width=\"123\">Miami<\/td>\n<td width=\"126\">Mobile<\/td>\n<td width=\"96\">Samsung<\/td>\n<td width=\"48\">219<\/td>\n<td width=\"54\">277<\/td>\n<td width=\"60\">128<\/td>\n<td width=\"90\">110<\/td>\n<\/tr>\n<tr>\n<td width=\"123\">Miami<\/td>\n<td width=\"126\">Mobile<\/td>\n<td width=\"96\">Xiaomi<\/td>\n<td width=\"48\">149<\/td>\n<td width=\"54\">162<\/td>\n<td width=\"60\">102<\/td>\n<td width=\"90\">169<\/td>\n<\/tr>\n<tr>\n<td width=\"123\">Miami<\/td>\n<td width=\"126\">TV<\/td>\n<td width=\"96\">LG<\/td>\n<td width=\"48\">273<\/td>\n<td width=\"54\">178<\/td>\n<td width=\"60\">378<\/td>\n<td width=\"90\">113<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Note the difference after using a visualization design to display insights into the tabular data (above).<\/p>\n<div style=\"text-align: center;\">\n<p><img decoding=\"async\" class=\"aligncenter wp-image-4345 size-full\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/hierarchical-stacked-bar-2-007.jpg\" alt=\"hierarchical stacked bar 2 \" width=\"608\" height=\"383\"><\/p>\n<\/div>\n<ol start=\"3\">\n<li style=\"font-size: 25px; font-weight: 500;\">\n<h3>Percentage Stacked Bar Chart<\/h3>\n<\/li>\n<\/ol>\n<p>Each primary bar in a Percentage Stacked Bar is scaled to have the same height. But its subcategories have varying heights depending on their respective numerical values.<\/p>\n<p>Each subcategory with a Percentage Bar Chart adds up to 100%<\/p>\n<p>The similar heights of each primary bar create a baseline at the top of the chart, which eases interpretation.<\/p>\n<p>How to make a Stacked Bar Chart in Excel with multiple data should never be a nerve-wracking affair. Keep reading to discover more.<\/p>\n<div style=\"text-align: center;\">\n<p><img decoding=\"async\" class=\"aligncenter wp-image-4345 size-full\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/percentage-stacked-bar-007.jpg\" alt=\"percentage stacked bar chart 007 \" width=\"607\" height=\"353\"><\/p>\n<\/div>\n<p>To get the most from the Stacked Bar Chart Excel with multiple data sets, incorporate high-contrast colors to ease interpretation. Avoid almost similar colors because they may distort the composition of the respective bars. Using a <a href=\"https:\/\/chartexpo.com\/blog\/how-to-make-a-multicolored-bar-graph-in-excel\" target=\"_blank\" rel=\"noopener noreferrer\">multicolored bar graph<\/a> helps you to understand data better.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbyswMDcr\" 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><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbyswMDcr\" 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><\/div>\n<p>Furthermore, numerical values should be indicated within or above each subcategory to facilitate comparison. In cases involving <a href=\"https:\/\/chartexpo.com\/blog\/multivariate-analysis\" target=\"_blank\" rel=\"noopener noreferrer\">Multivariate Analysis<\/a>, these annotations can be particularly helpful for understanding complex relationships. However, be sure to use them judiciously to avoid visual clutter<\/p>\n<h2 id=\"best-tool-to-create-stacked-bar-chart-in-excel-with-multiple-data\">Best Tool to Create a Stacked Bar Chart in Excel With Data<\/h2>\n<p>Excel has built-in charts you can use to extract insights from your raw data.<\/p>\n<p>How to create a stacked bar chart in Excel with multiple groups?<\/p>\n<p>However, you&#8217;ll never find a ready-to-use <a href=\"https:\/\/chartexpo.com\/blog\/stacked-bar-diagram\" target=\"_blank\" rel=\"noopener noreferrer\">Stacked Bar Diagram<\/a> with multiple datasets for your analysis. The most viable option available for you is to download and install a particular third-party add-in to access a ready-made Stacked Bar Graph Excel or the same as this <a href=\"https:\/\/chartexpo.com\/blog\/side-by-side-bar-chart\" target=\"_blank\" rel=\"noopener noreferrer\"><span data-sheets-root=\"1\" data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Side-By-Side Bar Graph&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:513,&quot;3&quot;:{&quot;1&quot;:0},&quot;12&quot;:0}\">Side-By-Side Bar graph in Excel<\/span><\/a>.<\/p>\n<p><em>You don&#8217;t have to ditch the spreadsheet tool that&#8217;s highly familiar to you.<\/em><\/p>\n<p>We recommend you try the ChartExpo <a href=\"https:\/\/chartexpo.com\/blog\/chart-add-in-for-excel\" target=\"_blank\" rel=\"noopener noreferrer\">add-in for Excel<\/a> for the reasons listed below.<\/p>\n<p><a href=\"https:\/\/chartexpo.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">ChartExpo<\/a> does not require coding or programming skills, unlike other <a href=\"https:\/\/chartexpo.com\/blog\/data-visualization-tools\" target=\"_blank\" rel=\"noopener noreferrer\">data visualization tools<\/a>. More so, it has an ultra-friendly UI for everyone to use.<\/p>\n<p>This tool comes pre-loaded with many <a href=\"https:\/\/chartexpo.com\/tools\/excel\" target=\"_blank\" rel=\"noopener\">Excel charts<\/a> to offset the missing ones in Excel. Use ChartExpo to produce charts that are incredibly easy to read and understand.<\/p>\n<p>How to make a Stacked Bar Chart in Excel with multiple datasets should never be time-consuming. 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>ChartExpo comes as an <a href=\"https:\/\/chartexpo.com\/blog\/add-ins-for-excel-mac\" target=\"_blank\" rel=\"noopener noreferrer\">add-in for Excel for Mac<\/a>.<\/p>\n<p>Essentially, it turns your Excel into a reliable data visualization tool capable of delivering hidden insights into your data, irrespective of the size or complexity.<\/p>\n<p>The premium <a href=\"https:\/\/chartexpo.com\/blog\/chart-maker\" target=\"_blank\" rel=\"noopener noreferrer\">Chart maker<\/a> comes with a 7-day free trial.<\/p>\n<p>The key benefit of ChartExpo is that it produces charts that are <em>easy to read and interpret<\/em>. More so, it allows you to save charts like <a href=\"https:\/\/chartexpo.com\/blog\/histogram\" target=\"_blank\" rel=\"noopener noreferrer\">Histogram<\/a> in the world&#8217;s most recognized formats, namely PNG and JPG.<\/p>\n<p>ChartExpo is cloud-hosted, which makes it extremely light. You have a 100% guarantee that your computer or Excel won&#8217;t be slowed down.<\/p>\n<p><strong>How to Install ChartExpo in Excel?<\/strong><\/p>\n<p>As we said, how to make a Stacked Bar Chart in Excel with multiple data should never be time-intensive. Use ChartExpo as your go-to tool to access ready-made charts for your data stories.<\/p>\n<p>You can directly install ChartExpo in Excel by clicking on the following link: \u201cCharts for Microsoft Excel\u201d.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbyswMDcr\" 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-1.jpg\" alt=\"\" width=\"319\" height=\"149\"><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbyswMDcr\" 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-1.jpg\" alt=\"\" width=\"319\" height=\"149\"><\/a><\/div>\n<p>Once it is successfully installed, to get started with ChartExpo, follow the\u00a0<em>steps<\/em> below.<\/p>\n<ul>\n<li>Open your Excel (2013 with SP1 or newer).<\/li>\n<li>Open the worksheet and click the\u00a0<strong>INSERT <\/strong>menu button<strong>.<\/strong><\/li>\n<li>Click the <strong>My Apps<\/strong>\u00a0and <strong>See All <\/strong>buttons<strong>, <\/strong>as shown below.<\/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\/insert-chartexpo-in-excel.jpg\" alt=\"insert chartexpo in excel\" width=\"650\"><\/div>\n<ul>\n<li>Click the\u00a0<strong>Insert <\/strong>button to install ChartExpo.<\/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\/open-chartexpo-in-excel.jpg\" alt=\"open chartexpo in excel\" width=\"650\"><\/div>\n<ul>\n<li>Log in with your Microsoft account or create a new account by clicking the <strong>Create New Account link.<\/strong><\/li>\n<li>Enter your newly created account and start using the ChartExpo add-in. You&#8217;re only required to\u00a0<em>log in for the first time<\/em>.<\/li>\n<li>Once successfully logged in, you will see the list of charts available in the ChartExpo add-in.<\/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\/list-of-charts-in-excel.jpg\" alt=\"list of charts in excel\" width=\"650\"><\/div>\n<ul>\n<li>You have two options to find the charts and graphs in ChartExpo&#8217;s expansive library.<\/li>\n<li><strong>Option #1<\/strong>: Click the Search button and type the name of the chart you&#8217;re looking for.<\/li>\n<li><strong>Option #2<\/strong>: You can sort the charts based on popularity or name in ascending or descending order and then find them by scrolling down the list.<\/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\/search-stacked-bar-chart-in-excel-007.jpg\" alt=\"search stacked bar chart in excel 007 \" width=\"650\"><\/div>\n<h2 id=\"how-to-create-stacked-bar-chart-in-excel-with-multiple-data\">How to Create a Stacked Bar Chart in Excel with Multiple Data?<\/h2>\n<p>We&#8217;ll visualize the table below using a <a href=\"https:\/\/chartexpo.com\/blog\/stacked-bar-chart\" target=\"_blank\" rel=\"noopener\"><strong>Stacked Bar Chart<\/strong><\/a> in ChartExpo.<\/p>\n<h3 id=\"prepare-your-data-for-stacked-bar-chart-in-excel\">Step #1: Prepare your data<\/h3>\n<table class=\"static\" style=\"table-layout: fixed; overflow-x: auto; border: 1px; font-size: 17px;\">\n<tbody>\n<tr>\n<td width=\"117\"><strong>Locations<\/strong><\/td>\n<td width=\"120\"><strong>Products<\/strong><\/td>\n<td width=\"108\"><strong>Brands<\/strong><\/td>\n<td width=\"60\"><strong>Q1<\/strong><\/td>\n<td width=\"66\"><strong>Q2<\/strong><\/td>\n<td width=\"66\"><strong>Q3<\/strong><\/td>\n<td width=\"84\"><strong>Q4<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"117\">Boston<\/td>\n<td width=\"120\">Mobile<\/td>\n<td width=\"108\">Samsung<\/td>\n<td width=\"60\">274<\/td>\n<td width=\"66\">219<\/td>\n<td width=\"66\">152<\/td>\n<td width=\"84\">372<\/td>\n<\/tr>\n<tr>\n<td width=\"117\">Boston<\/td>\n<td width=\"120\">Mobile<\/td>\n<td width=\"108\">Xiaomi<\/td>\n<td width=\"60\">262<\/td>\n<td width=\"66\">180<\/td>\n<td width=\"66\">166<\/td>\n<td width=\"84\">103<\/td>\n<\/tr>\n<tr>\n<td width=\"117\">Boston<\/td>\n<td width=\"120\">TV<\/td>\n<td width=\"108\">LG<\/td>\n<td width=\"60\">289<\/td>\n<td width=\"66\">306<\/td>\n<td width=\"66\">103<\/td>\n<td width=\"84\">284<\/td>\n<\/tr>\n<tr>\n<td width=\"117\">Austin<\/td>\n<td width=\"120\">Mobile<\/td>\n<td width=\"108\">Samsung<\/td>\n<td width=\"60\">373<\/td>\n<td width=\"66\">292<\/td>\n<td width=\"66\">210<\/td>\n<td width=\"84\">193<\/td>\n<\/tr>\n<tr>\n<td width=\"117\">Austin<\/td>\n<td width=\"120\">Mobile<\/td>\n<td width=\"108\">Xiaomi<\/td>\n<td width=\"60\">307<\/td>\n<td width=\"66\">139<\/td>\n<td width=\"66\">159<\/td>\n<td width=\"84\">316<\/td>\n<\/tr>\n<tr>\n<td width=\"117\">Austin<\/td>\n<td width=\"120\">TV<\/td>\n<td width=\"108\">LG<\/td>\n<td width=\"60\">346<\/td>\n<td width=\"66\">185<\/td>\n<td width=\"66\">141<\/td>\n<td width=\"84\">169<\/td>\n<\/tr>\n<tr>\n<td width=\"117\">Miami<\/td>\n<td width=\"120\">Mobile<\/td>\n<td width=\"108\">Samsung<\/td>\n<td width=\"60\">219<\/td>\n<td width=\"66\">277<\/td>\n<td width=\"66\">128<\/td>\n<td width=\"84\">110<\/td>\n<\/tr>\n<tr>\n<td width=\"117\">Miami<\/td>\n<td width=\"120\">Mobile<\/td>\n<td width=\"108\">Xiaomi<\/td>\n<td width=\"60\">149<\/td>\n<td width=\"66\">162<\/td>\n<td width=\"66\">102<\/td>\n<td width=\"84\">169<\/td>\n<\/tr>\n<tr>\n<td width=\"117\">Miami<\/td>\n<td width=\"120\">TV<\/td>\n<td width=\"108\">LG<\/td>\n<td width=\"60\">273<\/td>\n<td width=\"66\">178<\/td>\n<td width=\"66\">378<\/td>\n<td width=\"84\">113<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3 id=\"insert-stacked-bar-chart-in-excel\">Step #2: Insert 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-excel.jpg\" alt=\"find stacked bar chart in excel-007 \" width=\"650\"><\/div>\n<h3 id=\"select-data-and-create-stacked-bar-chart-in-excel\">Step #3: Select Data &amp; Create 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\/create-chart-from-selection-007.jpg\" alt=\"create chart from selection 007 \" width=\"650\"><\/div>\n<h3 id=\"final-stacked-bar-chart-in-excel-with-multiple-data\">Step #4: Final Chart Below<\/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\/stacked-bar-chart-in-excel-007.jpg\" alt=\"stacked bar chart in excel 007 \" width=\"650\"><\/div>\n<h2 id=\"how-to-edit-stacked-bar-chart-in-excel-with-multiple-data\">How to Edit the Stacked Bar Chart in Excel With Multiple Data?<\/h2>\n<p>To change the Stacked Bar Chart in Excel with multiple data type, follow the instructions below.<\/p>\n<ul>\n<li>Click the Settings button, as shown below.<\/li>\n<li>Once the <strong>Chart Setting <\/strong>drop-down pops up, click the <strong>Misc <\/strong>button<strong>.<\/strong><\/li>\n<li>Select either <strong>Value Base <\/strong>or <strong>Percentage Base<\/strong> in the drop-down.<\/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-excel-1-007.jpg\" alt=\"edit stacked bar chart in excel 1 \" width=\"650\"><\/div>\n<ul>\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-excel-2-007.jpg\" alt=\"edit stacked bar chart in excel 2 \" width=\"650\"><\/div>\n<ul>\n<li>Once Edit Chart is clicked, you will see different pencil signs on the visualization. It means these are editable sections. You can click on the pencil icon on the bar and see the properties to be changed.<\/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-excel-3-007.jpg\" alt=\"edit stacked bar chart in excel 3 \" width=\"619\"><\/div>\n<ul>\n<li>Once the <strong>Bar &amp; <\/strong><strong>Label Properties window<\/strong> shows, click either Prefix or Postfix to add your legends.<\/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-excel-4-007.jpg\" alt=\"edit stacked bar chart in excel 4 \" width=\"602\"><\/div>\n<ul>\n<li>Complete the process by clicking the <strong>Apply All <\/strong>button<strong>.<\/strong><\/li>\n<li>After editing the chart, you should have something like this (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\/stacked-bar-chart-with-multiple-data-007.jpg\" alt=\"stacked bar chart with multiple data 007 \" width=\"650\"><\/div>\n<p>How to make a Stacked Bar Chart in Excel with multiple data does not have to be time-consuming. Take advantage of ChartExpo to supercharge your Excel today.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbyswMDcr\" 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><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbyswMDcr\" 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><\/div>\n<h2 id=\"why-analysts-use-excel-stacked-bar-chart-with-multiple-data\">Why Do Analysts use the Excel Stacked Bar Chart with Multiple Data?<\/h2>\n<p>The key objective of the Excel Stacked Bar Chart with different data is to help you gain insights into the levels of categorical variables in your data.<\/p>\n<p>The chart is plotted for each level of the categorical variable. More so, each bar&#8217;s length indicates the value of the variable under study.<\/p>\n<p>Use this chart if your goal is to display the relative composition of key data points. You can also use the Stacked Bar Chart in Excel or the <a href=\"https:\/\/chartexpo.com\/blog\/clustered-stacked-bar-chart\" target=\"_blank\" rel=\"noopener noreferrer\">Clustered Stacked Bar Chart<\/a> with multiple data series to compare and analyze insights into key data points.<\/p>\n<p>How to make a Stacked Bar Chart in Excel with multiple data should never be a <em>time-consuming or nerve-wracking affair<\/em>. Keep reading to discover more.<\/p>\n<h2 id=\"tips-for-using-stacked-bar-chart-in-excel-with-multiple-datasets\">Keep in Mind When Using a Stack Bar Chart in Excel With Multiple Datasets<\/h2>\n<ul>\n<li>Avoid adding many subcategories because you might end up with a cluttered chart.<\/li>\n<li>Always start the baseline at 0.<\/li>\n<li>If one of the categorical variables is related to time (years, months, days, etc.), set it as the main category and plot on the horizontal axis.<\/li>\n<\/ul>\n<h2 id=\"stacked-bar-chart-in-excel-with-multiple-data-faqs\">How to Create a Stacked Bar Chart in Excel With Multiple Data &#8211; FAQs<\/h2>\n<h3>How do I create a Stacked Bar Chart in Excel with multiple data?<\/h3>\n<p>Freemium data visualization tools, such as Excel, lack ready-made and visually appealing Stacked Bar Chart Excel. You can transform your Excel into a visualization juggernaut by downloading and installing third-party add-ons, such as ChartExpo.<\/p>\n<p>You can use ChartExpo to create Stacked Bar Charts in Excel in a few clicks by following the simple procedure below.<\/p>\n<ul>\n<li>Enter your data in Excel.<\/li>\n<li>Load the ChartExpo add-in for Excel as shown above in the blog.<\/li>\n<li>Select Stacked Bar Chart in the list of charts in Excel.<\/li>\n<li>Click the &#8220;Create chart from Selection&#8221; button.<\/li>\n<li>You will get a Stacked Bar Chart in Excel.<\/li>\n<\/ul>\n<h3>How to structure data for Stacked Bar Chart in Excel?<\/h3>\n<p>To structure data for a stacked bar chart in Excel, list categories in the first column and each series you want to stack in separate columns to the right. Each row should represent one category with its series values, making it easy for Excel to stack them in the chart.<\/p>\n<h4 id=\"wrap-up\">Wrap Up<\/h4>\n<p>Extracting part-to-whole insights is not a walk in the park.<\/p>\n<p>You need a specialized data visualization chart to extract reliable insights to succeed. In other words, you need this Chart.<\/p>\n<p>Use this chart if your objective is to display hidden insights within subcategories and their relationship to aggregate values in your data.<\/p>\n<p>Excel should not be your go-to visualization tool if you want to leverage the chart for in-depth insights. The spreadsheet application lacks <em>ready-to-use and visually appealing <\/em>charts.<\/p>\n<p>How to make a Stacked Bar Chart in Excel with multiple datasets should <em>never be a complex or overwhelming task.<\/em><\/p>\n<p>We recommend you install third-party apps, such as ChartExpo, into your Excel to access <em>ready-made and visually appealing charts<\/em>.<\/p>\n<p>ChartExpo is an Excel-based add-in with <em>insightful and easy-to-interpret Charts,<\/em> plus many more advanced visualization designs.<\/p>\n<p>You don&#8217;t require programming skills to visualize your data using the tool in Excel.<\/p>\n<p>Sign up for a 7-day free trial today to access <em>easy-to-interpret, ready-made, and visually appealing<\/em> charts for your data stories.<\/p>\n<p><strong>Related Article:<\/strong><br \/>\n<a href=\"https:\/\/chartexpo.com\/blog\/how-to-make-a-stacked-bar-chart-in-google-sheets\" target=\"_blank\" rel=\"noopener noreferrer\">How to Make a Stacked Bar Chart in Google Sheets<\/a><\/p>\n<p><a href=\"https:\/\/chartexpo.com\/blog\/stacked-column-chart-with-two-sets-of-data\" target=\"_blank\" rel=\"noopener\">How to Create a Stacked Column Chart With Two Sets of Data<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p><p>Click to learn how to create a Stacked Bar Chart in Excel With Multiple Data. You\u2019ll learn how to get started with a Stacked Bar Graph in your data stories.<\/p>\n&nbsp;&nbsp;<a href=\"https:\/\/chartexpo.com\/blog\/how-to-make-a-stacked-bar-chart-in-excel-with-multiple-data\"><\/a><\/p>","protected":false},"author":1,"featured_media":17648,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[746],"tags":[829,828],"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 Excel With Multiple Data? -<\/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-excel-with-multiple-data\" \/>\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 Excel With Multiple Data? -\" \/>\r\n<meta name=\"twitter:description\" content=\"Click to learn how to create a Stacked Bar Chart in Excel With Multiple Data. You\u2019ll learn how to get started with a Stacked Bar Graph in your data stories.\" \/>\r\n<meta name=\"twitter:image\" content=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/feature-007.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=\"17 minutes\" \/>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Make a Stacked Bar Chart in Excel With Multiple Data? -","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-excel-with-multiple-data","twitter_card":"summary_large_image","twitter_title":"How to Make a Stacked Bar Chart in Excel With Multiple Data? -","twitter_description":"Click to learn how to create a Stacked Bar Chart in Excel With Multiple Data. You\u2019ll learn how to get started with a Stacked Bar Graph in your data stories.","twitter_image":"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/feature-007.jpg","twitter_misc":{"Written by":"admin","Est. reading time":"17 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/chartexpo.com\/blog\/how-to-make-a-stacked-bar-chart-in-excel-with-multiple-data","url":"https:\/\/chartexpo.com\/blog\/how-to-make-a-stacked-bar-chart-in-excel-with-multiple-data","name":"How to Make a Stacked Bar Chart in Excel With Multiple Data? -","isPartOf":{"@id":"http:\/\/localhost\/blog\/#website"},"datePublished":"2025-07-07T02:52:43+00:00","dateModified":"2026-02-04T10:59:14+00:00","author":{"@id":"http:\/\/localhost\/blog\/#\/schema\/person\/6aceeb7c948a3f66ff6439ce5c24a280"},"breadcrumb":{"@id":"https:\/\/chartexpo.com\/blog\/how-to-make-a-stacked-bar-chart-in-excel-with-multiple-data#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/chartexpo.com\/blog\/how-to-make-a-stacked-bar-chart-in-excel-with-multiple-data"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/chartexpo.com\/blog\/how-to-make-a-stacked-bar-chart-in-excel-with-multiple-data#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 Excel With Multiple Data?"}]},{"@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\/17638"}],"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=17638"}],"version-history":[{"count":56,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/17638\/revisions"}],"predecessor-version":[{"id":58672,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/17638\/revisions\/58672"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/media\/17648"}],"wp:attachment":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/media?parent=17638"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/categories?post=17638"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/tags?post=17638"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}