The tool 3D Maps from Microsoft Excel It is a very used function in those jobs statistics or demographic in which it is necessary to indicate data related to geographic locations.
To use this function you will not need to have advanced knowledge in handling a template calculation. But you should know all the secrets that this powerful tool hides.
We have prepared this post so that you can make, in a few steps, a custom 3D map as an expert. Do not miss any detail, since each one will help you obtain greater advantages and save time on your task.
What are the best tools we have to make 3D maps in Excel?
The main tool you have to make this type of maps is called “3D Maps”. This function allows you to incorporate data into a map with 3d effect, that is, you can use a mapping from Excel to include items you have in a spreadsheet.
One of the great advantages of this function is that you can use it anywhere in the world. You will only need to incorporate data that are related to a geographic location.
When you use this tool, other functions are activated that will help you configure the map to suit your needs.. Among these tools you will be able to find the one to modify a theme so that it has a different relief.
In addition, you will be able to have functions that will allow you to obtain a 2D plan, to incorporate text boxes or customize regions. If you prefer, you have the option of access a map display by means of the tool Walk.
What should we take into account before making a 3-dimensional map in Excel?
To make a map in 3D in a spreadsheet of Excel must have a table that refers to a geographic location. That is, one of the columns It must include countries, cities, postal code, streets, longitude, latitude, variable X or variable Y.
In case you don’t include this type of data, you will not be able to activate the customization tool 3D for maps.
Steps to create all kinds of custom maps in Microsoft Excel fast and easy
The steps you will have to perform to create a custom map in Excel are the following:
Create a data table
The first thing you should do is make a painting. In the first column you will have to add the cities or geographical areas and in the second, values numerical.
When you have the column ready, you must select it to continue with the next step:
Tap on the 3D Map function
At this time you will have to go to the tab “Insert” and find the group “Walks”. Next, you must click on “3D map”.
After a few seconds a second window will open in which you will find a map with cities or geographic areas what do they do included in the table.
Define the fields
At right margin on the screen you will find different functions that are divided by layers. The first thing you should do is drag with the mouse the title of the first column and locate it in a field called “High”. Next, you must do the same with the second column in which you must incorporate the title to a category.
You must bear in mind that you can modify location not only by cities or states, but also by latitude, longitude, country, street and postal code, among others. For Modify this range you will need to click on the arrow located at the end of the box “Location”.
Set up the map
What you should do at this time is choose different options to configure the Map according to your needs.
This means that you can choose if you want to add labels to the map, have a flat map, modify the themes or include different shapes to the columns.
To achieve these options you will have to use the tools located in the top of screen.
If you have any questions, leave them in the comments, we will answer you as soon as possible, and it will surely be of great help to more members of the community. Thank you! 😉