{"id":577,"date":"2014-10-06T16:42:14","date_gmt":"2014-10-06T14:42:14","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=577"},"modified":"2024-04-30T19:28:51","modified_gmt":"2024-04-30T17:28:51","slug":"clustered-column-12-month-trend","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/clustered-column-12-month-trend\/","title":{"rendered":"Clustered Column Chart: 12 Month Trend"},"content":{"rendered":"<p>An Clustered Column <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/marimekko-chart\/\" target=\"_blank\" rel=\"noopener\">chart is used in Excel<\/a> whenever you want to show a periodic trend that has around 12 data points.<\/p>\n<p>To <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/clustered-column-charts-in-excel\/\" target=\"_blank\" rel=\"noopener\">create the Clustered Column<\/a> you have to set our your data with the first column showing the periods and the second column showing the values.<\/p>\n<p>Below I show how easy it is to create such a chart.<br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/onsOw4oW3-A?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<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle 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><br \/>\n<span style=\"color: #0000ff\"><strong><a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Column-12-Month-Trend.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\"><span style=\"color: #0000ff\">download workbook<\/span><\/span><span class=\"postTitle px-3\">Column-12-Month-Trend.xlsx<\/span><\/a><\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #0000ff\"><strong>Helpful Resource:<\/strong><\/span><\/p>\n<p><a href=\"http:\/\/www.mothresource.com\/193-8.html\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-667 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/MOTH-468x90.update.your_.skills.animated.chart_.learn_.online.2.gif\" alt=\"MOTH 468x90.update.your.skills.animated.chart.learn.online.2\" width=\"468\" height=\"90\" title=\"\"><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>An Clustered Column chart is used in Excel whenever you want to show a periodic trend that has around 12 data points. To create the Clustered Column you have to set our your data with the first column showing the periods and the second column showing the values. Below I show how easy it is [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17553,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Clustered Column Chart: 12 Month Trend","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[5,25],"tags":[94,95],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/577"}],"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=577"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/577\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17553"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=577"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=577"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=577"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}