{"id":2133,"date":"2015-12-11T16:32:20","date_gmt":"2015-12-11T15:32:20","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=2133"},"modified":"2023-11-30T21:48:27","modified_gmt":"2023-11-30T20:48:27","slug":"benchmark-chart-in-excel-2013","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/benchmark-chart-in-excel-2013\/","title":{"rendered":"Benchmark Chart in Excel 2013"},"content":{"rendered":"<p>Benchmark Charts or Budget Charts are a great way to show your actual sales versus your benchmark in a graphical way, highlighting\u00a0the strong v weak months.<\/p>\n<p>There are a few steps but in Excel 2013 it has been made much easier to create these charts with the new Combo charts.<\/p>\n<p><br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/r7mBcpchLXA?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; 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><\/p>\n<p><span style=\"text-decoration: underline; color: #0000ff;\"><a class=\"IRPP_minimalist icon-download\" style=\"color: #0000ff; text-decoration: underline;\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/12\/Benchmark-Chart.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<\/span><span class=\"postTitle px-3\">Benchmark-Chart.xlsx<\/span><\/a><\/span><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> <strong>Enter your data into\u00a0three columns<\/strong>, the month, the actual sales and the benchmark sales<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span> Click inside your data and go to the ribbon and choose<strong> Insert &gt; 2-D Clustered Column<\/strong><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong><\/span> Select the Benchmark series chart and <strong>Right Click and choose the Change Series Chart Type<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/12\/change-series-chart-type.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Benchmark Chart in Excel 2013\"  class=\"alignnone size-full wp-image-2137\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/12\/change-series-chart-type.png\" alt=\"Benchmark Chart in Excel 2013\" width=\"224\" height=\"212\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4:<\/strong><\/span> This will automatically take you to the Combo chart box and you need to select the drop down for the Benchmark and <strong>select <em>Line with Markers<\/em><\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/12\/line-with-markers.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Benchmark Chart in Excel 2013\"  class=\"alignnone size-full wp-image-2138\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/12\/line-with-markers.png\" alt=\"Benchmark Chart in Excel 2013\" width=\"651\" height=\"876\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/12\/line-with-markers.png 651w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/12\/line-with-markers-223x300.png 223w\" sizes=\"(max-width: 651px) 100vw, 651px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 5:<\/strong><\/span> Click on the line chart and press <strong>CTRL+1<\/strong>. \u00a0This will open up the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/charts\/formatting-charts\/\" target=\"_blank\" rel=\"noopener\">Format Chart<\/a> dialogue box<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 6:<\/strong><\/span> Select the Line option and choose <strong>No Line<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/12\/no-line.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Benchmark Chart in Excel 2013\"  class=\"alignnone size-full wp-image-2139\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/12\/no-line.png\" alt=\"Benchmark Chart in Excel 2013\" width=\"285\" height=\"268\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 7:<\/strong><\/span> Select the Marker Options and choose <strong>Built In, select the horizontal line type and increase the Size to 10<\/strong>. \u00a0You can also format the color of the line.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/12\/marker-options.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Benchmark Chart in Excel 2013\"  class=\"alignnone size-full wp-image-2140\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/12\/marker-options.png\" alt=\"Benchmark Chart in Excel 2013\" width=\"285\" height=\"312\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/12\/marker-options.png 285w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/12\/marker-options-274x300.png 274w\" sizes=\"(max-width: 285px) 100vw, 285px\" \/><\/a><\/p>\n<p>&nbsp;<\/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>Benchmark Charts or Budget Charts are a great way to show your actual sales versus your benchmark in a graphical way, highlighting\u00a0the strong v weak months. There are a few steps but in Excel 2013 it has been made much easier to create these charts with the new Combo charts. \ufeff Download excel workbookBenchmark-Chart.xlsx STEP [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17217,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Benchmark Chart in Excel 2013","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\/2133"}],"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=2133"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/2133\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17217"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=2133"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=2133"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=2133"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}