{"id":447605,"date":"2022-05-15T18:00:41","date_gmt":"2022-05-15T15:00:41","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-make-a-table-in-google-sheets-using-a-table-chart\/"},"modified":"2022-05-15T18:00:41","modified_gmt":"2022-05-15T15:00:41","slug":"how-to-make-a-table-in-google-sheets-using-a-table-chart","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-make-a-table-in-google-sheets-using-a-table-chart\/","title":{"rendered":"#How to Make a Table in Google Sheets Using a Table 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-6a3bbf9cd3b7e\" 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-6a3bbf9cd3b7e\" 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-make-a-table-in-google-sheets-using-a-table-chart\/#%E2%80%9CHow_to_Make_a_Table_in_Google_Sheets_Using_a_Table_Chart%E2%80%9D\" >&#8220;How to Make a Table in Google Sheets Using a Table 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-make-a-table-in-google-sheets-using-a-table-chart\/#Create_a_Table_Chart_in_Google_Sheets\" >Create a Table Chart in Google Sheets<\/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-make-a-table-in-google-sheets-using-a-table-chart\/#Set_Up_the_Table_Chart\" >Set Up the Table Chart<\/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-make-a-table-in-google-sheets-using-a-table-chart\/#Customize_the_Table_Chart\" >Customize the Table Chart<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1><span class=\"ez-toc-section\" id=\"%E2%80%9CHow_to_Make_a_Table_in_Google_Sheets_Using_a_Table_Chart%E2%80%9D\"><\/span>&#8220;How to Make a Table in Google Sheets Using a Table Chart&#8221;<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-731741\" data-pagespeed-lazy-srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 1200w\" sizes=\"auto, 400w, 1200w\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"\" width=\"1200\" height=\"675\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Unlike Microsoft Excel, Google Sheets doesn\u2019t offer an official method for\u00a0inserting a table. As a workaround, you could create what looks like a table using borders and filters, but another option is to use a table chart in Google Sheets.<\/p>\n<p>Even though a spreadsheet is a structured tool for data, tables provide additional benefits. You can sort the data within the table while maintaining the integrity of the non-table data in the sheet. Plus, you can <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>ly shading to alternating rows or other styles that make the table easy to view.<\/p>\n<p>If you have a large amount of data that you want to manipulate, you can use Google Sheets\u2019 pivot table feature. But if you don\u2019t need a tool that extensive, here\u2019s how to create a table chart.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Create_a_Table_Chart_in_Google_Sheets\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_0\">Create a Table Chart in Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Visit <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/docs.google.com\/spreadsheets\/\">Google Sheets<\/a>, sign in, and open the sheet where you want the table chart. Select the data you want to use by dragging your cursor through the cells. You can always adjust this cell range later if needed.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-798875\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/SelectedCells-GoogleSheetsTableChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Selected cells in Google Sheets\" width=\"600\" height=\"281\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Go to Insert in the menu and choose \u201cChart.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-798876\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/InsertChart-GoogleSheetsTableChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Insert a chart in Google Sheets\" width=\"500\" height=\"445\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Google Sheets inserts a default chart type for you and opens the Chart Editor sidebar at the same time. Go to the sidebar and click the Chart Type drop-down box. Scroll to the bottom below the Other category and pick the Table Chart.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-798877\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/TypeTableChart-GoogleSheetsTableChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Table chart type\" width=\"650\" height=\"498\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>The default chart updates automatically to the new table type. You can then adjust the data and the way it displays in the table chart using the Chart Editor sidebar.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-798878\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/TableChart-GoogleSheetsTableChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Table chart in Google Sheets\" width=\"600\" height=\"325\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Make an Organizational Chart in Google Sheets<\/em><\/strong><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Set_Up_the_Table_Chart\"><\/span>Set Up the Table Chart<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you closed the Chart Editor sidebar, you can reopen it easily. Select the chart, click the three dots on the top right of it, and pick \u201cEdit Chart.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-798879\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/EditChart-GoogleSheetsTableChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Edit Chart in the menu\" width=\"650\" height=\"342\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the sidebar, go to the Setup tab to work with the data in the table chart. You can then adjust the following options.<\/p>\n<p><strong>Data Range<\/strong>: Confirm the data range from your sheet, change it, or add to it. To add another range, click the icon on the right side and choose \u201cAdd Another Range\u201d or use one of the suggestions.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-798882\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/DataRange-GoogleSheetsTableChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Data Range for the table chart\" width=\"600\" height=\"484\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p><strong>Series<\/strong>: You can remove the first Series you see and select a different one if you like. This is the data in the far-left column of the table. Optionally, you can check the box to Aggregate the data.<\/p>\n<p>Then, change or remove any of the additional Series for your columns of data. To include another, click the Add Series box and select the cells.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-798881\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/Series-GoogleSheetsTableChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Series for the table chart\" width=\"650\" height=\"292\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p><strong>More Options<\/strong>: At the bottom of the sidebar, you can check the boxes for switching rows and columns, using row 1 as headers, and using column A as labels.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-798880\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/MoreOptions-GoogleSheetsTableChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"More options for the table chart\" width=\"650\" height=\"266\" 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_Table_Chart\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_2\">Customize the Table Chart<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>When you finish fine-tuning the data that appears in the table <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/762481\/how-to-make-a-pie-chart-in-google-sheets\/\">chart, you can customize its appearance. Go to the Customize tab in the Chart Editor sidebar and expand Table. You then have a collection of options you can use if you like.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Make a Pie Chart in Google Sheets<\/em><\/strong><\/p>\n<p><strong>Rows and Numbers<\/strong>: Check the boxes if you want to alternate the row colors or show the row numbers.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-798884\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/AlternatingNumbers-GoogleSheetsTableChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Alternating rows and row numbers\" width=\"650\" height=\"322\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p><strong>Sorting<\/strong>: If you want to use a default column to sort by, you can select it in the drop-down list and optionally check the box for Ascending order. If you don\u2019t pick a default sort column, you can still sort by any column. Simply select the column header to sort and the table will update.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-798885\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/Sort-GoogleSheetsTableChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Sorting for the table chart\" width=\"650\" height=\"326\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p><strong>Pagination<\/strong>: Finally, you can use Pagination if your table contains a lot of data. Then, pick the page size in the corresponding drop-down box from five to 100. This then places both arrows and page numbers at the bottom of the table chart.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-798883\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/Pagination-GoogleSheetsTableChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Pagination for the table chart\" width=\"650\" height=\"322\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Like any other chart or graph in Google Sheets, you can select the table chart and move it wherever you like on the sheet. You can also resize it by dragging in or out from a corner or edge. And, if you update the data in the cell range, the table chart updates automatically.<\/p>\n<p>If you\u2019ve been looking for a way to use a table in Google Sheets, try the table chart. It might just what you need to display your data.<\/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\/798871\/how-to-make-a-table-chart-in-google-sheets-using-a-chart\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;How to Make a Table in Google Sheets Using a Table Chart&#8221; Unlike Microsoft Excel, Google Sheets doesn\u2019t offer an official method for\u00a0inserting a table. As a workaround, you could create what looks like a table using borders and filters, but another option is to use a table chart in Google Sheets. Even though a&#8230;<\/p>\n","protected":false},"author":1,"featured_media":447606,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-447605","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\/447605","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=447605"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/447605\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/447606"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=447605"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=447605"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=447605"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}