What are Excel 3D Maps?

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

How to use 3D Maps in Excel?

Example #1

Let us consider the following data.

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

  • First, select the data we need to plot. In the “Insert” tab, click on “3D Map” 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. We already have a few open in my Excel file, which shows some additional tours. But first, we need to click on the “New Tour” button provided. We need to wait for a few seconds. Then, another Excel window pops up, which may look like this. Click on the “New Scene” in the “Scene” tab provided. It provides us with three options. We can choose any one of them. 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. 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 the city into -> Location. Now, drag several hospitals in the heights section. The number of cancer hospitals has been dragged to the category field. While we make these changes, we see that the Legend entry is changing. Now, our 3D map for the above data is generated.

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.

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.

  • Step 1 – We first must select the data to give ranges to the 3D maps.

  • Step 2 – Now, in the “Insert” tab under the tours section, click on “3D Map.”

  • Step 3 – A wizard box opens for 3D maps, giving us two options.

  • Step 4 – Click on “Open 3D Maps.” We can see that different templates have been created earlier. Click on the “New Tour.”

  • Step 5 – Click on the “New Scene” from the scenes button.

  • Step 6 – It will provide us with three options. First, we will choose the “World Map” as it is international data.

  • Step 7 – On the left-hand side, we see that scene two is created for us.

  • Step 8 – We have our field lists on the right-hand side. Drag each one of them in the order.

(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.

  • 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 and the various data values. We can make changes to the axis or data and click on refresh data to see changes in the map per our requirements.

Things to Remember

  • The 3D maps are not available in Excel 2013 or the lower version.One can use it for more minor scales of data or on a bigger scale or an international scale.The 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 article is a guide to 3D Maps in Excel. Here, we will learn how to make 3D Maps in Excel, practical examples, and a downloadable Excel template. You may learn more about excel from the following articles: –

  • What are Maps in Power BI?How to Animate Excel Charts?Marimekko Chart in ExcelUse 3D Reference in ExcelChange Chart Style In Excel