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