{"id":587,"date":"2014-10-06T17:40:32","date_gmt":"2014-10-06T15:40:32","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=587"},"modified":"2024-04-02T23:15:24","modified_gmt":"2024-04-02T21:15:24","slug":"100-stacked-column-chart-percentage-contributions","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/100-stacked-column-chart-percentage-contributions\/","title":{"rendered":"100% Stacked Column Chart: Percentage Contributions"},"content":{"rendered":"<p>Excel Charts helps you visualize your data to quickly assess information. If you wish to <strong>compare a part-to-whole data<\/strong> over time or over different categories, then the <strong>Stacked Column Chart<\/strong> is the ultimate tool for you!<\/p>\n<div>\n<p>In this blog, you will learn the following:<\/p>\n<ul>\n<li><a href=\"#stacked-column\">Stacked Column<\/a><\/li>\n<li><a href=\"#100-stacked-column\">100% Stacked Column<\/a><\/li>\n<li><a href=\"#customize-100-stacked-column\">Customize 100% Stacked Column<\/a><\/li>\n<li><a href=\"#3-D-100-stacked-column\">3-D 100% Stacked Column<\/a><\/li>\n<li><a href=\"#switch-row-column\">Switch Row\/Column<\/a><\/li>\n<\/ul>\n<h3><a id=\"stacked-column\"><\/a>Stacked Column Chart<\/h3>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/XCoOwXnRvx8?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">?<\/span><\/iframe><\/p>\n<div>\n<div style=\"float: left\"><span style=\"text-decoration: underline\"><strong><a href=\"https:\/\/youtu.be\/XCoOwXnRvx8\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Watch on YouTube<\/a><\/strong><\/span> and give it a thumbs up ??<\/div>\n<div>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignright wp-image-111468 size-full\" style=\"vertical-align: middle\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<\/div>\n<p>In Stacked Column Chart, data series of various categories are stacked one upon another in vertical columns. It is used to compare the contribution of a value to a Total. These charts are useful when you want to:<\/p>\n<ul>\n<li>Compare part to whole data over time<\/li>\n<li>Compare part to whole data over category<\/li>\n<\/ul>\n<p>Let&#8217;s look at an example to understand how data is displayed in a Stacked Column Chart Excel.<\/p>\n<\/div>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/stacked-column-01-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"100% Stacked Column Chart: Percentage Contributions\" class=\"alignnone wp-image-5090 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/stacked-column-01-1.png\" alt=\"100% Stacked Column Chart: Percentage Contributions\" width=\"462\" height=\"189\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/stacked-column-01-1.png 462w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/stacked-column-01-1-300x123.png 300w\" sizes=\"(max-width: 462px) 100vw, 462px\" \/><\/a><\/p>\n<p>This data table represents the sales amount for the North &amp; South region from the year 2010 to 2014. Using this data, you can create a Stacked Column Chart to compare the sales amount for both the regions over the time period.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-2020-05-24-at-9.07.09-PM.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"100% Stacked Column Chart: Percentage Contributions\" class=\"alignnone size-full wp-image-16958\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-2020-05-24-at-9.07.09-PM.png\" alt=\"100% Stacked Column Chart: Percentage Contributions\" width=\"755\" height=\"459\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-2020-05-24-at-9.07.09-PM.png 755w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-2020-05-24-at-9.07.09-PM-300x182.png 300w\" sizes=\"(max-width: 755px) 100vw, 755px\" \/><\/a><\/p>\n<p>Years used of the analysis are plotted along the X-Axis and the regional sales amount are series and each region&#8217;s sales amount are shown on the Y-Axis.<\/p>\n<p><em>To learn how to create this Chart, go through our blog on <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/stacked-column-chart-compare-contributions\/\" target=\"_blank\" rel=\"noopener noreferrer\"><span style=\"color: #0000ff\">Stacked Column Chart<\/span><\/a><\/strong>.<\/em><\/p>\n<p>This representation of data not only helps you to understand the growth of individual segments and also the comparison between the two. You can spot the sales amount for both the North Region (Blue Bar) &amp; South Region (Red Bar) and also see how the sales amounts increase\/decrease over time.<\/p>\n<p>In Excel Stacked Bar Chart, data series of various categories are stacked one upon another in horizontal columns.<\/p>\n<\/div>\n<h3><a id=\"100-stacked-column\"><\/a>100% Stacked Column Chart<\/h3>\n<div>\n<p>The <strong>100% Stacked Column chart<\/strong> is an extension of the Stacked Column chart in that it compares the percentage that each value contributes to a Total.<\/p>\n<p>This 100% Stacked column chart is different from the Stacked Column Chart only in terms of representation of the column bars:<\/p>\n<ul>\n<li>In a Stacked Column chart, the height of each bar is the total value of a category<\/li>\n<li>In 100% Stacked Column Chart, the height of each bar is the same (100%) and the segments are shown as a percentage of the total value.<\/li>\n<\/ul>\n<p>So the value of each bar in 100% Stacked Column Chart Excel will always be 100 irrespective of the total value. The vertical axis of this chart contains percentage figures and not absolute value!<\/p>\n<p>For example, if you want to show the percentage of contributions for the North &amp; South sales over the last 5 years then this is the chart for you.<\/p>\n<p>Make sure to download the exercise workbook to follow along:<\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/100pc-Stacked-Column-1.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/100pc-Stacked-Column.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<\/span><span class=\"postTitle px-3\">100pc-Stacked-Column-1.xlsx<\/span><\/a><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<div class=\"jumbotron2\">\n<div class=\"meo-subcount-2\">\n<p><a id=\"om-f2q8uijmbbmwc3oohwuo-holder\" class=\"drop-shadow lifted btn btn-secondary\" href=\"https:\/\/app.monstercampaigns.com\/c\/f2q8uijmbbmwc3oohwuo\/\" target=\"_blank\" rel=\"nofollow noopener\">DOWNLOAD OUR<br \/>\nFREE EXCEL GUIDES<\/a><\/p>\n<p>&lt;!&#8212;-&gt;<\/p>\n<\/div>\n<\/div>\n<p><span style=\"color: #ff0000\"><strong>STEP 1<\/strong>:<\/span> Select the\u00a0<strong>table\u00a0<\/strong>on where we want to create the chart<strong>. \u00a0<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/stacked-column-01-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"100% Stacked Column Chart: Percentage Contributions\" class=\"alignnone size-full wp-image-5090\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/stacked-column-01-1.png\" alt=\"100% Stacked Column Chart: Percentage Contributions\" width=\"462\" height=\"189\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/stacked-column-01-1.png 462w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/stacked-column-01-1-300x123.png 300w\" sizes=\"(max-width: 462px) 100vw, 462px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2<\/strong>:<\/span> Go to\u00a0<strong>Insert &gt; Column &gt; 100% Stacked Column<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-125.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"100% Stacked Column Chart: Percentage Contributions\" class=\"wp-image-16966 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-125-e1590357930289.png\" alt=\"100% Stacked Column Chart: Percentage Contributions\" width=\"798\" height=\"269\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-125-e1590357930289.png 798w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-125-e1590357930289-300x101.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-125-e1590357930289-768x259.png 768w\" sizes=\"(max-width: 798px) 100vw, 798px\" \/><\/a><\/p>\n<p>Your chart is now ready:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/stacked-column-03-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"100% Stacked Column Chart: Percentage Contributions\" class=\"alignnone wp-image-5092 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/stacked-column-03-1.png\" alt=\"100% Stacked Column Chart: Percentage Contributions\" width=\"574\" height=\"383\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/stacked-column-03-1.png 574w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/stacked-column-03-1-300x200.png 300w\" sizes=\"(max-width: 574px) 100vw, 574px\" \/><\/a><\/p>\n<p>As you can see, it is easy to compare the sales amount for each region with the Excel <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/marimekko-chart\/\" target=\"_blank\" rel=\"noopener\">100% Stacked Column<\/a> Chart.<\/p>\n<p>Even though the Y-axis is plotted as a percentage. If you wish to view the sales amount of any region at any year, you can simply hover upon the column and watching the tooltip.<\/p>\n<p>For example, you want to know the sales amount for the North Region in the year 2012. You can hover upon that column and see that the sales amount is $50,492.<\/p>\n<\/div>\n<h2><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-134.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"100% Stacked Column Chart: Percentage Contributions\" class=\"alignnone size-full wp-image-16984\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-134.png\" alt=\"100% Stacked Column Chart: Percentage Contributions\" width=\"550\" height=\"374\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-134.png 550w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-134-300x204.png 300w\" sizes=\"(max-width: 550px) 100vw, 550px\" \/><\/a><\/h2>\n<p><strong>Convert Year in Data Table to Text<\/strong><\/p>\n<p>One thing you need to make sure when creating a chart using this data table is that the first column containing years should be converted to text. If this is not done, then by default Excel will treat them as numerical values and will be included in the calculation of Northern and Southern sales.<\/p>\n<p>To convert a number to text, simply add an apostrophe in front of the number.<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-2020-05-25-at-2.39.23-AM.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"100% Stacked Column Chart: Percentage Contributions\" class=\"alignnone size-full wp-image-16960\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-2020-05-25-at-2.39.23-AM.png\" alt=\"100% Stacked Column Chart: Percentage Contributions\" width=\"616\" height=\"305\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-2020-05-25-at-2.39.23-AM.png 616w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-2020-05-25-at-2.39.23-AM-300x149.png 300w\" sizes=\"(max-width: 616px) 100vw, 616px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><a id=\"customize-100-stacked-column\"><\/a>Customize 100% Stacked Column<\/h3>\n<p><strong>Filter Data in Stacked Column Chart<\/strong><\/p>\n<p>If you wish to display or focus on only a portion of the data, you can filter it in the 100% Stacked Column Chart. Say, you want to compare sales data for the year 2010 with the year 2014 only.<\/p>\n<p>To do so, follow the steps below:<\/p>\n<p><span style=\"color: #ff0000\"><strong>Step 1:<\/strong> <\/span>Select the previously created chart.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/stacked-column-03-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"100% Stacked Column Chart: Percentage Contributions\" class=\"alignnone wp-image-5092 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/stacked-column-03-1.png\" alt=\"100% Stacked Column Chart: Percentage Contributions\" width=\"574\" height=\"383\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/stacked-column-03-1.png 574w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/stacked-column-03-1-300x200.png 300w\" sizes=\"(max-width: 574px) 100vw, 574px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>Step 2:<\/strong> <\/span>On the top-right corner of the chart, select the filter button.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-136.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"100% Stacked Column Chart: Percentage Contributions\" class=\"alignnone size-full wp-image-16986\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-136.png\" alt=\"100% Stacked Column Chart: Percentage Contributions\" width=\"835\" height=\"378\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-136.png 835w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-136-300x136.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-136-768x348.png 768w\" sizes=\"(max-width: 835px) 100vw, 835px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>Step 3:<\/strong> <\/span>Uncheck the Year 2011, 2012 &amp; 2013 and Click on <strong>Apply.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-137.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"100% Stacked Column Chart: Percentage Contributions\" class=\"alignnone size-full wp-image-16987\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-137.png\" alt=\"100% Stacked Column Chart: Percentage Contributions\" width=\"846\" height=\"480\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-137.png 846w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-137-300x170.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-137-768x436.png 768w\" sizes=\"(max-width: 846px) 100vw, 846px\" \/><\/a><\/p>\n<p>100% Stacked Column Chart with only the years 2010 and 2014 would be displayed.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-138.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"100% Stacked Column Chart: Percentage Contributions\" class=\"alignnone size-full wp-image-16988\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-138.png\" alt=\"100% Stacked Column Chart: Percentage Contributions\" width=\"551\" height=\"372\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-138.png 551w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-138-300x203.png 300w\" sizes=\"(max-width: 551px) 100vw, 551px\" \/><\/a><\/p>\n<p><strong>Change the color of the Column<\/strong><\/p>\n<p>You can change the color of the Column by following the steps:<\/p>\n<p><span style=\"color: #ff0000\"><strong>Step 1:<\/strong><\/span> Right-click\u00a0on the chart<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-130.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"100% Stacked Column Chart: Percentage Contributions\" class=\"alignnone size-full wp-image-16989\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-130.png\" alt=\"100% Stacked Column Chart: Percentage Contributions\" width=\"569\" height=\"341\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-130.png 569w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-130-300x180.png 300w\" sizes=\"(max-width: 569px) 100vw, 569px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>Step 2:<\/strong> <\/span>Select the <strong>Fill option<\/strong> and choose an\u00a0appropriate color.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-131-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"100% Stacked Column Chart: Percentage Contributions\" class=\"alignnone size-full wp-image-16991\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-131-1.png\" alt=\"100% Stacked Column Chart: Percentage Contributions\" width=\"672\" height=\"675\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-131-1.png 672w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-131-1-300x300.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-131-1-150x150.png 150w\" sizes=\"(max-width: 672px) 100vw, 672px\" \/><\/a><\/p>\n<p>Your changed color chart is ready!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-132.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"100% Stacked Column Chart: Percentage Contributions\" class=\"alignnone size-full wp-image-16992\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-132.png\" alt=\"100% Stacked Column Chart: Percentage Contributions\" width=\"548\" height=\"373\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-132.png 548w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-132-300x204.png 300w\" sizes=\"(max-width: 548px) 100vw, 548px\" \/><\/a><\/p>\n<h3><a id=\"3-D-100-stacked-column\"><\/a>3-D 100% Stacked Column Chart<\/h3>\n<p>The chart you have created earlier was a 2-D 100% Stacked Column Chart. You can even create a 3-D version of it!<\/p>\n<p>3D is just a visual setting, it has nothing to do with the data. The chart will be plotted with 2 axes only (X-axis and Y-axis)<\/p>\n<p><span style=\"color: #ff0000\"><strong>Step 1<\/strong>:<\/span> Select the<strong> table<\/strong> which you want to create the chart<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/stacked-column-01-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"100% Stacked Column Chart: Percentage Contributions\" class=\"alignnone size-full wp-image-5090\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/stacked-column-01-1.png\" alt=\"100% Stacked Column Chart: Percentage Contributions\" width=\"462\" height=\"189\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/stacked-column-01-1.png 462w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/stacked-column-01-1-300x123.png 300w\" sizes=\"(max-width: 462px) 100vw, 462px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">Step 2:<\/span><\/strong> Go to<strong> Insert &gt; Column &gt; 3-D 100% Stacked Column Chart<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-124.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"100% Stacked Column Chart: Percentage Contributions\" class=\"alignnone size-full wp-image-16967\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-124.png\" alt=\"100% Stacked Column Chart: Percentage Contributions\" width=\"993\" height=\"467\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-124.png 993w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-124-300x141.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-124-768x361.png 768w\" sizes=\"(max-width: 993px) 100vw, 993px\" \/><\/a><\/p>\n<p>This is your 3D 100% Stacked Column Chart.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-129.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"100% Stacked Column Chart: Percentage Contributions\" class=\"alignnone size-full wp-image-16973\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-129.png\" alt=\"100% Stacked Column Chart: Percentage Contributions\" width=\"528\" height=\"321\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-129.png 528w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-129-300x182.png 300w\" sizes=\"(max-width: 528px) 100vw, 528px\" \/><\/a><\/p>\n<h3><a id=\"switch-row-column\"><\/a>Switch Row\/Column<\/h3>\n<p>Let us say in your initial data table the column and rows were swapped i.e. the left-most column contained region instead of year.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-2020-05-25-at-2.53.27-AM.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"100% Stacked Column Chart: Percentage Contributions\" class=\"alignnone wp-image-16961 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-2020-05-25-at-2.53.27-AM.png\" alt=\"100% Stacked Column Chart: Percentage Contributions\" width=\"864\" height=\"206\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-2020-05-25-at-2.53.27-AM.png 864w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-2020-05-25-at-2.53.27-AM-300x72.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-2020-05-25-at-2.53.27-AM-768x183.png 768w\" sizes=\"(max-width: 864px) 100vw, 864px\" \/><\/a><\/p>\n<p>Your 100% Stacked Column would look like this:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-2020-05-25-at-2.55.15-AM.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"100% Stacked Column Chart: Percentage Contributions\" class=\"alignnone wp-image-16962 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-2020-05-25-at-2.55.15-AM.png\" alt=\"100% Stacked Column Chart: Percentage Contributions\" width=\"548\" height=\"438\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-2020-05-25-at-2.55.15-AM.png 548w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-2020-05-25-at-2.55.15-AM-300x240.png 300w\" sizes=\"(max-width: 548px) 100vw, 548px\" \/><\/a><\/p>\n<p>But this is not the chart you were looking for. You want to compare regional sales over time i.e. you want to simply switch row with column.<\/p>\n<p><span style=\"color: #ff0000\"><strong>Step 1:<\/strong><\/span> Select the Chart<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-126.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"100% Stacked Column Chart: Percentage Contributions\" class=\"alignnone wp-image-16968 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-126.png\" alt=\"100% Stacked Column Chart: Percentage Contributions\" width=\"443\" height=\"260\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-126.png 443w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-126-300x176.png 300w\" sizes=\"(max-width: 443px) 100vw, 443px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>Step 2:<\/strong><\/span> Go to Chart Design &gt; Switch Row\/Column<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-127.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"100% Stacked Column Chart: Percentage Contributions\" class=\"alignnone size-full wp-image-16969\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-127.png\" alt=\"100% Stacked Column Chart: Percentage Contributions\" width=\"630\" height=\"164\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-127.png 630w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-127-300x78.png 300w\" sizes=\"(max-width: 630px) 100vw, 630px\" \/><\/a><\/p>\n<p>Your desired chart will be ready.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/stacked-column-03-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"100% Stacked Column Chart: Percentage Contributions\" class=\"alignnone wp-image-5092 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/stacked-column-03-1.png\" alt=\"100% Stacked Column Chart: Percentage Contributions\" width=\"574\" height=\"383\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/stacked-column-03-1.png 574w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/stacked-column-03-1-300x200.png 300w\" sizes=\"(max-width: 574px) 100vw, 574px\" \/><\/a><\/p>\n<p>There are a variety of charts in Excel can you may find useful. You can take a look at these blogs on <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/charts\/\" target=\"_blank\" rel=\"noopener noreferrer\"><span style=\"color: #0000ff\">Excel Charts<\/span><\/a><\/strong> to know more.<\/p>\n<p><span style=\"color: #0000ff\"><strong>Helpful Resource:<\/strong><\/span><\/p>\n<p><strong>Make sure to download our FREE PDF on the<a href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"noopener noreferrer\"> 333 Excel keyboard Shortcuts here<\/a>:<\/strong><\/p>\n<p><a href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"nofollow noopener\"><img loading=\"lazy\" decoding=\"async\" title=\"How To Use Excel For Dummies\" class=\"aligncenter wp-image-14329 size-medium\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-300x200.jpg\" alt=\"How To Use Excel For Dummies\" width=\"300\" height=\"200\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-300x200.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-1024x682.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-768x512.jpg 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups.jpg 1340w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>You can learn more about how to use Excel by viewing our FREE Excel webinar training on <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-43.html\" target=\"_blank\" rel=\"noopener noreferrer\">Formulas<\/a>, <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-5.html\" target=\"_blank\" rel=\"noopener noreferrer\">Pivot Tables<\/a>, and <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-39.html\" target=\"_blank\" rel=\"noopener noreferrer\">Macros &amp; VBA<\/a>!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel Charts helps you visualize your data to quickly assess information. If you wish to compare a part-to-whole data over time or over different categories, then the Stacked Column Chart is the ultimate tool for you! In this blog, you will learn the following: Stacked Column 100% Stacked Column Customize 100% Stacked Column 3-D 100% [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":14727,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[5,25],"tags":[651,653,94,95,654,650],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/587"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=587"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/587\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/14727"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=587"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=587"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=587"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}