Show/Hide Toolbars

Ultra Mileage

Navigation: Ultra MileCharter

Using Points in an Excel Workbook

Scroll Prev Top Next More

When selecting input locations from a Microsoft Excel workbook, the Input Locations dialog box will look like this:

 

mchart_in_excel

 

Both the source and destination locations have to be stored in the same workbook. Typically these would be in their own worksheets. Also, Ultra MileCharter does not currently support geocoding, so all locations have to be specified using decimal longitude, latitude coordinates.

 

Select the input workbook using the '...' button to the right of the Excel Workbook File box at the top.

 

Then select the input worksheets for the source and destination locations. For each, select the data columns in the boxes on the right. Three columns have to be selected: Longitude, Latitude, and Name. The name refers to how this location will be labeled in the output chart. As well as a string name, you can use a numeric identifier.

 

Typically, an Excel table will use the first row for column headers. If this is the case, set the respective First Row Contains Column Headers check box.

 

The box in the lower left specifies what has been set, and what still needs to be set.

 

Press OK when all of the Excels settings have been specified, to return back to the main dialog box.