{"id":2236,"date":"2016-03-29T12:28:08","date_gmt":"2016-03-29T10:28:08","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=2236"},"modified":"2023-11-30T21:50:39","modified_gmt":"2023-11-30T20:50:39","slug":"benchmark-chart-in-excel-2010","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/benchmark-chart-in-excel-2010\/","title":{"rendered":"Benchmark Chart in Excel 2010"},"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>I will show you how to do this using Using\u00a0Excel 2010.<br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/ppmpqkczwK0?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><br \/>\n<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\/2016\/01\/Benchmark-Chart-Excel-2010.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<\/span><span class=\"postTitle px-3\">Benchmark-Chart-Excel-2010.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\/2016\/01\/change-chart-type-excel-2010.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Benchmark Chart in Excel 2010\"  class=\"alignnone size-full wp-image-2237\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/01\/change-chart-type-excel-2010.png\" alt=\"Benchmark Chart in Excel 2010\" width=\"231\" height=\"204\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4:<\/strong><\/span> This will bring up the <strong>Change Chart Type<\/strong> dialogue box and you will need to select <strong>Line<\/strong> and <strong>Line with Markers<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/01\/change-chart-type-to-line-excel-20101.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Benchmark Chart in Excel 2010\"  class=\"alignnone size-full wp-image-2239\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/01\/change-chart-type-to-line-excel-20101.png\" alt=\"Benchmark Chart in Excel 2010\" width=\"556\" height=\"380\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/01\/change-chart-type-to-line-excel-20101.png 556w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/01\/change-chart-type-to-line-excel-20101-300x205.png 300w\" sizes=\"(max-width: 556px) 100vw, 556px\" \/><\/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 <strong>Format Data Series<\/strong>\u00a0dialogue box<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 6:<\/strong><\/span> Select the <strong>Marker Options<\/strong> 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\/2016\/01\/marker-options-excel-2010.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Benchmark Chart in Excel 2010\"  class=\"alignnone size-full wp-image-2241\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/01\/marker-options-excel-2010.png\" alt=\"Benchmark Chart in Excel 2010\" width=\"499\" height=\"244\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/01\/marker-options-excel-2010.png 499w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/01\/marker-options-excel-2010-300x147.png 300w\" sizes=\"(max-width: 499px) 100vw, 499px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 7:<\/strong><\/span> Select the <strong>Line Color<\/strong> and choose <strong>No Line and press OK!<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/01\/line-color-excel-2010.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Benchmark Chart in Excel 2010\"  class=\"alignnone size-full wp-image-2240\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/01\/line-color-excel-2010.png\" alt=\"Benchmark Chart in Excel 2010\" width=\"499\" height=\"189\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/01\/line-color-excel-2010.png 499w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/01\/line-color-excel-2010-300x114.png 300w\" sizes=\"(max-width: 499px) 100vw, 499px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"text-decoration: underline; color: #0000ff;\">HELPFUL RESOURCE:\u00a0<\/span><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/004-excel-with-mrexcel-bill-jelen-podcast\/\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" title=\"Vlookup in an Excel Table\"  class=\"alignnone wp-image-1674 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/10\/Bill_Jelen_Podcast_Banner_EXCEL.jpg\" alt=\"Vlookup in an Excel Table\" width=\"728\" height=\"90\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/10\/Bill_Jelen_Podcast_Banner_EXCEL.jpg 728w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/10\/Bill_Jelen_Podcast_Banner_EXCEL-300x37.jpg 300w\" sizes=\"(max-width: 728px) 100vw, 728px\" \/><\/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. I will show you how to do this using Using\u00a0Excel 2010. \ufeff Download excel workbookBenchmark-Chart-Excel-2010.xlsx STEP 1: Enter your data into\u00a0three columns, the month, the actual sales and the [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17316,"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":[94],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/2236"}],"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=2236"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/2236\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17316"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=2236"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=2236"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=2236"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}