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.
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.
2 Easy Methods to Map Data in Excel
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 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.
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.
- 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.
- Finally, you will be able to get the following map chart of countries.
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.
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.
- 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.
- Finally, you will be able to get the following map chart of countries.
Read More: How to Make Route Map in Excel (2 Simple Ways)
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.
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
- 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.
- 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.
Read More: How to Create a Map in Excel (2 Easy Methods)
💬 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 row height after following each method.
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.
Don’t forget to check our website Exceldemy.com for various Excel-related problems and solutions. Keep learning new methods and keep growing!
