Excel 2016 visualize data on Bing maps

preview_player
Показать описание
1. If you do not have the Bing Add-In installed, you can find it by clicking on the Apps for Office button.
2. Search for Bing then select and click on Trust IT.

3. If you have a Microsoft account and have signed in, you can install the app using the below steps:

You will be asked to sign-in, if you have not done so already.
In case you do not have a Microsoft account, then click on Sign In, enter you email address and click Next.
Should the email not be registered, then sign up by clicking on Sign Up in the top right corner.
4. Highlight your entire data range within your Excel worksheet.

5. If the Bing Map is already installed, click on Apps for Office and select Bing Maps under my Apps.

6. A full size map will appear. Click the X to close the prompt.

7. Click on the Show Locations button on the top of the Bing Map to display the values on the map.
8. To view an amount, click on the bubble.
Рекомендации по теме
Комментарии
Автор

May I ask ? Do you use Text Format or what for Latitude and Longitude column ? I tried with text with no luck. Thank you

airlanggabhumintaraamitaba
Автор

Do you need the Long/Lat or can an address be enough?

clebo
Автор

jo puchha hai woh batana... any of hte video is not helping me out.

Veronica_shashi