World logo

Mapping-Tools logo MileCharter

Create Mileage Charts with Microsoft MapPoint®

Guided Tour: 'Atlas' Charts

This guided tour shows you how to use MPMileCharter for MapPoint to create a variety of mileage tables. A similar tour is available for MileCharter for Maptitude.

Table of distances between some major European cities

Easy to create "Road Atlas" style tables.

'Road atlas' tables use a list of places (locations) for the start and end points. The result is a table that is very similar to the driving tables seen in road atlases.

Some major European cities in MapPoint

MPMileCharter created the above table of distances between a selection of major European cities. The following screenshots show the process.

Pushpins were inserted into a Microsoft® MapPoint® map for the required cities. These could also be imported from an Excel® spreadsheet, Access® database, or a text file.

Screenshot of MPMileCharter just before the above table was created

MPMileCharter is started. The same pushpin set was selected for both the start and finish locations to produce the 'atlas' table. Options for a lower-right table with kilometers are selected. Compute is pressed and the table is created in about two minutes.

Rectangular version of the distance table

The above example produces a 'lower triangle' mileage chart, where each city pair is only represented with one calculated distance. usually this is sufficient, but MPMileCharter can also produce a full rectangular mileage chart (see right) which records distances for every city pair in both directions. One-way streets and frontage roads are the usual causes for route distances that vary according to direction.

These examples use Microsoft Excel for the output. MPMileCharter can also write to a series of text files, one for each attribute (distance, travel time, route cost, rate table cost). Text file separator characters can be commas (ie. CSV), semi-colons, or tab characters.

Similar "road atlas" style charts can be created for any locations in North America or Europe. As well as cities, you could find distances between towns, offices, depots, or customers.

Next, we look at zipcodes and other locations.

Buy MPMileCharter for MapPoint Now!