3D Maps In Excel

Article byWallstreetmojo Team
Edited bySheeba M
Reviewed byDheeraj Vaidya, CFA, FRM

What Are Excel 3D Maps?

3D Maps in Excel are a new feature provided by Excel in its latest versions of 2016. It introduces map elements in the Excel graph axis in three dimensions, like an actual functional map.  

In Excel 3D Maps, we represent the data on a globe that can either be international or on smaller scales. Therefore, it is dependent on the type of data.

For example, we can create a 3D Map with color coding for different dimensions or layers, as shown in the image below.

3D Maps in Excel

You are free to use this image on your website, templates, etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: 3D Maps In Excel (wallstreetmojo.com)

Key Takeaways

  • 3D Maps in Excel is a feature to represent large data, such as the comparison of population between different countries or regions, and geographical details, in the form of Maps & Globes.
  • The Excel 3D Maps introduced in Excel 2016 are inbuilt in the same version and above. We can use it in Excel 2013 by downloading it from the Microsoft Website, or enabling the “Power Maps” Add-in.
  • These three-dimensional Maps are used to demonstrate data in location format. Also, we can custom images or global maps provided by Excel to represent the data.

How To Use 3D Maps In Excel?

We can use 3D Maps in Excel as follows,

First, choose the dataset – select the “Insert” tab – go to the “Tours” group – click the “3D Map” option drop-down – select the “Open 3D Maps” option, as shown below.

–>> If you want to learn Excel and VBA professionally, then ​Excel VBA All in One Courses Bundle​ (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.

Examples

We will consider some examples to create 3D Maps in Excel.

Example #1

Let us consider the following data.

Here, we have city names of different locations, the total number of hospitals available in each city, and how many hospitals are where cancer is treated. Now, we will plot this data on a 3D Map using the 3D Map feature provided by Excel.

  1. First, select the data we need to plot.


    3D Maps Excel Example 1

  2. In the “Insert” tab, click on “3D Map” under the “Tours” category.


    3D Maps Excel Example 2-2

  3. A dialog box opens up, like the one below.


    3D Maps Excel Example 1-2

  4. Click on Open 3D Maps, and we see another set of options.


    3D Maps Excel Example 1-3

  5. We already have a few open in my Excel file, which shows some additional tours. But first, we must click on the “New Tour” button provided.


    3D Maps Excel Example 1-4

  6. We must wait for some time, then another window pops up that looks like shown.


    3D Maps Excel Example 1-5

  7. Click the “New Scene” in the “Scene” tab provided.


    3D Maps Excel Example 1-6

  8. It provides us with three options. We can choose any one of them.


    3D Maps Excel Example 1-7

  9. Let us choose the first one, which is copy scene 1. Then, we can see a box for the scene on the window’s left-hand side.


    3D Maps Excel Example 1-8

  10. Now, we have different field lists, as we saw in the raw data above, displayed on the right-hand side of the window.


    3D Maps Excel Example 1-9

  11. Drag the column headers in the respective fields. First, drag the city into – Location.

  12. Now, drag several hospitals in the heights section. The number of cancer hospitals has been dragged to the category field.


    3D Maps Excel Example 1-10

  13. While we make these changes, we see that the Legend entry is changing.


    3D Maps Excel Example 1-11

  14. Now, our 3D Map for the above data is generated, as shown below.


    3D Maps Excel Example 1-12

We can make specific changes in the 3D Map to our requirements.

Example #2

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. First, have a look at the below information.

3D Maps Excel Example 2

We have the above data for five countries to import and export revenues for the current year. We will represent this data in a geographical globe, as shown in the following steps:

  • Step 1 – We first must select the data to give ranges to the 3D Maps.
3D Maps Excel Example 2-1
  • Step 2 – Now, in the “Insert” tab under the tours section, click on “3D Map.”
3D Maps Excel Example 2-2
  • Step 3 – A wizard box opens for 3D Maps, giving us two options.
3D Maps Excel Example 2-3
  • Step 4 – Click “Open 3D Maps.” We can see that different templates have been created earlier. Click on the “New Tour.”
Example 2-4
  • Step 5 – Click on the “New Scene” from the scenes button.
Example 2-5
  • Step 6 – It will provide us with three options. First, we will choose the “World Map” as it is international data.
Example 2-6
  • Step 7 – On the left-hand side, we see that scene two is created for us.
Example 2-7
  • Step 8 – We have our field lists on the right-hand side. Drag each one of them in the order.
Example 2-8

(Note: The range for previous data is also visible as this map is created in the same workbook).

  • Step 9 – Drag the country to the location box.
  • Step 10 – Now, drag export and import billions of data to category and height, respectively.
Example 2-9
  • Step 11 – Now, we can see that the 3D Map for the above data has been created around the globe.
Example 2-10

We can also hover our mouse to see the different parts of the globe and the various data values. We can make changes to the axis or data, and click on refresh data to see the changes in the map as per our requirements.

Important Things To Note

  • The 3D Maps are not available in the earlier versions than Excel 2013.
  • One can use it for more minor scales of data, on a bigger scale, or an international scale.

Frequently Asked Questions

1. What is the purpose of 3D Maps in Excel?

The 3D Maps in Excel help users to graphically visualize the country or region-wise data. w.r.t population or any other category in an organized, arranged manner. It is useful when we have to showcase huge data which cannot be done using normal graphs.  

2. How to insert 3D Maps in Excel?

We can use 3D Maps in Excel as follows,
First, choose the cell range – select the “Insert” tab – go to the “Tours” group – click the “3D Map” option drop-down – select the “Open 3D Maps” option, as shown below.
3D Map in Excel - FAQ 2

3. 3D Maps in Excel are not found or not working.

A few reasons why 3D Maps in Excel may not work are,
The Excel version we are using maybe below 2013, as it was introduced in the 2016 version.
The “Power Map add-in” is not enabled in MS Excel. We can enable as follows,
Select the “File” tab – “Options”, to open the “Excel Options” window.
In the “Excel Options” window, choose “Add-Ins” on the left and the “Microsoft Power Map for Excel” on the right, as shown below.
3D Map in Excel - FAQ 3 - Add ins

Then, in the window below, choose the “COM Add-ins” from the “Manage:” field drop-down, and click the “Go…” option, as shown below.

3D Map in Excel - FAQ 3 - com add ins

Finally, the “COM Add-ins” dialog box opens. Check/tick the “Microsoft Power Map for Excel” checkbox, and click “OK”, to close the dialog box.

3D Map in Excel - FAQ 3 - power map
Once again, click “OK” to close the “Excel Options” window.
Thus, the 3D Maps are enabled to use.

Download Template

This article must help understand 3D Maps in Excel with its formulas and examples. You can download the template here to use it instantly.

You can download this 3D Maps Excel Template here – 3D Maps Excel Template

Recommended Articles

This article is a guide to 3D Maps in Excel. Here, we learn to create 3D Maps, in Excel 2016, 2013 & earlier versions, examples & downloadable excel template. You may learn more about excel from the following articles: –

Reader Interactions

Leave a Reply

Your email address will not be published. Required fields are marked *