{"id":609,"date":"2020-07-07T20:28:55","date_gmt":"2020-07-07T18:28:55","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=609"},"modified":"2024-03-22T19:03:06","modified_gmt":"2024-03-22T18:03:06","slug":"clustered-bar-chart-year-over-year-comparison","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/clustered-bar-chart-year-over-year-comparison\/","title":{"rendered":"Clustered Bar Chart &#8211; Year on Year Comparison Chart Excel"},"content":{"rendered":"<p>If you want to compare products or businesses using <strong>Year on Year Comparison Chart<\/strong> <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-excel-templates-and-spreadsheets\/\" target=\"_blank\" rel=\"noopener\">Excel<\/a>, then the <strong>Clustered Bar chart<\/strong> is the one for you.<\/p>\n<h3><strong><a id=\"what-is-a-clustered-bar-chart\"><\/a>What is a Clustered Bar Chart?<\/strong><\/h3>\n<p>Clustered <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/grouped-bar-charts-in-excel\/\" target=\"_blank\" rel=\"noopener\">Bar Chart in Excel<\/a> is used to<strong> display more than one series of data<\/strong> in clustered horizontals columns or bars. They are one of the most common tools used for<strong> a year on year comparison chart<\/strong>.<\/p>\n<p>It is used to compare values across different category or time periods.<\/p>\n<h3><strong><a id=\"advantages-and-disadvantages\"><\/a>Advantages and Disadvantages<\/strong><\/h3>\n<p><strong>Advantages of Clustered Bar Chart<\/strong><\/p>\n<ul>\n<li>It is easy to create a bar chart with <strong>just a\u00a0few clicks<\/strong>.<\/li>\n<li>It can convert complicated numbers into simple charts that are <strong>easy to understand<\/strong>.<\/li>\n<li>It can be used when the<strong> category name is too long<\/strong>.<\/li>\n<li>It can be used to <strong>compare multiple categories<\/strong>.<\/li>\n<\/ul>\n<p><strong>Disadvantages of Clustered Bar Chart<\/strong><\/p>\n<ul>\n<li>If data is too large, it can make the<strong> chart confusing<\/strong><em>.<\/em><\/li>\n<li>It cannot be used when you want to show a portion of a whole.<br \/>\n<em>Here, a <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/pie-charts-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Pie Chart<\/a><\/strong> would be a better option.<\/em><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"create-a-year-on-year-comparison-chart-excel\"><\/a>Create a Year on Year Comparison Chart Excel<\/strong><\/h3>\n<p>Clustered Bar Chart can be used for a year on year comparison chart template. Each bar representing a year is clustered together making the comparison more clear.<\/p>\n<h3>Want to know how to create a Clustered Bar Chart: Year on Year comparison Chart Excel?<\/h3>\n<p>*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/y1rvBOmIDFQ?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\">\ufeff<\/span><\/iframe><\/p>\n<div>\n<div style=\"float: left\"><span style=\"text-decoration: underline\"><strong><a href=\"https:\/\/youtu.be\/y1rvBOmIDFQ\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Watch on YouTube <\/a><\/strong><\/span>and give it a thumbs up &#x1f44d;<\/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\n<p>&nbsp;<\/p>\n<p>Follow the step-by-step tutorial on <strong>How to create a Clustered Bar Chart<\/strong>: Year on Year comparison Chart <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-excel-templates-and-spreadsheets\/\" target=\"_blank\" rel=\"noopener\">Excel Template<\/a> and make sure to download the exercise workbook to follow along:<\/p>\n<p><span style=\"color: #0000ff\"><strong><a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Clustered-Bar.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\"><span class=\"ctaText px-3 text-capitalize\"><span style=\"color: #0000ff\">download workbook<\/span><\/span><span class=\"postTitle px-3\">Clustered-Bar.xlsx<\/span><\/a><\/strong><\/span><\/p>\n<p><strong><span style=\"color: #ff0000\">Example 1:<\/span><\/strong><\/p>\n<p>In the example below the category names relate to companies and I am comparing their sales for 2013 and 2014. Simply looking at this data table will not be very helpful in comparing the data over the year.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Clustered-01.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4569\" title=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Clustered-01.png\" alt=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" width=\"515\" height=\"173\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Clustered-01.png 515w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Clustered-01-300x101.png 300w\" sizes=\"(max-width: 515px) 100vw, 515px\" \/><\/a><\/p>\n<p>Let&#8217;s create a Clustered Bar Chart and make this year on year comparison chart easy to understand.<\/p>\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\/Clustered-01.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4569\" title=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Clustered-01.png\" alt=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" width=\"515\" height=\"173\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Clustered-01.png 515w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Clustered-01-300x101.png 300w\" sizes=\"(max-width: 515px) 100vw, 515px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2<\/strong>:<\/span>\u00a0Go to\u00a0<strong>Insert &gt; Bar\u00a0Chart &gt; Clustered Bar<\/strong><em>.<\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Clustered-02-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5086\" title=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Clustered-02-1.png\" alt=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" width=\"715\" height=\"185\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Clustered-02-1.png 715w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Clustered-02-1-300x78.png 300w\" sizes=\"(max-width: 715px) 100vw, 715px\" \/><\/a><\/p>\n<p>Your <strong>Clustered Year over Year Excel Template<\/strong>\u00a0is now ready:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Clustered-03.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4571 size-full\" title=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Clustered-03.png\" alt=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" width=\"552\" height=\"397\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Clustered-03.png 552w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Clustered-03-300x216.png 300w\" sizes=\"(max-width: 552px) 100vw, 552px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">Example 2:<\/span><\/strong><\/p>\n<p>You can also create this Bar Chart to show Year over Year Growth Chart in Excel and it will look something like this:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-265.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18480\" title=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-265.png\" alt=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" width=\"502\" height=\"311\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-265.png 502w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-265-300x186.png 300w\" sizes=\"(max-width: 502px) 100vw, 502px\" \/><\/a><\/p>\n<p>In this chart, the original orange bars shown the sales amount for the year 2013 and the additional bar on top of that is the additional sales for the year 2014.<\/p>\n<p>Now, let&#8217;s understand how to create this year over year comparison chart using a step-by-step tutorial:<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 1<\/strong>:<\/span> <strong>Select the Table<\/strong> containing the Sales Data for the year 2013 &amp; 2014.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Clustered-01.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4569\" title=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Clustered-01.png\" alt=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" width=\"515\" height=\"173\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Clustered-01.png 515w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Clustered-01-300x101.png 300w\" sizes=\"(max-width: 515px) 100vw, 515px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2<\/strong>:<\/span> Go to<strong> Insert<\/strong> &gt;<strong> Recommended Charts<\/strong>.<\/p>\n<\/div>\n<\/div>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-259.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18474\" title=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-259.png\" alt=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" width=\"796\" height=\"126\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-259.png 796w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-259-300x47.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-259-768x122.png 768w\" sizes=\"(max-width: 796px) 100vw, 796px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3<\/strong>:<\/span> From the <strong>Insert Chart<\/strong> dialog box, select the <strong>All Charts<\/strong> &gt;<strong> Bar Chart<\/strong> &gt; <strong>Clustered Bar Chart<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-260.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18473\" title=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-260.png\" alt=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" width=\"635\" height=\"603\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-260.png 635w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-260-300x285.png 300w\" sizes=\"(max-width: 635px) 100vw, 635px\" \/><\/a><\/p>\n<p><em>You can even select 3D Clustered Bar Chart from the list.<\/em><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 4<\/strong>:<\/span> This will insert a <strong>Simple Clustered Bar Chart<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Clustered-03.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4571 size-full\" title=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Clustered-03.png\" alt=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" width=\"552\" height=\"397\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Clustered-03.png 552w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Clustered-03-300x216.png 300w\" sizes=\"(max-width: 552px) 100vw, 552px\" \/><\/a><\/p>\n<p><em>Now let&#8217;s move to the advanced steps of editing this chart.<\/em><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 5<\/strong>:<\/span> Right-click on the <strong>Bar representing Year 2014<\/strong> and select <strong>Format Data Series<\/strong>.<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-261.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18475\" title=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-261.png\" alt=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" width=\"553\" height=\"374\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-261.png 553w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-261-300x203.png 300w\" sizes=\"(max-width: 553px) 100vw, 553px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 6<\/strong>:<\/span> In the<strong> Format Data Series<\/strong> dialog box, under <strong>Series Overlap<\/strong> scroll to the right towards <strong>100%<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-262.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18477\" title=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-262.png\" alt=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" width=\"285\" height=\"442\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-262.png 285w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-262-193x300.png 193w\" sizes=\"(max-width: 285px) 100vw, 285px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 7<\/strong>:<\/span> Under the <strong>Fill Icon<\/strong>\u00a0tab, select <strong>No Fill<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-263.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18478\" title=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-263.png\" alt=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" width=\"285\" height=\"442\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-263.png 285w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-263-193x300.png 193w\" sizes=\"(max-width: 285px) 100vw, 285px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 8<\/strong>:<\/span> Under the <strong>Border<\/strong> section, select <strong>Solid Line<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-264.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18479\" title=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-264.png\" alt=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" width=\"283\" height=\"498\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-264.png 283w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-264-170x300.png 170w\" sizes=\"(max-width: 283px) 100vw, 283px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 9<\/strong>:<\/span> Your Y<strong>ear over Year Growth Chart<\/strong> in Excel is ready!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-265.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18480\" title=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-265.png\" alt=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" width=\"502\" height=\"311\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-265.png 502w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-265-300x186.png 300w\" sizes=\"(max-width: 502px) 100vw, 502px\" \/><\/a><\/p>\n<p><strong>Interpretation:<\/strong><\/p>\n<p>The solid blue bars indicate the sales amount for each company for the year 2013 and the additional transparent bar on the top indicates the additional sales amount reported in the year 2014.<\/p>\n<p>This chart helps you focus on the <strong>growth achieved by each company<\/strong> and know which company has performed better than the other.<\/p>\n<p>Now that you know how to create year <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/horizontal-bar-chart\/\" target=\"_blank\" rel=\"noopener\">on<\/a> year comparison chart excel using clustered bar, you should read through the next section and understand how to format them.<\/p>\n<p>&nbsp;<\/p>\n<div>\n<div>\n<h3><strong><a id=\"formatting-a-clustered-bar-chart\"><\/a>Formatting a Clustered Bar Chart<\/strong><\/h3>\n<p>You can customize the layout of this year on year comparison chart Excel by following the guide provided below.<\/p>\n<p><strong><span style=\"color: #ff0000\">Change Color of the Bar<\/span><\/strong><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 1:<\/span><\/strong> <strong>Right-click<\/strong> on the Bar (Here, Bar for Year 2014)<\/p>\n<\/div>\n<\/div>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-252.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18460\" title=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-252.png\" alt=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" width=\"702\" height=\"394\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-252.png 702w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-252-300x168.png 300w\" sizes=\"(max-width: 702px) 100vw, 702px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 2:<\/span><\/strong> Select the <strong>Fill Icon<\/strong> and choose the appropriate color.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-254.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-18461 size-full\" title=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-254-e1594155597956.png\" alt=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" width=\"731\" height=\"405\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-254-e1594155597956.png 731w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-254-e1594155597956-300x166.png 300w\" sizes=\"(max-width: 731px) 100vw, 731px\" \/><\/a><\/p>\n<p>You can do the same for the bar representing the year 2013.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-255.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18462\" title=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-255.png\" alt=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" width=\"559\" height=\"350\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-255.png 559w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-255-300x188.png 300w\" sizes=\"(max-width: 559px) 100vw, 559px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">Move Series Up<\/span><\/strong><\/p>\n<p>The clustered chart shows the year 2014 on the top. Let&#8217;s change that and push it below:<\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 1:<\/span><\/strong> Select the <strong>Chart<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-250.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-18458 size-full\" title=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-250-e1594156968477.png\" alt=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" width=\"560\" height=\"350\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-250-e1594156968477.png 560w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-250-e1594156968477-300x188.png 300w\" sizes=\"(max-width: 560px) 100vw, 560px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 2:<\/span><\/strong> Go to <strong>Chart Design<\/strong> &gt; <strong>Select Data<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-256.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18467\" title=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-256.png\" alt=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" width=\"1124\" height=\"127\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-256.png 1124w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-256-300x34.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-256-1024x116.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-256-768x87.png 768w\" sizes=\"(max-width: 1124px) 100vw, 1124px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 3:<\/span><\/strong> In the <strong>Select Data Source<\/strong> dialog box, click on <strong>Year 2013<\/strong> and then select the <strong>Arrow Down<\/strong> button.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-257.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18466\" title=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-257.png\" alt=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" width=\"586\" height=\"325\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-257.png 586w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-257-300x166.png 300w\" sizes=\"(max-width: 586px) 100vw, 586px\" \/><\/a><\/p>\n<p>The Year 2014 is pushed to the bottom. This is how you can rearrange the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/data-bars-color-scales-icon-sets\/\" target=\"_blank\" rel=\"noopener\">data bars<\/a> as per your requirement.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-258.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18465\" title=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-258.png\" alt=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" width=\"555\" height=\"348\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-258.png 555w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-258-300x188.png 300w\" sizes=\"(max-width: 555px) 100vw, 555px\" \/><\/a><\/p>\n<div>\n<div>\n<p><strong><span style=\"color: #ff0000\">Switch Row\/Column<\/span><\/strong><\/p>\n<p>This will swap data over the axis and data plotted on the x-axis will be moved to the y-axis and vice versa. Something doing like, makes the chart easier to comprehend.<\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 1:<\/span><\/strong> Select the <strong>Chart<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-250.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18458\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-250.png\" alt=\"\" width=\"568\" height=\"359\" title=\"\"><\/a><\/p>\n<\/div>\n<p><strong><span style=\"color: #ff0000\">STEP 2:<\/span><\/strong> Go to <strong>Chart Design<\/strong> &gt; <strong>Switch Row\/Column<\/strong><\/p>\n<\/div>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-251.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18459\" title=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-251.png\" alt=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" width=\"1046\" height=\"128\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-251.png 1046w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-251-300x37.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-251-1024x125.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-251-768x94.png 768w\" sizes=\"(max-width: 1046px) 100vw, 1046px\" \/><\/a><\/p>\n<p>This is how the swapped chart will look like:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-248.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18457\" title=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-248.png\" alt=\"Clustered Bar Chart - Year on Year Comparison Chart Excel\" width=\"544\" height=\"338\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-248.png 544w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-248-300x186.png 300w\" sizes=\"(max-width: 544px) 100vw, 544px\" \/><\/a><\/p>\n<h3>Conclusion<\/h3>\n<p>In this article, you have learned how to create <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-microsoft-excel-online-course\/\" target=\"_blank\" rel=\"noopener\">Clustered Bar Chart<\/a> showing year on year comparison, a creative way to show year over year growth, change the color of the bars, move series up or down and switch row\/column.<\/p>\n<p>You can brush up your skills on creating charts by reading through our other blogs on <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/charts\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Excel Charts<\/strong><\/a>.<\/p>\n<p><strong>Further Learning:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/bubble-chart-3-variables-on-a-chart\/\" target=\"_blank\" rel=\"noopener\">Bubble Chart with 3 Variables On A Chart<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/change-chart-type-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener\">Change Chart Type Using Macros In Excel<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/convert-chart-into-image-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener\">Convert Chart into Image Using Macros In Excel<\/a><\/li>\n<\/ul>\n<div>\n<div>\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\" class=\"aligncenter wp-image-14329 size-medium\" title=\"How To Use Excel For Dummies\" 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 <strong><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>,<\/strong> and <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-39.html\" target=\"_blank\" rel=\"noopener noreferrer\">Macros &amp; VBA<\/a><\/strong>!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-5.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/530x300-Pivot.jpg?x85520\" alt=\"Excel Pivot Table\" width=\"530\" height=\"300\" title=\"\"><\/a><\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>If you want to compare products or businesses using Year on Year Comparison Chart Excel, then the Clustered Bar chart is the one for you. What is a Clustered Bar Chart? Clustered Bar Chart in Excel is used to display more than one series of data in clustered horizontals columns or bars. They are one [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":14723,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Clustered Bar Chart - Year on Year Comparison Chart Excel","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[5,28],"tags":[101,94,665,666],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/609"}],"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=609"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/609\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/14723"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=609"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=609"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=609"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}