{"id":366,"date":"2026-04-03T20:52:21","date_gmt":"2026-04-04T00:52:21","guid":{"rendered":"https:\/\/www.exceleffects.com\/excel\/?p=366"},"modified":"2026-04-03T20:52:47","modified_gmt":"2026-04-04T00:52:47","slug":"clustered-column-chart-with-target-line","status":"publish","type":"post","link":"https:\/\/www.exceleffects.com\/excel\/clustered-column-chart-with-target-line\/","title":{"rendered":"Clustered column chart with target line"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1280\" height=\"720\" src=\"https:\/\/www.exceleffects.com\/excel\/wp-content\/uploads\/2026\/04\/clustered-column-chart-target-line-01.png\" alt=\"Clustered column chart with target line - Excel Effects\" class=\"wp-image-368\" srcset=\"https:\/\/www.exceleffects.com\/excel\/wp-content\/uploads\/2026\/04\/clustered-column-chart-target-line-01.png 1280w, https:\/\/www.exceleffects.com\/excel\/wp-content\/uploads\/2026\/04\/clustered-column-chart-target-line-01-768x432.png 768w, https:\/\/www.exceleffects.com\/excel\/wp-content\/uploads\/2026\/04\/clustered-column-chart-target-line-01-600x338.png 600w\" sizes=\"(max-width: 1280px) 100vw, 1280px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Overview of the clustered column chart with target line<\/h2>\n\n\n\n<p>The clustered column chart with target line allows you to compare multiple series to a particular goal. Also, notice how we have the target line go across the entire plot area. Moreover, it is all data generated. Of course, when you download the tool, it is almost like plug-and-play. Just enter your data and watch it go.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading h4\">Download<\/h3>\n\n\n\n<p><span class=\"fw-semibold\">Requirements:<\/span> <a href=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/excel\" target=\"_blank\" rel=\"noreferrer noopener\">Excel<\/a> 2007 or higher or compatible.<\/p>\n\n\n\n<p><a class=\"btn btn-primary rounded-0\" href=\"https:\/\/www.exceleffects.com\/assets\/download?prodID=920289\">Download<\/a><br><span class=\"fw-semibold\">Size:<\/span> 24 kB<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h4 class=\"wp-block-heading\">Related<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.exceleffects.com\/excel\/clustered-column-chart\/\">Clustered column chart<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.exceleffects.com\/excel\/column-chart-with-target-line\/\">Column chart with target line<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.exceleffects.com\/excel\/standard-column-chart\/\">Standard column chart<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>The clustered column chart with target line allows you to compare multiple series to a particular goal.<\/p>\n","protected":false},"author":1,"featured_media":369,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[21],"tags":[28,22],"class_list":["post-366","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-charts","tag-column-charts","tag-free-downloads"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Clustered column chart with target line - Excel Effects<\/title>\n<meta name=\"description\" content=\"The clustered column chart with target line allows you to compare multiple series to a particular goal - https:\/\/www.exceleffects.com\/\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.exceleffects.com\/excel\/clustered-column-chart-with-target-line\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Clustered column chart with target line - Excel Effects\" \/>\n<meta property=\"og:description\" content=\"The clustered column chart with target line allows you to compare multiple series to a particular goal - https:\/\/www.exceleffects.com\/\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.exceleffects.com\/excel\/clustered-column-chart-with-target-line\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Effects\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/exceleffects\" \/>\n<meta property=\"article:published_time\" content=\"2026-04-04T00:52:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-04-04T00:52:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.exceleffects.com\/excel\/wp-content\/uploads\/2026\/04\/clustered-column-chart-target-line-featimg-01.png\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Excel Effects\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@exceleffects\" \/>\n<meta name=\"twitter:site\" content=\"@exceleffects\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Excel Effects\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.exceleffects.com\\\/excel\\\/clustered-column-chart-with-target-line\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.exceleffects.com\\\/excel\\\/clustered-column-chart-with-target-line\\\/\"},\"author\":{\"name\":\"Excel Effects\",\"@id\":\"https:\\\/\\\/www.exceleffects.com\\\/excel\\\/#\\\/schema\\\/person\\\/b6ced46033467b3c779798ed32cc02cd\"},\"headline\":\"Clustered column chart with target line\",\"datePublished\":\"2026-04-04T00:52:21+00:00\",\"dateModified\":\"2026-04-04T00:52:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.exceleffects.com\\\/excel\\\/clustered-column-chart-with-target-line\\\/\"},\"wordCount\":94,\"publisher\":{\"@id\":\"https:\\\/\\\/www.exceleffects.com\\\/excel\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.exceleffects.com\\\/excel\\\/clustered-column-chart-with-target-line\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.exceleffects.com\\\/excel\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/clustered-column-chart-target-line-featimg-01.png\",\"keywords\":[\"column charts\",\"free downloads\"],\"articleSection\":[\"Charts\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.exceleffects.com\\\/excel\\\/clustered-column-chart-with-target-line\\\/\",\"url\":\"https:\\\/\\\/www.exceleffects.com\\\/excel\\\/clustered-column-chart-with-target-line\\\/\",\"name\":\"Clustered column chart with target line - Excel Effects\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.exceleffects.com\\\/excel\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.exceleffects.com\\\/excel\\\/clustered-column-chart-with-target-line\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.exceleffects.com\\\/excel\\\/clustered-column-chart-with-target-line\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.exceleffects.com\\\/excel\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/clustered-column-chart-target-line-featimg-01.png\",\"datePublished\":\"2026-04-04T00:52:21+00:00\",\"dateModified\":\"2026-04-04T00:52:47+00:00\",\"description\":\"The clustered column chart with target line allows you to compare multiple series to a particular goal - https:\\\/\\\/www.exceleffects.com\\\/\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.exceleffects.com\\\/excel\\\/clustered-column-chart-with-target-line\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.exceleffects.com\\\/excel\\\/clustered-column-chart-with-target-line\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.exceleffects.com\\\/excel\\\/clustered-column-chart-with-target-line\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.exceleffects.com\\\/excel\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/clustered-column-chart-target-line-featimg-01.png\",\"contentUrl\":\"https:\\\/\\\/www.exceleffects.com\\\/excel\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/clustered-column-chart-target-line-featimg-01.png\",\"width\":600,\"height\":400},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.exceleffects.com\\\/excel\\\/clustered-column-chart-with-target-line\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.exceleffects.com\\\/excel\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Clustered column chart with target line\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.exceleffects.com\\\/excel\\\/#website\",\"url\":\"https:\\\/\\\/www.exceleffects.com\\\/excel\\\/\",\"name\":\"Excel Effects\",\"description\":\"Creative data tools and unique templates\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.exceleffects.com\\\/excel\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.exceleffects.com\\\/excel\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.exceleffects.com\\\/excel\\\/#organization\",\"name\":\"Excel Effects\",\"url\":\"https:\\\/\\\/www.exceleffects.com\\\/excel\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.exceleffects.com\\\/excel\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.exceleffects.com\\\/excel\\\/wp-content\\\/uploads\\\/2026\\\/03\\\/excel-effects-text-brand.png\",\"contentUrl\":\"https:\\\/\\\/www.exceleffects.com\\\/excel\\\/wp-content\\\/uploads\\\/2026\\\/03\\\/excel-effects-text-brand.png\",\"width\":533,\"height\":533,\"caption\":\"Excel Effects\"},\"image\":{\"@id\":\"https:\\\/\\\/www.exceleffects.com\\\/excel\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/exceleffects\",\"https:\\\/\\\/x.com\\\/exceleffects\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.exceleffects.com\\\/excel\\\/#\\\/schema\\\/person\\\/b6ced46033467b3c779798ed32cc02cd\",\"name\":\"Excel Effects\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f42e3f15e484010bbc8af57b5d86f48e29a3fa43aec2de0220add50dab1ea550?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f42e3f15e484010bbc8af57b5d86f48e29a3fa43aec2de0220add50dab1ea550?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f42e3f15e484010bbc8af57b5d86f48e29a3fa43aec2de0220add50dab1ea550?s=96&d=mm&r=g\",\"caption\":\"Excel Effects\"},\"sameAs\":[\"https:\\\/\\\/www.exceleffects.com\\\/excel\"],\"url\":\"https:\\\/\\\/www.exceleffects.com\\\/excel\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Clustered column chart with target line - Excel Effects","description":"The clustered column chart with target line allows you to compare multiple series to a particular goal - https:\/\/www.exceleffects.com\/","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.exceleffects.com\/excel\/clustered-column-chart-with-target-line\/","og_locale":"en_US","og_type":"article","og_title":"Clustered column chart with target line - Excel Effects","og_description":"The clustered column chart with target line allows you to compare multiple series to a particular goal - https:\/\/www.exceleffects.com\/","og_url":"https:\/\/www.exceleffects.com\/excel\/clustered-column-chart-with-target-line\/","og_site_name":"Excel Effects","article_publisher":"https:\/\/www.facebook.com\/exceleffects","article_published_time":"2026-04-04T00:52:21+00:00","article_modified_time":"2026-04-04T00:52:47+00:00","og_image":[{"width":600,"height":400,"url":"https:\/\/www.exceleffects.com\/excel\/wp-content\/uploads\/2026\/04\/clustered-column-chart-target-line-featimg-01.png","type":"image\/png"}],"author":"Excel Effects","twitter_card":"summary_large_image","twitter_creator":"@exceleffects","twitter_site":"@exceleffects","twitter_misc":{"Written by":"Excel Effects","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.exceleffects.com\/excel\/clustered-column-chart-with-target-line\/#article","isPartOf":{"@id":"https:\/\/www.exceleffects.com\/excel\/clustered-column-chart-with-target-line\/"},"author":{"name":"Excel Effects","@id":"https:\/\/www.exceleffects.com\/excel\/#\/schema\/person\/b6ced46033467b3c779798ed32cc02cd"},"headline":"Clustered column chart with target line","datePublished":"2026-04-04T00:52:21+00:00","dateModified":"2026-04-04T00:52:47+00:00","mainEntityOfPage":{"@id":"https:\/\/www.exceleffects.com\/excel\/clustered-column-chart-with-target-line\/"},"wordCount":94,"publisher":{"@id":"https:\/\/www.exceleffects.com\/excel\/#organization"},"image":{"@id":"https:\/\/www.exceleffects.com\/excel\/clustered-column-chart-with-target-line\/#primaryimage"},"thumbnailUrl":"https:\/\/www.exceleffects.com\/excel\/wp-content\/uploads\/2026\/04\/clustered-column-chart-target-line-featimg-01.png","keywords":["column charts","free downloads"],"articleSection":["Charts"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.exceleffects.com\/excel\/clustered-column-chart-with-target-line\/","url":"https:\/\/www.exceleffects.com\/excel\/clustered-column-chart-with-target-line\/","name":"Clustered column chart with target line - Excel Effects","isPartOf":{"@id":"https:\/\/www.exceleffects.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.exceleffects.com\/excel\/clustered-column-chart-with-target-line\/#primaryimage"},"image":{"@id":"https:\/\/www.exceleffects.com\/excel\/clustered-column-chart-with-target-line\/#primaryimage"},"thumbnailUrl":"https:\/\/www.exceleffects.com\/excel\/wp-content\/uploads\/2026\/04\/clustered-column-chart-target-line-featimg-01.png","datePublished":"2026-04-04T00:52:21+00:00","dateModified":"2026-04-04T00:52:47+00:00","description":"The clustered column chart with target line allows you to compare multiple series to a particular goal - https:\/\/www.exceleffects.com\/","breadcrumb":{"@id":"https:\/\/www.exceleffects.com\/excel\/clustered-column-chart-with-target-line\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.exceleffects.com\/excel\/clustered-column-chart-with-target-line\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.exceleffects.com\/excel\/clustered-column-chart-with-target-line\/#primaryimage","url":"https:\/\/www.exceleffects.com\/excel\/wp-content\/uploads\/2026\/04\/clustered-column-chart-target-line-featimg-01.png","contentUrl":"https:\/\/www.exceleffects.com\/excel\/wp-content\/uploads\/2026\/04\/clustered-column-chart-target-line-featimg-01.png","width":600,"height":400},{"@type":"BreadcrumbList","@id":"https:\/\/www.exceleffects.com\/excel\/clustered-column-chart-with-target-line\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.exceleffects.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Clustered column chart with target line"}]},{"@type":"WebSite","@id":"https:\/\/www.exceleffects.com\/excel\/#website","url":"https:\/\/www.exceleffects.com\/excel\/","name":"Excel Effects","description":"Creative data tools and unique templates","publisher":{"@id":"https:\/\/www.exceleffects.com\/excel\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.exceleffects.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.exceleffects.com\/excel\/#organization","name":"Excel Effects","url":"https:\/\/www.exceleffects.com\/excel\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.exceleffects.com\/excel\/#\/schema\/logo\/image\/","url":"https:\/\/www.exceleffects.com\/excel\/wp-content\/uploads\/2026\/03\/excel-effects-text-brand.png","contentUrl":"https:\/\/www.exceleffects.com\/excel\/wp-content\/uploads\/2026\/03\/excel-effects-text-brand.png","width":533,"height":533,"caption":"Excel Effects"},"image":{"@id":"https:\/\/www.exceleffects.com\/excel\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/exceleffects","https:\/\/x.com\/exceleffects"]},{"@type":"Person","@id":"https:\/\/www.exceleffects.com\/excel\/#\/schema\/person\/b6ced46033467b3c779798ed32cc02cd","name":"Excel Effects","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f42e3f15e484010bbc8af57b5d86f48e29a3fa43aec2de0220add50dab1ea550?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f42e3f15e484010bbc8af57b5d86f48e29a3fa43aec2de0220add50dab1ea550?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f42e3f15e484010bbc8af57b5d86f48e29a3fa43aec2de0220add50dab1ea550?s=96&d=mm&r=g","caption":"Excel Effects"},"sameAs":["https:\/\/www.exceleffects.com\/excel"],"url":"https:\/\/www.exceleffects.com\/excel\/author\/admin\/"}]}},"jetpack_featured_media_url":"https:\/\/www.exceleffects.com\/excel\/wp-content\/uploads\/2026\/04\/clustered-column-chart-target-line-featimg-01.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.exceleffects.com\/excel\/wp-json\/wp\/v2\/posts\/366","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.exceleffects.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.exceleffects.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.exceleffects.com\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.exceleffects.com\/excel\/wp-json\/wp\/v2\/comments?post=366"}],"version-history":[{"count":2,"href":"https:\/\/www.exceleffects.com\/excel\/wp-json\/wp\/v2\/posts\/366\/revisions"}],"predecessor-version":[{"id":370,"href":"https:\/\/www.exceleffects.com\/excel\/wp-json\/wp\/v2\/posts\/366\/revisions\/370"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.exceleffects.com\/excel\/wp-json\/wp\/v2\/media\/369"}],"wp:attachment":[{"href":"https:\/\/www.exceleffects.com\/excel\/wp-json\/wp\/v2\/media?parent=366"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.exceleffects.com\/excel\/wp-json\/wp\/v2\/categories?post=366"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.exceleffects.com\/excel\/wp-json\/wp\/v2\/tags?post=366"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}