Add Data

Comments are closed

Geocode addresses

Add New Layer

Click on the Add New Layer button.

Select layer type

 

A window with three options will appear. You can use a (pre-) selected range to add as a map layer, an entire Excel data sheet, or a vector map layer in Esri Shape format.

Select your data (From Selection or From Sheet) and click Next.

 

Location-AddressesSelect the Adresses / Zipcodes option.

 

 

 

 

 

 

Location-ColumnsIn the next screen, the names of the columns are shown. If E-Maps recognizes the column name, it will suggest it. If this is not the case, there is the option to select the column. In the address column, the streetname and housenumber can be combined.

Tick the Add result column option, if you are interested in feedback about the geocoding quality.

 

Click Next.

The Layer Options will appear. In this menu, you can give a name to the layer and select a color type.

Select Finish.

Hospitals_mapThe map will appear with the selected data.

 

 

Map points from coordinates

Add Excel data to the map with coordinates

if you have your own coordinates in your data, you can start plotting points on the map richt away.

Add New LayerClick on the Add New Layer button.

 

 

Select layer type A window with three options will appear. You can use a (pre-) selected range to add as a map layer, an entire Excel data sheet, or a vector map layer in Esri Shape format.

Select your data (From Selection or From Sheet) and click Next.

 

Select_location

 

Select the Coordinates option.

 

 

 

 

 

 

Location-CoordinatesSelect the columns that contain the coordinates. If E-Maps recognizes the column names, it will fill in the form for you.

 

 

 

 

E-Maps has a choice of three types: Lat/Long WGS84, Dutch National system and Popular Visualisation.

Coordinate_types

 

 

 

 

Click Next.

Layer optionsThe Layer Options will appear. In this menu, you can give a name to the layer and select a color type.

Select Finish.

 

 

 

The map will appear with the selected data.

Airports_map

 

Create a piechart

Click on Add Data to MapAdd data to Map

In the next screen, you can use two options, to create points on a map, based on coordinates and by geocoding.

piechart select columnsIn the Layer Options, type a layer name and select the option Pie Chart 

After that, select the columns with the data you want to include in the piechart. The data must be numbers larger than zero. The piechart evenly spreads the ranges of the data.

Click Finish.

Piechart in Excel

In layer control, you can personalize the style of the piechart, like color and size.