You also need to make selection of what kind of visualization to use.

Nicks previous tutorial was on Creating and Editing Features with MapInfo.

A little known add-in in Excel is 3D map (known as Power Map in Excel 2013).

As a Microsoft product, 3D Map uses Bing maps as its underlying product and allows you to create either 3D or standard maps overlaid data that can be presented in a variety of different ways.

If you have Excel 2013, these steps walk you through installing the Power Map add-in and creating a couple of very simple maps.

If you are working in Excel 2016, skip ahead to the Plotting Graphs in 3D Map section.

Power Map Excel Manual Installation Is

Installing Power Map add-in for Excel 2013 Please note that Power Map is pre-installed in 2016 (aka 3D Maps in 2016) but that a manual installation is required for Excel 2013.

Unfortunately, Power Map is compatible on Windows operating systems only.

If youre using 2013 and so need to install the add-in: Download the plugin from Microsoft website.

Power Map Excel Download It There

If the URL isnt working for you, search for Power Map Preview for Excel 2013 in Google and go to the link from the Microsofts website and download it there.

Make sure that you download the right version i.e.

Once it has downloaded, launch the installation and follow the on-screen instructions to complete the setup.

After the installation is completed, check the Insert tab for Power Map section with a Map It should be as shown in the screenshot below.

Advertisement If you dont see it as shown above, you might need to activate it in the Add-Ins menu.

In the dropdown at the bottom of the window select COM Add-ins and click GO: Now, check Microsoft Power Map and click on OK button to activate it You have now setup the Power Map Add-in if you are using Excel 2013.

Plotting Graphs in 3D Map Before we start, please note that you should be connected to the internet to use 3D MapPower Map as it will need to access Bing maps to create a base map.

The centroid of a country is automatically used to plot the maps.

For our example data lets use population data for the 50 most populous countries from Wikipedia.

It is available at this link or you can access it from the file below.

Select the table containing the data and click on Insert 3D MapOpen 3D Maps (in Excel 2016) or Insert MapLaunch Power Map (in Excel 2013) Where to access 3D Map in Excel 2016.

This launches the Power Map Window or the 3D Maps window as it is called in Excel 2016 Youll see that first option you get is to choose the geography location.

For Excel 2013 you will then need to click on the NEXT button in the bottom-right corner of the page to be take to the settings menu.

In our case well use the Population (1 July 2016) column, so we should select it.

Power Map Excel For Mac