{"id":2338,"date":"2016-02-12T14:02:23","date_gmt":"2016-02-12T13:02:23","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=2338"},"modified":"2023-11-30T21:46:31","modified_gmt":"2023-11-30T20:46:31","slug":"custom-chart-labels-using-excel-2013","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/custom-chart-labels-using-excel-2013\/","title":{"rendered":"Custom Chart Labels Using Excel 2013"},"content":{"rendered":"<p>In a previous blog post we created a Benchmark <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/venn-diagram-in-excel\/\" target=\"_blank\" rel=\"noopener\">Chart using Excel<\/a> 2013. \u00a0We are going to extend this concept and add some cool looking custom chart labels to make our chart more informative.<\/p>\n<p><span style=\"text-decoration: underline;\"><span style=\"color: #0000ff;\"><a style=\"color: #0000ff; text-decoration: underline;\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/benchmark-chart-in-excel-2013\/\" target=\"_blank\" rel=\"noopener noreferrer\">View the Benchmark Chart using Excel 2013<\/a><\/span><\/span><\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/9Fk7Ca8V-so?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\/02\/Custom-Chart-Labels.xlsx\" rel=\"\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<\/span><span class=\"postTitle px-3\">Custom-Chart-Labels.xlsx<\/span><\/a><\/span><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong> <\/span>We added a % Variance column in our data and inserted symbols\u00a0\u25b2\u25bc to show a negative and positive variance<\/p>\n<p><span style=\"text-decoration: underline; color: #0000ff;\"><a style=\"color: #0000ff; text-decoration: underline;\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/add-custom-symbols-with-your-numbers-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">** You can see the tutorial of how this is done here **<\/a><\/span><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/variance-table.png\" rel=\"attachment wp-att-2339\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Custom Chart Labels Using Excel 2013\"  class=\"alignnone size-full wp-image-2339\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/variance-table.png\" alt=\"Custom Chart Labels Using Excel 2013\" width=\"427\" height=\"386\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/variance-table.png 427w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/variance-table-300x271.png 300w\" sizes=\"(max-width: 427px) 100vw, 427px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span> In our graph\u00a0we need to select the Sales chart and<strong> Right Click and choose Add Data Labels<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/add-data-labels.png\" rel=\"attachment wp-att-2340\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Custom Chart Labels Using Excel 2013\"  class=\"alignnone size-full wp-image-2340\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/add-data-labels.png\" alt=\"Custom Chart Labels Using Excel 2013\" width=\"202\" height=\"200\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/add-data-labels.png 202w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/add-data-labels-150x150.png 150w\" sizes=\"(max-width: 202px) 100vw, 202px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong><\/span> We then need to select one Data Label with our mouse and press <strong>CTRL + 1 to bring up the Format Data Labels dialogue box<\/strong><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4:<\/strong><\/span> From the\u00a0Format Data Labels dialogue box we need to select the<strong> Value From Cells box<\/strong>\u00a0<strong>only<\/strong> and make sure no other boxes are ticked<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/format-data-labels.png\" rel=\"attachment wp-att-2341\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Custom Chart Labels Using Excel 2013\"  class=\"alignnone size-full wp-image-2341\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/format-data-labels.png\" alt=\"Custom Chart Labels Using Excel 2013\" width=\"285\" height=\"500\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/format-data-labels.png 285w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/format-data-labels-171x300.png 171w\" sizes=\"(max-width: 285px) 100vw, 285px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 5:<\/strong> <\/span>This will bring up a <strong>Data Label Range<\/strong> dialogue box. \u00a0If it does not show, then you need to select the <strong>Select Range&#8230;<\/strong> button. \u00a0From here you need to select the Variance data range and press OK.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/data-label-range.png\" rel=\"attachment wp-att-2344\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Custom Chart Labels Using Excel 2013\"  class=\"alignnone size-full wp-image-2344\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/data-label-range.png\" alt=\"Custom Chart Labels Using Excel 2013\" width=\"352\" height=\"401\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/data-label-range.png 352w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/data-label-range-263x300.png 263w\" sizes=\"(max-width: 352px) 100vw, 352px\" \/><\/a><\/p>\n<p>Your cool looking chart labels are now on your chart!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/chart.png\" rel=\"attachment wp-att-2342\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Custom Chart Labels Using Excel 2013\"  class=\"alignnone size-full wp-image-2342\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/chart.png\" alt=\"Custom Chart Labels Using Excel 2013\" width=\"635\" height=\"423\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/chart.png 635w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/chart-300x200.png 300w\" sizes=\"(max-width: 635px) 100vw, 635px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/007-data-cleansing-analysis-with-oz-du-soleil-excel-podcast\/\" target=\"_blank\" rel=\"attachment noopener wp-att-2280 noreferrer\"><img loading=\"lazy\" decoding=\"async\" title=\"Unpivot Data Using Excel Power Query\"  class=\"alignnone wp-image-2280 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/Oz_Podcast_Banner.jpg\" alt=\"Unpivot Data Using Excel Power Query\" width=\"728\" height=\"90\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/Oz_Podcast_Banner.jpg 728w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/Oz_Podcast_Banner-300x37.jpg 300w\" sizes=\"(max-width: 728px) 100vw, 728px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In a previous blog post we created a Benchmark Chart using Excel 2013. \u00a0We are going to extend this concept and add some cool looking custom chart labels to make our chart more informative. View the Benchmark Chart using Excel 2013 \ufeff Download excel workbookCustom-Chart-Labels.xlsx STEP 1: We added a % Variance column in our [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17720,"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\/2338"}],"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=2338"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/2338\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17720"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=2338"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=2338"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=2338"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}