{"id":334675,"date":"2021-09-03T18:00:10","date_gmt":"2021-09-03T15:00:10","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-create-a-geographical-map-chart-in-google-sheets\/"},"modified":"2021-09-03T18:00:10","modified_gmt":"2021-09-03T15:00:10","slug":"how-to-create-a-geographical-map-chart-in-google-sheets","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-create-a-geographical-map-chart-in-google-sheets\/","title":{"rendered":"#How to Create a Geographical Map Chart in Google Sheets"},"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-6a32b42398dce\" 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-6a32b42398dce\" 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-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-create-a-geographical-map-chart-in-google-sheets\/#Insert_a_Map_Chart_in_Google_Sheets\" >Insert a Map 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-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-create-a-geographical-map-chart-in-google-sheets\/#Customize_a_Map_Chart_in_Google_Sheets\" >Customize a Map 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-create-a-geographical-map-chart-in-google-sheets\/#Edit_a_Map_Chart_in_Google_Sheets\" >Edit a Map 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-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-create-a-geographical-map-chart-in-google-sheets\/#Add_or_Remove_Data_for_the_Map_Chart\" >Add or Remove Data for the Map Chart<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-create-a-geographical-map-chart-in-google-sheets\/#Additional_Map_Chart_Options\" >Additional Map Chart Options<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Create a Geographical Map Chart in Google Sheets&#8221;<\/strong><\/p>\n<div>\n<!-- UNCACHED CONTENT --><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone wp-image-744534 size-full\" srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/WorldMapChart-GoogleSheetsMapChart.png?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/WorldMapChart-GoogleSheetsMapChart.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 1200w\" sizes=\"auto, 400w, 1200w\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/WorldMapChart-GoogleSheetsMapChart.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"World Map Chart in Google Sheets\" width=\"1200\" height=\"675\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Do you have a lot of\u00a0geographical data in Google Sheets? Why not use a map chart to create a wonderful visual display of your data? You can insert, customize, and edit a map chart easily in Google Sheets.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Insert_a_Map_Chart_in_Google_Sheets\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_0\">Insert a Map Chart in Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Head to <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/docs.google.com\/spreadsheets\/\">Google Sheets<\/a>, sign in, and open your spreadsheet. Select the data you want to use in the map chart. You can do this easily by clicking and dragging your cursor through the range of cells.<\/p>\n<p>Then, click Insert &gt; Chart from the top menu.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-744538\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/InsertChart-GoogleSheetsMapChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Insert, then select Chart\" width=\"483\" height=\"418\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Google Sheets will pop a default chart type into your sheet. So the first thing you need to do is change the chart type in the Chart Editor sidebar that displays.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Make a Graph in Google Sheets<\/em><\/strong><\/p>\n<p>On the Setup tab, click the \u201cChart Type\u201d drop-down box and scroll down to the Map section. You can choose from a Geo Chart or a Geo Chart With Markers. We\u2019ll use the latter for this tutorial. This is something you can change later if you like.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-744537\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/SetupChartTypeMap-GoogleSheetsMapChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Choose a Map chart type\" width=\"650\" height=\"343\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019ll see the chart update to the map chart type you select. Next, you can customize the chart.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Customize_a_Map_Chart_in_Google_Sheets\"><\/span>Customize a Map Chart in Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you\u2019ve already closed the sidebar, you can reopen it easily. Select your chart, click the three dots on the top right, and select \u201cEdit Chart.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-744544\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/EditChart-GoogleSheetsMapChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click the three dots in the top-right corner and pick Edit Chart\" width=\"175\" height=\"268\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>With the Chart Editor sidebar open, click the \u201cCustomize\u201d tab at the top.<\/p>\n<p>To change the chart colors and font, expand the \u201cChart Style\u201d section. Use the drop-down boxes to select a Background Color, Chart Border Color, and Font per your preferences.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-744543\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/CustomizeChartStyle-GoogleSheetsMapChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Customize the chart style in Google Sheets\" width=\"650\" height=\"323\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To change the region and colors for the region, expand the Geo section. Use the Region drop-down list to focus your map. You can pick from eight regions including Africa, Asia, Europe, and the United States.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-744542\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/CustomizeChartGeoRegion-GoogleSheetsMapChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select a region for the map chart\" width=\"650\" height=\"359\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>The region you select obviously depends on the location data in your sheet. For our example, we\u2019ll select the United States since this is where our data is located.<\/p>\n<p>Next, you can adjust the colors for the Min, Mid, Max, and No Value items on the map. Just be sure to use colors that are easy for your audience to see.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-744541\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/CustomizeChartGeo-GoogleSheetsMapChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Customize the chart geo style in Google Sheets\" width=\"650\" height=\"339\" 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=\"Edit_a_Map_Chart_in_Google_Sheets\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_2\">Edit a Map Chart in Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You can edit any of the customizations you make above at any time. But if you want to change the chart type or data range, or work with longitude and latitude, then use the Setup tab in the Chart Editor sidebar.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-744549 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/SetupChart-GoogleSheetsMapChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Setup tab to edit the map chart in Google Sheets\" width=\"252\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To move the chart, select it and drag it where you want it on your sheet. Or to resize the chart, select it and drag from one of the corners or edges.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Add_or_Remove_Data_for_the_Map_Chart\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_3\">Add or Remove Data for the Map Chart<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The nice thing about the map chart in Google Sheets is that you can add or remove data from your sheet and the chart updates automatically.<\/p>\n<p>Below, we added a couple more cities that popped right onto the map. When we add the final one, Salt Lake City, the chart updates to show the location.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-744546\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/AddChartDataCity-GoogleSheetsMapChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Add chart data to make it appear in the map\" width=\"650\" height=\"306\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Then when we add the corresponding data, the marker fills with the correct color per the value.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-744547\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/AddChartDataValue-GoogleSheetsMapChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Add more chart data to complete the image\" width=\"650\" height=\"306\" 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=\"Additional_Map_Chart_Options\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_4\">Additional Map Chart Options<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You have a few additional options for the map chart you create in Google Sheets. Click the three dots on the top right of the chart and you\u2019ll see these actions.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-744548\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/ChartOptions-GoogleSheetsMapChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Map Chart Options in Google Sheets\" width=\"611\" height=\"381\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<ul>\n<li><strong>Edit Chart<\/strong>: Opens the Chart Editor sidebar.<\/li>\n<li><strong>Delete Chart<\/strong>: Removes the chart from the sheet.<\/li>\n<li><strong>Download<\/strong>: Allows you to download the chart as an image or PDF.<\/li>\n<li><strong>Publish Chart<\/strong>: Helps you publish the chart online.<\/li>\n<li><strong>Copy Chart<\/strong>: Places the chart on your clipboard to paste elsewhere.<\/li>\n<li><strong>Move to Own Sheet<\/strong>: Removes the chart from the current sheet and places it on a new one.<\/li>\n<li><strong>Alt Text<\/strong>: Lets you add alternative text to the chart.<\/li>\n<\/ul>\n<p>The next time you\u2019re working with location data in Google Sheets, consider displaying it in a neat and clean <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/713632\/how-to-create-a-geographical-map-chart-in-microsoft-excel\/\">geographical map chart.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Create a Geographical Map Chart in Microsoft Excel<\/em><\/strong><\/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\/744526\/how-to-create-a-geographical-map-chart-in-google-sheets\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Create a Geographical Map Chart in Google Sheets&#8221; Do you have a lot of\u00a0geographical data in Google Sheets? Why not use a map chart to create a wonderful visual display of your data? You can insert, customize, and edit a map chart easily in Google Sheets. Insert a Map Chart in Google Sheets&#8230;<\/p>\n","protected":false},"author":1,"featured_media":334676,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/WorldMapChart-GoogleSheetsMapChart.png?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-334675","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\/334675","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=334675"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/334675\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/334676"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=334675"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=334675"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=334675"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}