What are Excel 3D Maps?
3D map is a new feature provided by excel in its latest versions of 2016 and so on. It is a feature to introduce maps feature in the excel graph axis in three dimensions. It is an extremely useful tool provided by excel which is like an actual functional map. In excel 3D maps, we represent the data either on a globe that can either be international or on smaller scales. It is totally dependent on the type of data.
How to use 3D Maps in Excel?
Let us consider the following data,
Here we have city names of different locations and have the total number of hospitals available in each city and how many hospitals are those hospitals where cancer can be treated. We will try to plot this data on a 3D map using the 3D map feature provided by excel.
- First, select the data we need to plot.
- In the Insert tabInsert TabIn excel “INSERT” tab plays an important role in analyzing the data. Like all the other tabs in the ribbon INSERT tab offers its own features and tools. Under Insert Tab we have several other groups including tables, illustration, add-ins, charts, Power map, sparklines, filters, etc., click on 3D maps under the tours category.
- A dialog box opens up, like the one below.
- Click on open 3D maps, and we see another set of options,
- As I already have a few open in my excel file, so it is showing some additional tours. We need to click on the New tour button provided.
- We need to may wait for a few seconds, and then another excel windows pop up, which looks something like this,
- Click on the new scene in the scenes tab provided.
- It provides us with three options, and we can choose any one of them,
- Let us choose the first one, which is copy scene 1. And on the left-hand side of the window, we can see a box for the scene created.
- Now, we have different field lists, as we saw in the raw data above, displayed on the right-hand side of the window.
- We need to drag the column headers in the respective fields. First drag city into–>Location.
- Now drag a number of hospitals in the heights section, and the number of cancer hospitals has been dragged to the category field.
- While we make these changes, we can see that the Legend entry is changing.
- Now, our 3d Map for the above data is generated.
We can make specific changes in the 3D Map as our requirements.
The above data we took was on a smaller scale. Now let us look at the data on a bigger scale, i.e., on the international level. Have a look at the below data.
We have the above data for five different countries to import and export revenues for the current year. We will represent this data in a geographical globe.
- Step 1 – The first thing we need to do is select the data to give ranges to the 3d Maps.
- Step 2 – Now, in the Insert tab under the tours section, click on 3D maps.
- Step 3 – A wizard box opens up for 3D maps, which gives us two options,
- Step 4 – Click on Open 3D maps, and we can see that different templates have been created earlier. Click on the new tour.
- Step 5 – Click on New scene from the scenes button.
- Step 6 – It will provide us with three options. We will choose the world map as it is international data.
- Step 7 – On the left-hand side, we can see that scene two is created for us.
- Step 8 – Whereas on the right-hand side, we have our field lists. Drag each one of them in the order.
(Note: The range for previous data is also visible as this Map is also created in the same workbook)
- Step 9 – Drag the country to the location box.
- Step 10 – Now drag export & import in billions of data to category and height, respectively,
- Step 11 – Now, we can see that the 3D Map for the above data has been created around the globe.
We can also hover our mouse to see the different parts of the globe to see the different values of data. We can make changes to axis or data and click on refresh data to see changes in the Map as per our requirements.
Things to Remember
- 3D map is not available in excel 2013 or lower version.
- It can be used for smaller scales of data or on a bigger scale or an international scale.
- 3D maps are used to demonstrate data in location format.
- We can use the custom image or global Map provided by excel to represent the data.
This has been a guide to 3D Maps in Excel. Here we will learn how to make 3D Maps in Excel and some practical examples and a downloadable excel template. You may learn more about excel from the following articles –