Activating and Using the Bing Maps Add-in in MS Excel

Updated on January 14, 2020
Joshua Crowder profile image

Joshua has work experience in manufacturing, distribution, and aerospace. He received his BBA in accounting from Kent State University.

Bing Maps Add-in

After activation in Microsoft Excel, the Bing Maps Add-in will appear within the worksheet that you are using at the time it is inserted. This Map can be paired with a table to display locations and attributes about those locations.
After activation in Microsoft Excel, the Bing Maps Add-in will appear within the worksheet that you are using at the time it is inserted. This Map can be paired with a table to display locations and attributes about those locations.

The Bing Maps Add-in can be utilized to show locations on a map with corresponding attributes that describe those locations. Additionally, locations can be visually distinguished by their numeric attributes with varying sizes of location markers. For example, If you have a business in three different countries, you can easily create a Bing Map in Excel to plot a marker for each location where the sizes of the markers will display in different sizes. The varying sizes can be based on the revenue or some other numeric figure to show how each location varies from each other.

Next we'll look at the steps used to insert a Bing Map into an Excel spreadsheet.

Insert the Map

To insert a Bing Map, first click on the insert tab, then click on the Bing Maps Add-in button from the add-ins section of the ribbon. The button is hard to miss because it looks like the Bing logo.

Insert Bing Maps Add-in

If your version of Microsoft Excel does not have the Bing Maps Add-in find the add-ins section under the insert tab and click on the "Get Add-ins" button. Use the search bar to search for Bing. Here you will be able to download the application.
If your version of Microsoft Excel does not have the Bing Maps Add-in find the add-ins section under the insert tab and click on the "Get Add-ins" button. Use the search bar to search for Bing. Here you will be able to download the application.

Activate the Map by Trusting the Add-in

Click on the button that says "Trust this add-in" to get the map to appear.

Trust the Add-in

Microsoft has you trust the Bing Maps Add-in to assure that you understand that your data is not private. Remember that the Bing Maps Add-in has access to any content in the workbook that it is running in.
Microsoft has you trust the Bing Maps Add-in to assure that you understand that your data is not private. Remember that the Bing Maps Add-in has access to any content in the workbook that it is running in.

Below is what you should see after you trust the add-in. To make the add-in useful, data needs to be added to the map. Otherwise, a the map will hot have any location markers or functionality.

Bing Map

Adding Location Data to the Map

Generally, you have two main options for displaying your data on your Bing Map.

You may want to just show categorical data. In this case, the locations would be the only data to display on the map with a marker.

In another instance, you can have the categorical and numeric data. For example, showing company locations and the revenue for each location would represent this scenario.

Once you add locations to a column in Excel and numeric data related to that those locations in a column to the right, you can select that range of data and click the location icon on the Bing Map. This will save the data to the Bing Map.

Below is an illustration of how to set up your columns and where to find the location icon. If you only want to show the categorical information, you would only select the location column.

One Categorical Variable and One Numeric Variable Example

The Bing Map works best when used with data that needs to display locations. Locations can be determined by zip code, city, region or even by country. The map can be utilized to mark locations in any country in the world.
The Bing Map works best when used with data that needs to display locations. Locations can be determined by zip code, city, region or even by country. The map can be utilized to mark locations in any country in the world.

Adding Multiple Numeric Data

You can add more than one piece of numeric data. Adding multiple columns of numeric data to your table can allow your Bing Maps user to look at the data with more dimensions.

One Categorical Variable and Multiple Numeric Variables Example

Creating Location Filters

There is a feature that allows you to filter the specific views by limiting the number of locations that will be plotted on the map. This feature can be opened by clicking on the filter icon on the map tool bar.

Filter Settings

Bing Map Settings

Use the Bing Maps settings to create a map look that is best for your audience. The settings that can be changed include:

  • Map type
  • Data Point Display type
  • Optional Legend
  • Color of markers

Bing Map Settings

Increase Map Size and Zoom

Lastly, you can change the map size by dragging the corners of the ma[ inward or outward. The magnification of the map can also be changed with the use of the zoom buttons.

Changing Map Zoom and Size

This content is accurate and true to the best of the author’s knowledge and is not meant to substitute for formal and individualized advice from a qualified professional.

© 2020 Joshua Crowder

Comments

    0 of 8192 characters used
    Post Comment

    No comments yet.

    working

    This website uses cookies

    As a user in the EEA, your approval is needed on a few things. To provide a better website experience, turbofuture.com uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

    For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at: https://maven.io/company/pages/privacy

    Show Details
    Necessary
    HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
    LoginThis is necessary to sign in to the HubPages Service.
    Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
    AkismetThis is used to detect comment spam. (Privacy Policy)
    HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
    HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
    Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
    CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
    Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the googleapis.com or gstatic.com domains, for performance and efficiency reasons. (Privacy Policy)
    Features
    Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
    Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
    Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
    Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
    Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
    VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
    PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
    Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
    MavenThis supports the Maven widget and search functionality. (Privacy Policy)
    Marketing
    Google AdSenseThis is an ad network. (Privacy Policy)
    Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
    Index ExchangeThis is an ad network. (Privacy Policy)
    SovrnThis is an ad network. (Privacy Policy)
    Facebook AdsThis is an ad network. (Privacy Policy)
    Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
    AppNexusThis is an ad network. (Privacy Policy)
    OpenxThis is an ad network. (Privacy Policy)
    Rubicon ProjectThis is an ad network. (Privacy Policy)
    TripleLiftThis is an ad network. (Privacy Policy)
    Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
    Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
    Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
    Statistics
    Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
    ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
    Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)
    ClickscoThis is a data management platform studying reader behavior (Privacy Policy)