{"id":203947,"date":"2021-03-16T13:24:30","date_gmt":"2021-03-16T10:24:30","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-create-a-geographical-map-chart-in-microsoft-excel\/"},"modified":"2021-03-16T13:24:30","modified_gmt":"2021-03-16T10:24:30","slug":"how-to-create-a-geographical-map-chart-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-create-a-geographical-map-chart-in-microsoft-excel\/","title":{"rendered":"#How to Create a Geographical Map Chart in Microsoft Excel"},"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-6a2695f0cd1ab\" 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-6a2695f0cd1ab\" 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-microsoft-excel\/#Get_Your_Data_Ready\" >Get Your Data Ready<\/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-microsoft-excel\/#Create_the_Map_Chart\" >Create the Map 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-create-a-geographical-map-chart-in-microsoft-excel\/#Format_the_Map_Chart\" >Format the Map Chart<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-create-a-geographical-map-chart-in-microsoft-excel\/#Add_a_Title\" >Add a Title<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-create-a-geographical-map-chart-in-microsoft-excel\/#Include_Data_Labels\" >Include Data Labels<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-create-a-geographical-map-chart-in-microsoft-excel\/#Insert_a_Legend\" >Insert a Legend<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-create-a-geographical-map-chart-in-microsoft-excel\/#Apply_a_Style\" >Apply a Style<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-create-a-geographical-map-chart-in-microsoft-excel\/#Move_Resize_Edit_or_Delete_the_Map\" >Move, Resize, Edit, or Delete the Map<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Create a Geographical Map Chart in Microsoft Excel&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-713634\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/02\/MapChartInExcel-Featured.png\" alt=\"Map Chart in Microsoft Excel\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Charts are helpful for visual displays of your data. They can make viewing and analyzing data easier, especially for your audience. So for geographical data, why not use the map chart type in Microsoft Excel?<\/p>\n<p>Whether you want to display populations in several countries for your sales team or abbreviations for the United States for your elementary school class, you can create a map chart easily in Microsoft Excel. You can then format it with labels, a legend, and an <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>ropriate color scheme.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Get_Your_Data_Ready\"><\/span>Get Your Data Ready<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Like with other chart types in Microsoft Excel, it\u2019s best to start with populated data. This allows you to select the cells containing that data and simply insert the chart for it.<\/p>\n<p>Select a single data type for the map. Like the examples listed above, this can be the population or abbreviation that you can obtain from the built-in geography data type in Excel. Or, alternately, it might be your sales amounts, number of stores, average operating costs, or other data you have already prepared in your spreadsheet.<\/p>\n<p>While you can use the chart for smaller areas, such as cities, the map won\u2019t be as effective. You\u2019ll only see dots representing those types of locations. The map chart in Excel works best with large areas like counties, states, regions, countries, and continents.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Create_the_Map_Chart\"><\/span>Create the Map Chart<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>When you\u2019re ready to create the map chart, select your data by dragging through the cells, open the \u201cInsert\u201d tab, and move to the \u201cCharts\u201d section of the ribbon. Click the drop-down for \u201cMaps\u201d and choose \u201cFilled Map.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-713635\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/02\/InsertChartFilledMap-Excel.png\" alt=\"Click Insert, Filled Map\" width=\"650\" height=\"311\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Your newly created chart will pop right onto your sheet with your data mapped.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-713636\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/02\/MapChartWithData-Excel.png\" alt=\"Map Chart with Data in Excel\" width=\"650\" height=\"310\" 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=\"Format_the_Map_Chart\"><\/span>Format the Map Chart<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The next steps include formatting your map to include useful components and a color scheme. You can add a title, some labels, a legend, and a style.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Add_a_Title\"><\/span>Add a Title<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>If your map contains the default \u201cChart Title,\u201d you can simply click that text box on the map and type in your own title. If the map does not include a title, you can add one easily as well as changing its position.<\/p>\n<p>Select the chart and click \u201cChart Elements\u201d (\u201c+\u201d icon) on the right. Check the box for \u201cChart Title,\u201d then enter the title in the text box that appears on the map.<\/p>\n<p>Hover your cursor over the arrow to the right of \u201cChart Title\u201d in the Chart Elements box and choose a different position for the title if you like.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-713746 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/02\/MapCheckChartTitle-Excel.png\" alt=\"Map Chart Title\" width=\"650\" height=\"239\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can also select \u201cMore Title Options,\u201d which will display a sidebar on the right. In this spot, you can choose the position, use a fill color, or apply a text outline.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-713637\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/02\/MapChartTitleOptions-Excel.png\" alt=\"Format the Chart Title\" width=\"650\" height=\"241\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Include_Data_Labels\"><\/span>Include Data Labels<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>If the data you\u2019re displaying on the map is small enough, you may want to include data labels. These will show the data directly on each map location.<\/p>\n<p>Select the chart and click \u201cChart Elements\u201d on the right. Check the box for \u201cData Labels.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-713639\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/02\/MapChartDataLabels-Excel.png\" alt=\"Add Chart Data Labels\" width=\"650\" height=\"231\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To adjust the text and options for the labels, select \u201cMore Data Label Options.\u201d Like with the chart title, the right-hand sidebar will open with formatting features for the labels.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-713640\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/02\/MapChartDataLabelsMore-Excel.png\" alt=\"Format Chart Data Labels\" width=\"650\" height=\"243\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Insert_a_Legend\"><\/span>Insert a Legend<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>One more helpful element for almost any chart is a legend. This useful tool is a key to the data that displays on the chart.<\/p>\n<p>Select the chart and click \u201cChart Elements\u201d on the right. Check the box for \u201cLegend.\u201d<\/p>\n<p>Hover your cursor over the arrow to the right of \u201cLegend\u201d in the Chart Elements box and choose a position for the legend.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-713642\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/02\/MapChartLegend-Excel.png\" alt=\"Add a Legend\" width=\"650\" height=\"237\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can also select \u201cMore Legend Options\u201d to open the sidebar and format the text and additional options.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-713641\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/02\/MapChartLegendOptions-Excel.png\" alt=\"Format the Legend\" width=\"650\" height=\"252\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Apply_a_Style\"><\/span>Apply a Style<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>The map chart is pretty basic in its color, but you can spruce it up with a theme or color scheme.<\/p>\n<p>Select the chart and click \u201cChart Styles\u201d (found on the paintbrush) on the right. Click \u201cStyles\u201d to scroll through premade themes or \u201cColor\u201d to pick a colorful or monochromatic scheme.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-713644\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/02\/MapChartStyle-Excel.png\" alt=\"Apply a Chart Style\" width=\"650\" height=\"375\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Whichever you choose, you\u2019ll see your map update im<a href=\"https:\/\/buradabiliyorum.com\/en\/category\/social-mediaa\/\" data-internallinksmanager029f6b8e52c=\"1\" title=\"Social Media\" target=\"_blank\" rel=\"noopener\">media<\/a>tely.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Move_Resize_Edit_or_Delete_the_Map\"><\/span>Move, Resize, Edit, or Delete the Map<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You can easily move the map chart anywhere you want on your sheet. Just select and drag it to its new spot. If you want to prevent changes, you can lock the Microsoft Excel chart in place. And to resize the chart, drag one of the corners or edges.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-713643\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/02\/MapChartResize-Excel.png\" alt=\"Resize a Chart in Excel\" width=\"631\" height=\"391\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To edit the data that displays on the map, for example, if you add more locations, right-click the chart and click \u201cSelect Data.\u201d Alternatively, you can go to the \u201cChart Design\u201d tab and click \u201cSelect Data\u201d in the ribbon.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-713646\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/02\/MapChartSelectData-Excel.png\" alt=\"Right-click and Pick Select Data or use the ribbon button\" width=\"650\" height=\"554\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Enter the cells in the \u201cChart Data Range\u201d box at the top, or drag your cursor through the cells. Click \u201cOK\u201d when you finish.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-713645\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/02\/MapChartSelectDataRange-Excel.png\" alt=\"Edit the Chart Data Range\" width=\"650\" height=\"337\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you decide that you don\u2019t want to use the map chart after all, you can remove it easily. Select the chart and hit your Delete key or right-click and pick \u201cCut.\u201d<\/p>\n<hr\/>\n<p>If you want to display geographical data on your Excel sheet, the map chart is a terrific visual tool. For other types of data, take a look at how to make a bar chart in Microsoft Excel.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Make a Bar 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\/713632\/how-to-create-a-geographical-map-chart-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Create a Geographical Map Chart in Microsoft Excel&#8221; Charts are helpful for visual displays of your data. They can make viewing and analyzing data easier, especially for your audience. So for geographical data, why not use the map chart type in Microsoft Excel? Whether you want to display populations in several countries for&#8230;<\/p>\n","protected":false},"author":1,"featured_media":203948,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/02\/MapChartInExcel-Featured.png?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-203947","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\/203947","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=203947"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/203947\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/203948"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=203947"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=203947"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=203947"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}