{"id":20549,"date":"2023-12-14T05:53:21","date_gmt":"2023-12-14T00:53:21","guid":{"rendered":"https:\/\/ppcexpo.com\/blog\/?p=20549"},"modified":"2026-01-12T17:17:44","modified_gmt":"2026-01-12T12:17:44","slug":"stacked-column-chart-with-two-sets-of-data","status":"publish","type":"post","link":"https:\/\/ppcexpo.com\/blog\/stacked-column-chart-with-two-sets-of-data","title":{"rendered":"How to Create Stacked Column Charts With Two Sets of Data"},"content":{"rendered":"<p>You\u2019ll agree when we say conducting part-to-whole comparisons across key categories in your data is not easy.<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2024\/10\/stacked-column-chart-with-two-sets-of-data-main.jpg\" alt=\"how to add a secondary axis in excel\"><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTArYmxvZytncytwcGMrNjIxKw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 70%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/how-to-add-a-secondary-axis-in-excel-button-3.jpg\" alt=\"how to add a secondary axis in excel\"><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTArYmxvZyt4bCtwcGMrNjIxKw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 70%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/how-to-add-a-secondary-axis-in-excel-button-4.jpg\" alt=\"how to add a secondary axis in excel\"><\/a><\/div>\n<p>The situation becomes further complicated if your raw data is bulky. You need a chart that\u2019s primarily designed to help you display parts of multiple totals. A Pivot table is not recommended, especially if the size of your data is enormous.<\/p>\n<p><em>This is where the Stacked Column Chart with two sets of data comes in.<\/em><\/p>\n<p>This chart can help uncover <em>hidden part-to-whole insights<\/em> into your data. Besides, you can use both nominal (i.e. data without natural order or rank) and ordinal (i.e. data that has natural order or rank) data types to plot this visualization.<\/p>\n<p><a href=\"https:\/\/ppcexpo.com\/blog\/data-visualization-tools\" target=\"_blank\" rel=\"noopener noreferrer\">Data visualization tools<\/a>, such as Google Sheets come with pretty basic Stacked Column Charts. This implies you have to do a ton of customizations and editing, which can take significant amounts of time.<\/p>\n<p>But, you can transform Google Sheets into a reliable tool by installing third-party add-ons.<\/p>\n<p>In this blog you will learn:<\/p>\n<ol>\n<li><a href=\"#tb1\">What is a Stacked Column Chart?<\/a><\/li>\n<li><a href=\"#tb2\">When Should You Use a Stacked Column Chart With Two Sets Of Data?<\/a><\/li>\n<li><a href=\"#tb3\">How to Read Two Sets of Data Using a Stacked Column Chart?<\/a><\/li>\n<li><a href=\"#tb4\">What are the Advantages of Stacked Column Charts?<\/a><\/li>\n<li><a href=\"#tb5\">What to Keep in Mind When Creating a Stacked Column Chart with Two Sets of Data?<\/a><\/li>\n<li><a href=\"#tb6\">How to Create a Stacked Column Chart with Two Sets of Data?<\/a><\/li>\n<li><a href=\"#tb7\">How to Visualize Data Using ChartExpo Add-on (for Google Sheets)?<\/a><\/li>\n<li><a href=\"#tb8\">How to Edit a Stacked Column Chart with Two Sets of Data?<\/a><\/li>\n<li><a href=\"#tb9\">Wrap Up<\/a><\/li>\n<\/ol>\n<h3>Video Tutorial:<\/h3>\n<div>\n<div><iframe loading=\"lazy\" title=\"YouTube video player\" src=\"https:\/\/www.youtube.com\/embed\/4mmqMaKk0vo\" width=\"700\" height=\"409\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\u00ef\u00bb\u00bf<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\u00ef\u00bb\u00bf<\/span><\/iframe><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTArYmxvZytncytwcGMrNjIxKw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 70%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/how-to-add-a-secondary-axis-in-excel-button-3.jpg\" alt=\"how to add a secondary axis in excel\"><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTArYmxvZyt4bCtwcGMrNjIxKw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 70%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/how-to-add-a-secondary-axis-in-excel-button-4.jpg\" alt=\"how to add a secondary axis in excel\"><\/a><\/div>\n<\/div>\n<h2 id=\"tb1\">What is a Stacked Column Chart?<\/h2>\n<p><strong>Definition<\/strong>: The Stacked Column Chart is essentially an extension of the standard Column Chart. Lets have an example of Stacked Column Chart<\/p>\n<p>Each column in this chart is divided into several sub-bars stacked end-to-end. The Stacked Column Chart with two sets of data is best suited in tracking the trends of crucial data points over time. Besides, it outperforms the Pie Chart by far in displaying <em>part-to-whole<\/em> relationships.<\/p>\n<p><em>Why?<\/em><\/p>\n<p>The Stacked Column Chart is <em>easy to read and interpret.<\/em> Besides, it can handle bulky data without appearing cluttered.<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2022\/07\/stacked-column-chart-with-two-sets-of-data-1.jpg\" alt=\"how to add a secondary axis in excel\"><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTArYmxvZytncytwcGMrNjIxKw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 70%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/how-to-add-a-secondary-axis-in-excel-button-3.jpg\" alt=\"how to add a secondary axis in excel\"><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTArYmxvZyt4bCtwcGMrNjIxKw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 70%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/how-to-add-a-secondary-axis-in-excel-button-4.jpg\" alt=\"how to add a secondary axis in excel\"><\/a><\/div>\n<h2 id=\"tb2\">When Should You Use a Stacked Column Chart With Two Sets Of Data?<\/h2>\n<p>The main goal of the Stacked Column Chart is to help you gain insights into the levels of categorical variables in your data.<\/p>\n<p>In this chart, columns are plotted for each level of the categorical variable. And each column\u2019s length indicates the value as total value against that particular dimension. More so, each column is made up of sub-bars, each corresponding with a categorical variable.<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/stacked-column-chart-with-two-sets-of-data-2.jpg\" alt=\"how to add a secondary axis in excel\"><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTArYmxvZytncytwcGMrNjIxKw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 70%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/how-to-add-a-secondary-axis-in-excel-button-3.jpg\" alt=\"how to add a secondary axis in excel\"><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTArYmxvZyt4bCtwcGMrNjIxKw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 70%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/how-to-add-a-secondary-axis-in-excel-button-4.jpg\" alt=\"how to add a secondary axis in excel\"><\/a><\/div>\n<p>Use this chart if your goal is to display the relative decomposition of each primary column. You can also use the Stacked Column Chart to display comparisons between key data points. You can also use this chart for <a href=\"https:\/\/ppcexpo.com\/blog\/hierarchical-data-visualization\" target=\"_blank\" rel=\"noopener noreferrer\">visualizing Hierarchical Data<\/a> with proper formatting.<\/p>\n<h2 id=\"tb3\">How to Read Two Sets of Data Using a Stacked Column Chart?<\/h2>\n<p>To interpret the Stacked Column Charts quickly, practice the tips below religiously:<\/p>\n<ul>\n<li><strong>Understand the data points you\u2019re comparing<\/strong><\/li>\n<\/ul>\n<p>We recommend you take your sweet time to understand the critical data points and their respective contexts.<\/p>\n<p>E.g. below image is showing data of population in UK which accumulatively showing 25 Million. At the same time you can compare it within same country with other age group or at the same time with other country\u2019s age groups.<\/p>\n<p>You need to know to whom you have to present the data and what should be your focus to understand the data points.<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/stacked-column-chart-with-two-sets-of-data-3.jpg\" alt=\"how to add a secondary axis in excel\"><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTArYmxvZytncytwcGMrNjIxKw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 70%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/how-to-add-a-secondary-axis-in-excel-button-3.jpg\" alt=\"how to add a secondary axis in excel\"><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTArYmxvZyt4bCtwcGMrNjIxKw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 70%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/how-to-add-a-secondary-axis-in-excel-button-4.jpg\" alt=\"how to add a secondary axis in excel\"><\/a><\/div>\n<ul>\n<li><strong>Analyze the trend<\/strong><\/li>\n<\/ul>\n<p>Review the overall trend within the chart to gain more insights. For example, a hypothetical company\u2019s sales in the United States have grown steadily over the past three years.<\/p>\n<p>However, a Stacked Column Chart may reveal minor downtrends as well.<\/p>\n<ul>\n<li><strong>Spot outliers<\/strong><\/li>\n<\/ul>\n<p>Use the gridlines in Stacked Column Chart to compare the trends of key variables in your data. You\u2019ll be able to spot outliers present in your data. Although these outliers are not as presentable as dot but as a bar length of a particular value which will make it prominent from the rest.<\/p>\n<h2 id=\"tb4\">What are the Advantages of Stacked Column Charts?<\/h2>\n<p>Check out below the reasons why you should try the Stacked Column Chart this 2023:<\/p>\n<ul>\n<li><strong>Easy to spot hidden insights<\/strong><\/li>\n<\/ul>\n<p>One of the strengths of a Stacked Column Chart is that you can easily spot comparison insights.<\/p>\n<p>Besides, you can easily see data points clearly because they\u2019re on top of each other. You can also undertone the percentage of each data point with respect to the total value.<\/p>\n<ul>\n<li><strong>Outliers<\/strong><\/li>\n<\/ul>\n<p>A Stacked Column Chart is one of the best charts to use if your goal is to uncover outliers in your data.<\/p>\n<p>For example, imagine you run a hypothetical company that deals with ten different smartphone brands. Over the years, you\u2019ve established the best and worst-selling brands.<\/p>\n<p>One of the underperforming brands did so well in one month. And this forced you to respond to the surging demand by ordering more quantities.<\/p>\n<p>But then, the sales declined drastically and never recovered. In fact, this is the second financial year, and you still have a massive inventory of the worst-selling phone brand.<\/p>\n<p><em>This is a typical case of an outlier misleading you.<\/em><\/p>\n<ul>\n<li><strong>Saves time<\/strong><\/li>\n<\/ul>\n<p>A stacked Column Chart can save you the time you normally consume, primarily when visualizing bulky data sets.<\/p>\n<p>For example, you can use the Stacked Column Chart to visualize the results of a survey.<\/p>\n<p>Instead of manually sorting through thousands of responses: you can simply use this chart to find out the number of respondents who agreed or disagreed with a particular question.<\/p>\n<h2 id=\"tb5\">What to Keep in Mind When Creating a Stacked Column Chart with Two Sets of Data?<\/h2>\n<p>You can easily compare data points across the primary categories in your data. But, it\u2019s less straightforward, especially when comparing key variables across the secondary categories.<\/p>\n<p>Use this chart if you want to uncover hidden comparison insights into secondary variables versus the primary categories.<\/p>\n<p>You can easily achieve this goal (above) using a baseline.<\/p>\n<p>Note: it\u2019s quite challenging to use a Baseline to compare secondary variables because it\u2019s likely to experience a shift. And this might distort the key insights.<\/p>\n<p>Check out the Stacked Column Chart below. Note how it\u2019s challenging to identify the actual trend of the central (yellow) variable.<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/stacked-column-chart-with-two-sets-of-data-4.jpg\" alt=\"how to add a secondary axis in excel\"><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTArYmxvZytncytwcGMrNjIxKw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 70%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/how-to-add-a-secondary-axis-in-excel-button-3.jpg\" alt=\"how to add a secondary axis in excel\"><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTArYmxvZyt4bCtwcGMrNjIxKw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 70%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/how-to-add-a-secondary-axis-in-excel-button-4.jpg\" alt=\"how to add a secondary axis in excel\"><\/a><\/div>\n<p>Note how hard it is to spot changes in non-baseline groups over time. Besides, comparing the sub-bars in each primary bar is also challenging and might result in distorted interpretation.<\/p>\n<p>Picture yourself shooting the ducks in a gun range while blindfolded. <em>How many would you take down?<\/em><\/p>\n<p>Try sorting out the secondary category levels by overall size. You\u2019re likely to get distorted insights. In the screenshot above, you can\u2019t tell whether the purple \u201cWest\u201d group outperforms the yellow \u201cCentral\u201d group in terms of size.<\/p>\n<p><em>Keep the following in mind.<\/em><\/p>\n<p>The main goal of a Stacked Column Chart is to <em>uncover part-to-whole insights<\/em>. This makes the comparison of secondary bars with the primary columns really essential.<\/p>\n<p>If your goal is to assess sub-groups\u2019 performance within your data, then your go-to chart should be a Stacked Column Chart.<\/p>\n<h2 id=\"tb6\">How to Create a Stacked Column Chart with Two Sets of Data?<\/h2>\n<p>Google Sheets is one of the most used tools for visualizing data. And this is because it\u2019s<em> free and easy to use. <\/em><\/p>\n<p>But the freemium data visualization tool has a <em>very basic Stacked Column Chart <\/em>in its library. This means you\u2019ll have to spend more time customizing the chart to make it <em>appealing and insightful.<\/em><\/p>\n<p>You don\u2019t have to ditch Google Sheets. <em>Why?<\/em><\/p>\n<p>You can actually supercharge your Google Sheets by downloading and installing third-party add-ons. Yes, you can access advanced charts, such as Stacked Column Chart, via third-party applications (also known as add-ons).<\/p>\n<p>The add-on we recommend you to use is ChartExpo. Use this tool to create irresistible data stories with the Stacked Column Chart.<\/p>\n<p>So what is ChartExpo?<\/p>\n<p>We recommend ChartExpo because it has an u<em>ltra-friendly user interface (UI)<\/em>. You don\u2019t need programming or coding skills just to extract insights from your data.<\/p>\n<p>Furthermore, this data visualization tool is more of a \u2018drag-and-drop tool\u2019. The aforementioned means you\u2019ll only need to scroll your mouse and fill in the respective metrics and dimensions.<\/p>\n<p>The ChartExpo comes with a free trial period.<\/p>\n<p>The core 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 in the world\u2019s most recognized formats, namely PNG and JPG.<\/p>\n<p>ChartExpo comes loaded with 50-plus charts, including a Stacked Column Chart, Donut, Area, Scatter Plots, <a href=\"https:\/\/ppcexpo.com\/blog\/sankey-diagram\">Sankey Diagram<\/a>, Survey Charts, and Sentiment charts, among others.<\/p>\n<h2 id=\"tb7\">How to Visualize Data Using ChartExpo Add-on (for Google Sheets)?<\/h2>\n<p>Imagine you want to compare the proportion of the age groups (0-14 versus 15-64 years) in the population of various countries for hypothetical data.<\/p>\n<p><em>Which chart would you go for?<\/em><\/p>\n<p>If your answer is the Stacked Column Chart, you\u2019re absolutely right. Let\u2019s assume the tabular data below is what you\u2019ve collected.<\/p>\n<p><em>Let\u2019s get down to business.<\/em><\/p>\n<table class=\"static\" style=\"table-layout: fixed; overflow-x: auto; border: 1px; font-size: 17px;\">\n<tbody>\n<tr>\n<td width=\"171\"><strong>Country<\/strong><\/td>\n<td width=\"150\"><strong>0 &#8211; 14 years<\/strong><\/td>\n<td width=\"161\"><strong>15 &#8211; 64 years<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"171\">UK<\/td>\n<td width=\"150\">5<\/td>\n<td width=\"161\">20<\/td>\n<\/tr>\n<tr>\n<td width=\"171\">Germany<\/td>\n<td width=\"150\">6<\/td>\n<td width=\"161\">29<\/td>\n<\/tr>\n<tr>\n<td width=\"171\">Mexico<\/td>\n<td width=\"150\">17<\/td>\n<td width=\"161\">31<\/td>\n<\/tr>\n<tr>\n<td width=\"171\">Japan<\/td>\n<td width=\"150\">9<\/td>\n<td width=\"161\">44<\/td>\n<\/tr>\n<tr>\n<td width=\"171\">Russia<\/td>\n<td width=\"150\">13<\/td>\n<td width=\"161\">49<\/td>\n<\/tr>\n<tr>\n<td width=\"171\">Brazil<\/td>\n<td width=\"150\">26<\/td>\n<td width=\"161\">55<\/td>\n<\/tr>\n<tr>\n<td width=\"171\">United States<\/td>\n<td width=\"150\">29<\/td>\n<td width=\"161\">91<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Once you have installed <a href=\"https:\/\/chartexpo.com\/utmAction\/MTArYmxvZytncytwcGMrNjIxKw==\" target=\"_blank\" rel=\"nofollow noopener\">ChartExpo for Google Sheets<\/a> follow the easy steps below:<\/p>\n<ul>\n<li>Open your Google Sheets desktop application.<\/li>\n<li>Open the worksheet and click <strong>the Extension menu button<\/strong>.<\/li>\n<li>Once the <strong>ChartExpo-Best Data Visualization Tool<\/strong> drop-down menu shows, click the <strong>Open button.<\/strong><\/li>\n<\/ul>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2022\/07\/stacked-column-chart-with-two-sets-of-data-5.jpg\" alt=\"how to add a secondary axis in excel\"><\/div>\n<ul>\n<li>You can add your data in sheet and click the <strong>Create New Chart button <\/strong>from ChartExpo on right side of the screen<strong>,<\/strong> as shown below<strong>.<\/strong><\/li>\n<\/ul>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2022\/07\/stacked-column-chart-with-two-sets-of-data-6.jpg\" alt=\"how to add a secondary axis in excel\"><\/div>\n<ul>\n<li>You will see list of charts provided by ChartExpo.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2022\/07\/stacked-column-chart-with-two-sets-of-data-7.jpg\" alt=\"how to add a secondary axis in excel\"><\/div>\n<ul>\n<li>You can find Stacked Column Chart from the list.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/stacked-column-chart-with-two-sets-of-data-8.jpg\" alt=\"how to add a secondary axis in excel\"><\/div>\n<ul>\n<li>Select the sheet holding your data, as shown above.<\/li>\n<li>Fill in your metrics and dimensions. In our example, we have 2 metrics: <strong>0-15 and 15-64 years. <\/strong>The dimensional variable in our data is <strong>Country<\/strong>.<\/li>\n<li>Complete the simple task by clicking the <strong>Create Chart button.<\/strong><\/li>\n<\/ul>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2022\/07\/stacked-column-chart-with-two-sets-of-data-9.jpg\" alt=\"how to add a secondary axis in excel\"><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTArYmxvZytncytwcGMrNjIxKw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 70%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/how-to-add-a-secondary-axis-in-excel-button-3.jpg\" alt=\"how to add a secondary axis in excel\"><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTArYmxvZyt4bCtwcGMrNjIxKw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 70%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/how-to-add-a-secondary-axis-in-excel-button-4.jpg\" alt=\"how to add a secondary axis in excel\"><\/a><\/div>\n<h2 id=\"tb8\">How to Edit a Stacked Column Chart with Two Sets of Data?<\/h2>\n<p>To edit your Stacked Column Chart click <strong>the Edit Chart button, <\/strong>as shown below.<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2022\/07\/stacked-column-chart-with-two-sets-of-data-10.jpg\" alt=\"how to add a secondary axis in excel\"><\/div>\n<ul>\n<li>To Change the chart\u2019s title, click <strong>the pen-like icon.<\/strong><\/li>\n<li>You\u2019ll come across a window called <strong>Chart Header Top Properties. <\/strong>Proceed and click the <strong>Line 1 box<\/strong> and fill in your title. In our example, the title is \u201cAge Analysis by Population.\u201d<\/li>\n<li>Toggle the button (just below the Line 2 box) to the right side.<\/li>\n<li>Save all the changes by clicking the <strong>Apply button,<\/strong> as shown below.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2022\/07\/stacked-column-chart-with-two-sets-of-data-11.jpg\" alt=\"how to add a secondary axis in excel\"><\/div>\n<ul>\n<li>After brief editing, your final <strong>Stacked Column Chart with two sets of data <\/strong>should look like the one below.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2022\/07\/stacked-column-chart-with-two-sets-of-data-12.jpg\" alt=\"how to add a secondary axis in excel\"><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTArYmxvZytncytwcGMrNjIxKw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 70%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/how-to-add-a-secondary-axis-in-excel-button-1.jpg\" alt=\"how to add a secondary axis in excel\"><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTArYmxvZyt4bCtwcGMrNjIxKw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 70%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/how-to-add-a-secondary-axis-in-excel-button-2.jpg\" alt=\"how to add a secondary axis in excel\"><\/a><\/div>\n<p><strong>Insights<\/strong><\/p>\n<ul>\n<li>The United States has the highest proportion of people aged between 15-64 years.<\/li>\n<li>The UK and Germany have the lowest proportion of people aged between 0-14 years.<\/li>\n<\/ul>\n<h2>FAQs:<\/h2>\n<h3>What is the Stacked Column Chart used for?<\/h3>\n<p>You can use the Stacked Column Charts to display part-to-whole relationships in your data.<\/p>\n<p>If your goal is to show parts of the grand total, consider other variants, such as a Bar Chart. This chart can use the available space more efficiently than a Stacked Column Chart with two sets of data. You can also use this chart to <a href=\"https:\/\/ppcexpo.com\/blog\/how-to-visualize-ranking-data\" target=\"_blank\" rel=\"noopener noreferrer\">visualize ranking data<\/a>.<\/p>\n<h3>How can you create a Stack Column Chart with two sets of data?<\/h3>\n<p>Freemium data visualization tools, such as Google Sheets, can help you visualize data using the Stacked Column Chart.<\/p>\n<p>But, they come with basic and less appealing charts.<\/p>\n<p>You can transform your Google Sheets into a visualization juggernaut by downloading and installing third-party add-ons, such as ChartExpo.<\/p>\n<h4 id=\"tb9\">Wrap Up:<\/h4>\n<p>Extracting part-to-whole insights, especially from a bulk data set, is easier said than done.<\/p>\n<p>To succeed, you need a specialized data visualization chart to help you extract reliable insights.<\/p>\n<p>The Stacked Column Diagram is the chart we recommend, especially if your objective is to display hidden insights into sub-categories and their relationships to the whole in your data.<\/p>\n<p>Google Sheets should not be your go-to visualization tool. <em>Why?<\/em><\/p>\n<p>The spreadsheet application comes with pretty basic Stacked Column Charts. You\u2019ll need additional time and effort to customize charts to align with your requirements.<\/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 you can easily download and install in your Google Sheets.<\/p>\n<p>This easy-to-use tool comes loaded with an insightful and easy to interpret Stacked Column Chart, plus over 50 more advanced charts.<\/p>\n<p><em>Here\u2019s the kicker<\/em>.<\/p>\n<p>You actually <em>don\u2019t need programming or coding skills<\/em> to visualize your data using the add-on. Sign up for a 7-day free trial today to access <em>easy-to-interpret, responsive, and visually appealing<\/em> Stacked Column Charts.<\/p>\n","protected":false},"excerpt":{"rendered":"<p><p>Learn to create stacked column charts with two sets of data in Google Sheets. Our comprehensive guide covers detailed steps, tips, and tricks to master this technique effortlessly.<\/p>\n&nbsp;&nbsp;<a href=\"https:\/\/ppcexpo.com\/blog\/stacked-column-chart-with-two-sets-of-data\"><\/a><\/p>","protected":false},"author":1,"featured_media":39726,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[887],"tags":[786],"_links":{"self":[{"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/posts\/20549"}],"collection":[{"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/comments?post=20549"}],"version-history":[{"count":13,"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/posts\/20549\/revisions"}],"predecessor-version":[{"id":45817,"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/posts\/20549\/revisions\/45817"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/media\/39726"}],"wp:attachment":[{"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/media?parent=20549"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/categories?post=20549"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/tags?post=20549"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}