Bing Maps app for Office helps you use location data from a given column and plot it on a Bing Map. It also provides basic data visualization using your location data.
Plot: Once you launch the app from insert->app, you will see a default map embedded into your Excel spreadsheet. You can select locations from a column and click on the pin icon at the top right to plot them. The header for the column must be selected and the locations should be continuous valued below the header.
Data visualization: You can also select adjacent columns to the right of locations containing data that you want to visualize on the map. If cells from a single adjacent data column is selected, locations are plotted with different sized circles. If multiple data columns are selected, you have the option to either plot them as multiple circles or a pie chart. This can be controlled by clicking on settings icon on the top right.
Map Controls: You can use the map controls displayed on the top left to pan in a direction or to zoom in/out. Alternatively you can also zoom the map using your mouse or touch. Map view can be changed from settings to either road or birds eye.