If you don’t provide high-level information about your location, Excel might not recognize the place.You need an internet connection to connect to the maps online or to get data from the web and insert them into the maps.However, older versions require using an add-in for that. If you have Microsoft 365 or 2019, you will be able to reach that function. Map chart feature is only available in the latest versions of Excel.We better mention them so that we know what the obstacles would be and how to be more careful using Excel. Limitations of Creating Map Chart in ExcelĮxcel does have some limitations. You can decide how much of the map you want to show, or which geographic names you prefer to display. You can edit map projection, map area, and map labels. Also, if you double click on the map, you will see another button on the right that is used to format the map itself. You will see the options that you can customize.įilling, colors, and other types of formatting could be edited here. Open the formatting table by double-clicking on the map chart.

CustomizeĮxcel arranges the colors by default however, you can format the map chart in your style using design tools. After the preview, click “Ok” to confirm.Įxcel will give you the map chart based on value or category depending on your data. Relatively low values are represented by light colors and higher values are shown with darker colors. Here Excel reads the ZIP codes you entered and creates a map chart based on them. Then on the Insert tab, go to Charts > Maps > Filled Map. Once you finish arranging your data, select the cells you want to turn into the map. You can then add columns to the data, like population or tax rate. Your data will be converted into a geography data type. If you prefer to do that with geography data type input your data which includes geographical values, then go to Data > Data Types > Geography. Enter your data into the spreadsheet with ZIP codes and values write them or copy from somewhere and paste.

Value map shapes and colors the chart based on the values, such as inflation rate category map on the other hand based on categories, such as countries. Also, it should be stated at this point that Excel creates map charts based on either value or category. You can even do that with geography data types as an easier alternative. Provide your existing data to Excel write them manually or copy-paste from a source. Having the data is the very first step to create a map chart. Let’s get started learning how Excel does this step by step. This feature of Excel helps you to make comparisons among geographical regions.

From the various types of charts that Excel can plot, the map is what we are going to talk about in this article. Microsoft Excel is very good at taking certain information and adapting them into your current data.

Power map preview for excel 2013 mac