Use a Shapefile in E-Maps

SHP (Shapefile) is a vector file format associated with a geographic information system (GIS) software program. The SHP format was developed by Esri (Environmental Systems Research Institute) with the aim of increasing interoperability with other GIS software programs. SHP files with polygons (area’s) can be used to create thematic maps in Excel E-Maps.

See the tutorial how to import the map and create thematic shading (choropleth).

MapExport2

Bar charts

Delft_bar

Bar_chart_delft

Excel E-maps has a new bar chart or column bar graph function. The bar chart has vertical rectangular bars with lengths proportional to the values that they represent.

The size, color and transparancy can be adjusted.

Dutch hospital top 100

AD ziekenhuis top 100

The Netherlands

Dutch newspaper ‘Algemeen Dagblad’ has publicised her annual hospital test.

You will find the results plotted on a map where you can find this years’ score in the outer circle and the results of 2013 in the inner.

Explanation of the used colors: The redder, the worse, the greener the better the score.

 

In E-Maps we used two thematic maps with different diameter on top of each other.

AD_ZKH_2014_randstad

Randstad

legend

Check the results of the scan in the AD newspaper.