{"id":517420,"date":"2022-11-28T21:00:51","date_gmt":"2022-11-28T18:00:51","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-use-a-data-table-in-a-microsoft-excel-chart\/"},"modified":"2022-11-28T21:00:51","modified_gmt":"2022-11-28T18:00:51","slug":"how-to-use-a-data-table-in-a-microsoft-excel-chart","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-use-a-data-table-in-a-microsoft-excel-chart\/","title":{"rendered":"#How to Use a Data Table in a Microsoft Excel Chart"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 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-6a407631ce5a1\" 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-6a407631ce5a1\" 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-use-a-data-table-in-a-microsoft-excel-chart\/#%E2%80%9CHow_to_Use_a_Data_Table_in_a_Microsoft_Excel_Chart%E2%80%9D\" >&#8220;How to Use a Data Table in a Microsoft Excel Chart&#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-use-a-data-table-in-a-microsoft-excel-chart\/#Add_a_Data_Table_to_a_Chart_in_Excel\" >Add a Data Table to a Chart in Excel<\/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-use-a-data-table-in-a-microsoft-excel-chart\/#Customize_a_Data_Table_in_Excel\" >Customize a Data Table in Excel<\/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-use-a-data-table-in-a-microsoft-excel-chart\/#Changing_the_Table_Data\" >Changing the Table Data<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1><span class=\"ez-toc-section\" id=\"%E2%80%9CHow_to_Use_a_Data_Table_in_a_Microsoft_Excel_Chart%E2%80%9D\"><\/span>&#8220;How to Use a Data Table in a Microsoft Excel Chart&#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>Select the &#8220;Chart Design&#8221; tab on the ribbon, click the &#8220;Add Chart Element&#8221; button, point to &#8220;Data Table,&#8221; and select the type of table you want to add. Select the &#8220;More Data Table Options&#8221; menu item to further customize your data table.<\/p>\n<p>When you make a graph in Excel, you may want to include the source data with it. By adding a data table, which takes just a few steps, you can provide extra details or further explain your visual.<\/p>\n<p>A data table is a grid of the data you use to create your chart that sits beneath the graph itself. Once you add a data table, you can format and customize it to your liking.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Add_a_Data_Table_to_a_Chart_in_Excel\"><\/span>Add a Data Table to a Chart in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You can add a data table to the most common types of charts in Excel, including\u00a0bar, column, and line. Create your chart as you normally would. When you\u2019re ready to add the data table, select the chart.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Make a Bar Chart in Microsoft Excel<\/em><\/strong><\/p>\n<p>Go to the Chart Design tab that displays and click 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 Table and then choose the type of table you want to add from the pop-out menu. You can choose a table with or without legend keys.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-836861\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/AddElementDataTable-ExcelDataTableChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Data Table types in the Add Chart Element menu\" width=\"649\" height=\"355\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In Excel on Windows, you have an additional way to insert a data table. Click the Chart Elements button (+) on the top right or left corner of the chart. Check the box for Data Table and select the arrow to pick the type of table you want to use.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-836860\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/AddElementDataTableWindows-ExcelDataTableChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Data Table types in the Chart Element menu on Windows\" width=\"650\" height=\"245\" 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 table, you may need to resize your chart by dragging a corner or edge. This helps you give the chart and data table more room which makes them both easier to read.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-836864\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/ResizedChart-ExcelDataTableChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Resized chart and data table in Excel\" width=\"650\" height=\"250\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you decide later to remove the table, return to Chart Design &gt; Add Chart Element and pick \u201cNone\u201d in the Data Table pop-out menu.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Customize_a_Data_Table_in_Excel\"><\/span>Customize a Data Table in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>By default, a data table <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>ears in a grid with borders and a white background. But you can customize the appearance of the table if you like.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Create and Customize a Waterfall Chart in Microsoft Excel<\/em><\/strong><\/p>\n<p>Select the chart, click the Add Chart Element drop-down menu, and move to Data Table. Select \u201cMore Data Table Options\u201d in the pop-out menu.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-836866\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/MoreDataTableOptions-ExcelDataTableChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"More Data Table Options in the Add Chart Element menu\" width=\"649\" height=\"355\" 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 Table sidebar opens, confirm that you\u2019re on the Table Options tab. Then, expand the Data Table Options section to see the borders.<\/p>\n<p>You can check or uncheck the boxes to use horizontal, vertical, or outline borders. If you change your mind about the legend keys, check or uncheck the Show Legend Keys box.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-836875 size-full\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/FormatDataTableOptionsTab-ExcelDataTableChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Border options in the Format Data Table sidebar\" width=\"340\" height=\"390\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To change the fill and border settings, select the Fill &amp; Line tab. You can choose a fill type and pick a color from the palette.<\/p>\n<p>You can do the same thing for the borders directly beneath the data table, plus you can change the border width, line type, transparency, and other settings.<\/p>\n<p>If you\u2019d like to spruce up the data table with a shadow, glow, soft edge, or 3-D effect, head to the Effects tab. Here, you can experiment with different looks for your data table.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-836868 size-full\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/FormatDataTableLineEffects-ExcelDataTableChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Line and Effects in the Format Data Table sidebar\" width=\"537\" height=\"500\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can also change the font that displays within the table. At the top of the sidebar, choose Text Options. Use the Text Fill &amp; Outline and Text Effects tabs to adjust the text fill style, font color, transparency, and effects.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-836879 size-full\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/FormatDataTableTextOptions-ExcelDataTableChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Text options in the Format Data Table sidebar\" width=\"618\" 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=\"Changing_the_Table_Data\"><\/span>Changing the Table Data<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>When you change the source data that appears in the chart, your chart will automatically update. The same goes for the data table within the chart.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-836873\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/ColumnChartDataTable-ExcelDataTableChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Column chart with a data table in Excel\" width=\"650\" height=\"458\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When you want to display the exact details for your Excel chart, consider using a data table. For additional help with graphs in Excel, check out how to apply a chart filter or how to find the chart type that fits your data best.<\/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\/836846\/how-to-use-a-data-table-in-a-microsoft-excel-chart\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;How to Use a Data Table in a Microsoft Excel Chart&#8221; Select the &#8220;Chart Design&#8221; tab on the ribbon, click the &#8220;Add Chart Element&#8221; button, point to &#8220;Data Table,&#8221; and select the type of table you want to add. Select the &#8220;More Data Table Options&#8221; menu item to further customize your data table. When you&#8230;<\/p>\n","protected":false},"author":1,"featured_media":517421,"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-517420","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\/517420","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=517420"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/517420\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/517421"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=517420"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=517420"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=517420"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}