James likes to learn about technology and share what he learns through his articles.
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.
Next, click on “Trust this add-in.”
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.
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 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.
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.
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.
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 birds-eye view to show landscapes.
- Multiple Data Point Display: With this 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 sets are used the color of each value can be changed.
Change Size of the 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.
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