{"id":513051,"date":"2022-11-20T21:00:28","date_gmt":"2022-11-20T18:00:28","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-add-and-customize-data-labels-in-microsoft-excel-charts\/"},"modified":"2022-11-20T21:00:28","modified_gmt":"2022-11-20T18:00:28","slug":"how-to-add-and-customize-data-labels-in-microsoft-excel-charts","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-add-and-customize-data-labels-in-microsoft-excel-charts\/","title":{"rendered":"#How to Add and Customize Data Labels in Microsoft Excel Charts"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a2e9321e80c2\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a2e9321e80c2\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-add-and-customize-data-labels-in-microsoft-excel-charts\/#%E2%80%9CHow_to_Add_and_Customize_Data_Labels_in_Microsoft_Excel_Charts%E2%80%9D\" >&#8220;How to Add and Customize Data Labels in Microsoft Excel Charts&#8221;<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-add-and-customize-data-labels-in-microsoft-excel-charts\/#Add_Data_Labels_to_an_Excel_Chart\" >Add Data Labels to an Excel Chart<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-add-and-customize-data-labels-in-microsoft-excel-charts\/#Adjust_the_Data_Label_Details\" >Adjust the Data Label Details<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-add-and-customize-data-labels-in-microsoft-excel-charts\/#Customize_the_Data_Labels\" >Customize the Data Labels<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1><span class=\"ez-toc-section\" id=\"%E2%80%9CHow_to_Add_and_Customize_Data_Labels_in_Microsoft_Excel_Charts%E2%80%9D\"><\/span>&#8220;How to Add and Customize Data Labels in Microsoft Excel Charts&#8221;<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone wp-image-731027 size-full\" data-pagespeed-no-defer=\"\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel Logo\" width=\"1200\" height=\"675\"\/><\/p>\n<p>While adding a chart in Excel with the Add Chart Element menu, point to Data Labels and select your desired labels to add them. The &#8220;More Data Label Options&#8221; tool will let you customize the labels further. To customize data labels for an existing chart, use the Chart Elements button.<\/p>\n<p>When you create an Excel chart that contains a ton of data, it can be difficult to decipher it all at a glance. One helpful way to point out information is using data labels for a <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/watch-movies-tv-seriess\/\" data-internallinksmanager029f6b8e52c=\"8\" title=\"Watch Movies &amp; TV Series\" target=\"_blank\" rel=\"noopener\">series<\/a> of data points. We\u2019ll show you how to use data labels here.<\/p>\n<p>You can choose which series or points to use data labels for and select their positions. For example, data labels can become part of the bars on a column chart or displayed as callouts on a pie chart.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Add_Data_Labels_to_an_Excel_Chart\"><\/span>Add Data Labels to an Excel Chart<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>A great example of a chart that can benefit from data labels is a <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/762831\/how-to-make-a-pie-chart-in-microsoft-excel\/\">pie chart. Although you can use a legend for the pieces of the pie, you can save space and create an attractive chart using data labels. We\u2019ll use a pie chart for our example.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Make a Pie Chart in Microsoft Excel<\/em><\/strong><\/p>\n<p>Select your pie chart and go to the Chart Design tab that displays. Open the Add Chart Element drop-down menu in the Chart Layouts section of the ribbon.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-836730\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/ChartDesignAddElement-ExcelDataLabels.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Add Chart Elements on the Chart Design tab\" width=\"650\" height=\"90\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Move your cursor to Data Labels and choose a position in the pop-out menu. For a pie chart, you\u2019ll see options like center, inside end, outside end, best fit, and data callout. The available positions may differ depending on the chart type you use.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-836729\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/AddElementsDataLabels-ExcelDataLabels.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Data Label positions\" width=\"650\" height=\"343\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you\u2019re using Excel on Windows, you have an additional way to include data labels on your chart. Select the chart and then click the Chart Elements button (+) in the top right or left corner.<\/p>\n<p>Check the box for Data Labels and use the arrow to the right to pick their positions from the pop-out menu.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-836728\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/AddElementsDataLabelsWindows-ExcelDataLabels.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Data Label positions on Windows\" width=\"650\" height=\"249\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Once you see your data labels on the chart, you can experiment with different positions to get the look you want.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Adjust_the_Data_Label_Details\"><\/span>Adjust the Data Label Details<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>After you add your data labels, you can choose which details to include, such as a category name, a value or percentage, or <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/509290\/how-to-use-cell-values-for-excel-chart-labels\/\">data from specific cells.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Use Cell Values for Excel Chart Labels<\/em><\/strong><\/p>\n<p>Select the chart and return to the Add Chart Element drop-down menu on the Chart Design tab. Move your cursor to Data Labels and pick \u201cMore Data Label Options.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-836732 size-full\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/MoreLabelOptions-ExcelDataLabels.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"More Label Options in the Add Chart Elements menu\" width=\"650\" height=\"343\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When the Format Data Labels sidebar opens, confirm that you\u2019re on the Label Options tab. You can then expand the Label Options section beneath and mark the details you want to display.<\/p>\n<p>You can also include leader lines, add a legend key, and pick a separator type.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-836727\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/LabelOptions-ExcelDataLabels.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Label Options in the Format Data Labels sidebar\" width=\"260\" height=\"500\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Customize_the_Data_Labels\"><\/span>Customize the Data Labels<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Along with the details you want to include in your data labels, you can change their <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">app<\/a>earance in the Format Data Labels sidebar.<\/p>\n<p>At the top of the sidebar, use the different tabs to make your changes. Keep in mind the options vary depending on the data label type. For instance, you can change the fill color and adjust the transparency for data callouts. Other customization options include:<\/p>\n<ul>\n<li><strong>Fill &amp; Line<\/strong>: Add a fill color or border and change the transparency.<\/li>\n<li><strong>Effects<\/strong>: Create a shadow, glow, or 3-D effect.<\/li>\n<li><strong>Size &amp; Properties<\/strong>: Adjust the width and height, change the vertical alignment or text direction, and wrap the text.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-836726\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/FormatDataLabels-ExcelDataLabels.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Format Data Labels appearance options in the sidebar\" width=\"650\" height=\"406\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Once you add your data labels, you may be able to adjust other parts of your chart. For example, you may want to remove the legend or reposition the chart title.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-836725\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/PieChartDataLabels-ExcelDataLabels.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Pie chart with data labels in Excel\" width=\"607\" height=\"369\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you want to remove the data labels later, simply return to Chart Design &gt; Add Chart Elements and choose \u201cNone\u201d for Data Labels.<\/p>\n<p>With data labels, you can give your chart viewers a quick and easy way to read parts of your chart at a glance. For more help with charts in Excel, check out how to\u00a0<a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/763415\/how-to-create-a-chart-template-in-microsoft-excel\/\">create a chart template or how to rename a data series.<\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/836722\/how-to-add-and-customize-data-labels-in-microsoft-excel-charts\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;How to Add and Customize Data Labels in Microsoft Excel Charts&#8221; While adding a chart in Excel with the Add Chart Element menu, point to Data Labels and select your desired labels to add them. The &#8220;More Data Label Options&#8221; tool will let you customize the labels further. To customize data labels for an existing&#8230;<\/p>\n","protected":false},"author":1,"featured_media":513052,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-513051","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/513051","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=513051"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/513051\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/513052"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=513051"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=513051"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=513051"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}