Database Reference
In-Depth Information
You can convert your data range to named Excel tables by clicking anywhere inside your
data range and pressing Ctrl+T. In the Create Table dialog box, ensure that the range for
the table is correct and click OK.
Tip
The data you utilize needs at least one geographical data point per row, as shown in Figure 6-2. You
don't necessarily need a full address along with the latitude and longitude. Power Map accepts any
combination (but at least) of one of these geographic points:
➤ Latitude/Longitude pair
➤ City name
➤ Country name
➤ Zip code/postal code
➤ State/province name
➤ Address
Figure 6-2:
Start with a named Excel table that contains at least one valid geographic data column.
Whenever you can, use Latitude and Longitude as your geographic points. Latitude/
Longitude processes much faster than standard address elements. You also get better
plotting accuracy.
Tip
When your data is ready to go, click the Map button on the Insert tab. Excel immediately opens the
Power Map window and starts processing the geographic points in the table. It passes the points to
Microsoft Bing, receives the geospatial data back, and then draws a plot point on the map.
After all points have been plotted, you see the window shown in Figure 6-3. There are three main
sections: the Tour task pane, an interactive Bing map, and the Layer Manager task pane.
Search WWH ::
Custom Search