How to Map Data in Excel (2 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

Excel has some extremely useful tools for visualizing data. The data map is one of them. Additionally, it is widely used for visualizing different datasets from various fields. If you are looking for some special tricks to map data in Excel, you’ve come to the right place. There are numerous ways to map data in Excel. This article will discuss two suitable methods to map data in Excel. Let’s follow the complete guide to learn all of this.


How to Map Data in Excel: 2 Easy Methods

We will use two effective and tricky methods to map data in Excel. One is to use a map chart for countries or states and the other is to use a 3-D map. This section provides extensive details on the two methods.  You can use either one for your purpose, they both have a wide range of flexibility when it comes to customization. You should learn and apply all of these, as they improve your thinking capability and Excel knowledge.


1. Using Map Chart to Map Data in Excel

Here, we will demonstrate how to data map in Excel. Now we are going to create a map chart of different countries and states without the help of any external tools. We know that Excel has one built-in tool to create charts. Here, we have used two suitable examples so that you will be able to learn how you can apply this method for both countries on the world map and states in a country.


1.1 Map Chart for Countries

Let us first introduce you to our Excel dataset so that you are able to understand what we are trying to accomplish with this article. For demonstration purposes, we are going to use the following dataset.

Using Map chart to Map Data in Excel

Let’s walk through the following steps.

📌 Steps:

  • First of all, select the range of the dataset as shown below.
  • Next, go to the Insert tab from your ribbon.
  • Then, select Maps from the Charts group.
  • Now, select the Filled Map icon from the drop-down list.

  • As a result, you will get the following map chart of countries.

Using Map chart to Map Data in Excel

  • Now, select Style 3 from the Chart Styles if you want to modify it for better visualization.

  • Next, you will get the following map chart of countries.
  • If you want to add data labels, then you need to select Data Labels as shown below image.

Using Map chart to Map Data in Excel

  • Finally, you will be able to get the following map chart of countries.

Using Map chart to Map Data in Excel


1.2 Map Chart for States

Now, we want to use a map chart of states. For demonstration purposes, we are going to use the following dataset.

Using Map chart to Map Data in Excel

Let’s walk through the following steps.

📌 Steps:

  • First of all, select the range of the dataset as shown below.
  • Next, go to the Insert tab from your ribbon.
  • Then, select Maps from the Charts
  • Now, select the Filled Map icon from the drop-down list.

  • As a result, you will get the following map chart of countries.

Using Map chart to Map Data in Excel

  • Now, select Style 3 from the Chart Styles if you want to modify it for better visualization.
  • Next, you will get the following map chart of states.

  • If you want to add data labels, then you need to select Data Labels as shown below image.

Using Map chart to Map Data in Excel

  • Finally, you will be able to get the following map chart of countries.

Read More: How to Make Route Map in Excel


2. Utilizing 3D Map to Map Data in Excel

Now, we will use another method to map data in Excel. Here will utilize a 3D map. For demonstration purposes, we are going to use the following dataset.

Utilizing 3D Map to Map Data in Excel

Let’s walk through the following steps.

📌 Steps:

  • First of all, select the range of the dataset as shown below.
  • Next, go to the Insert tab from your ribbon.
  • Then, select Maps from the Tours group.
  • Now, select the Open 3D Maps icon from the drop-down list

Utilizing 3D Map to Map Data in Excel

  • Next, you have to launch the 3D map by clicking the following highlighted section.

  • If you want to get the 3D map, you have to select Map Labels.
  • As a consequence, you will get the following 3D map.

Utilizing 3D Map to Map Data in Excel

  • Next, if you want to customize the 3D map for better visualization, you have to select Flat Map.
  • As a result, you will get the following customized 3D map.

Utilizing 3D Map to Map Data in Excel

Read More: How to Create a Map in Excel


💬 Things to Remember

✎ The first time you create a map chart in Excel, after you select the Maps option, there will be an open chart with comments such as Accept. If you do not click on the Accept option, you will not get the proper chart.

✎ You have to adjust the row height after following each method.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article. For a clearer understanding, it contains all the datasets and data maps in different spreadsheets.


Conclusion

That’s the end of today’s session. I strongly believe that from now you may be able to map data in Excel. If you have any queries or recommendations, please share them in the comments section below. Keep learning new methods and keep growing!


Related Articles


<< Go Back to Excel Map Chart | Excel Charts | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Saquib Ahmad Shuvo
Saquib Ahmad Shuvo

Saquib Ahmad Bhuiyan, holding a BSc degree in Naval Architecture & Marine Engineering from Bangladesh University of Engineering and Technology, skillfully integrates engineering expertise with a passion for Excel. He provides solutions to complex issues as an Excel & VBA Content Developer for ExcelDemy Forum. He demonstrates an enthusiastic mindset and adeptness in managing critical situations with finesse, showcasing his commitment to excellence. Apart from creating Excel tutorials, he is interested in Data Analysis with MS Excel, Rhinoceros,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo