Ensure that the Sales 2003 column has a data type of Other Data and click MapPoint will plot the third column (Sales 2003) using column two as the location ZIP code and you'll end up with data locations in Alabama, Iowa, Virginia, and Ohio-not what you want. The second column will probably be wrongly identified as a 3-digit ZIP code if it is, select Other Data from the list. The first column should already be identified as Data Type: State if it's not, select it now. A MapPoint map and the Link Data Wizard dialog, where you tell MapPoint about your data, appear. Select the data, including the headings, and click on the MapPoint button on the Excel toolbar.
Type this data into a range of cells and save your worksheet MapPoint can't use the data until the worksheet is saved. Use the sample data in Figure 1 to create a simple MapPoint map in Excel.
To plot addresses, you need columns for address, city, ZIP code, state, and so on. To plot by county, you need the county and state, in separate columns. To plot by state, you need a column in your data table for the two-character You need a list with enough information for MapPoint to identify locations. How you create and prepare data largely determines how easy it is to map that data. MapPoint can work both within Excel and on its own here we will explore MapPoint's integration with Excel. Microsoft MapPoint 2004 ($299 varies by country) to create map-based charts. But with newer versions, you need special software such as Prior to Excel 2002, Excel contained a tool to create maps from its data. When you're working with geographical data, sooner or later you'll probably want to plot it on a map.
0 kommentar(er)
