how to get longitude and latitude coordinates in excel for mac 2016

However, learning GIS systems such as ArcGIS or QGIS looks a bit complex for newbies.

If youd still want to impress your GIS colleagues or just dont have any one around to do your mapping for you were going to discover today a new tool that allows user-friendly and simple creation of dashboards for quick reporting, including some mapping functions.

If you dont have your own data, you can use this example spreadsheet, with data from a school survey in Central African Republic produced by OCHA.

In the Adds-in section, at the bottom, select Excel adds-in in Manage and click the Go button.

This menu will allow you to add the different elements of your dashboard: charts, tiles, and whats interesting to us here, maps.

Excel will automatically select some data to prepare the map, however it will most likely not suggest what youll want.

In this basic example, the location of schools is displayed (Longitude X, Latitude Y) with circles proportional to the number of students (Size NBELEVES).

In fact, the Locations field cannot be empty, even if you dont actually use it to locate your data: if you intend to use XY columns and not addresses like in our example, use a dummy column for the Locations field.

Just make sure youre using a column on which every line has data, e.g.

ID column (if not, the empty lines wont be displayed).

For instance here only the private schools are displayed, using STATUECO column as filter.

You can also display Colour based on Construction type (TYPECONST) to give pointers to your construction team.

Heres a list of potential situations in which you could utilize this new tool.

How To Get Longitude And Latitude Coordinates In Excel For Mac 2016