How to Activate and Use the Bing Maps Add-in in Excel - TurboFuture - Technology
Updated date:

How to Activate and Use the Bing Maps Add-in in Excel

James likes to learn about technology and share what he learns through his articles.

A Bing MAP in Excel

how-to-activate-and-use-the-bing-maps-add-in-in-excel

Using the Bing Maps Add-in Within Excel

Creating a map with locations and being able to differentiate those locations may take some creative skills that you don’t want to learn. One option for creating locations on a map is by using the Bing Maps add-in in Microsoft Excel. This tutorial shows how to activate the add-in, how to display data on a map, and some options that you have at your disposal to tweak the results. This add-in is limited in options and not as dynamic as some people expect it to be, but it can serve as a quick map maker for personal or business use.

Activate the Add-in

First, click on the insert tab, then click on the Bing icon in the add-ins section.

Bing Add-in

how-to-activate-and-use-the-bing-maps-add-in-in-excel

Next, click on “Trust this add-in.”

Trust Add-in

how-to-activate-and-use-the-bing-maps-add-in-in-excel

Add Your Data to the Map

A map appears with your current location based on your IP address. Here you have the opportunity to insert data. Click that X to the right of the map to close out the box that displays “Welcome to Bing Maps,” unless you would like to see an example of how you can show pie graphs displaying revenue/expenses for different locations around the world.

Close the Sample

how-to-activate-and-use-the-bing-maps-add-in-in-excel

One Data Value

The data that you provide need to be formatted like the table in the example below. The rows must contain the locations, the column(s) contain that value that you would like to compare, and the header for the column is right of above that data.

After the data is complete, select all the data and click on the pin button at the top of the map. Each location should display on the map with its related value. Click on any of the points on the map to bring up specific data about that location.

One Data Value

how-to-activate-and-use-the-bing-maps-add-in-in-excel

Multiple Data Values

Using multiple data values in columns yields the same results as the previous example except that each type of value is color coded on a legend and the color of the pin values depend on the highest value.

Multiple Data Values

how-to-activate-and-use-the-bing-maps-add-in-in-excel

Filter by Location

To filter data by location, click the filter icon at the top of the map. Uncheck any boxes of locations that you would like to exclude from the map. These locations can be added back by revisiting the filter and clicking their check boxes.

Filter Option

how-to-activate-and-use-the-bing-maps-add-in-in-excel

Change Settings

There are four different settings that can reflect changes on the map. Each of those changes are described below:

  • Map Type- By default, the Bing road map is used when the map is first created. You do have the option to switch to a bird eye view to show landscapes.
  • Multiple Data Point Display- With setting you can toggle between pie graphs and pins for location identifiers when multiple data is used.
  • Show Legend- Map legend can be removed or added back.
  • Customize Pin- When multiple data are used the color of each value can be changed.

Settings Options

how-to-activate-and-use-the-bing-maps-add-in-in-excel

Change Size of MaP

There are two ways to change the size of the map. One way is to increase the area of the map by dragging the corners or sides of the map. Another way is to use zoom in on the map with the -/+ signs in the upper right-hand corner of the map.

Change Size of Map

how-to-activate-and-use-the-bing-maps-add-in-in-excel

This article is accurate and true to the best of the author’s knowledge. Content is for informational or entertainment purposes only and does not substitute for personal counsel or professional advice in business, financial, legal, or technical matters.

© 2019 James Smith