Plotting Latitude and Longitude onto a map in excel

[stirlingmw]

Good Morning

I have been scouring the tinterweb for a while now looking for a post which may offer me the right guidance, but to no avail.

I have an excel workbook which holds a database of latitudes and longitudes around the world. I am trying to figure out if there is a way to have these points populate a world map?

the Lat and long format is as follows:
[TABLE="width: 206"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]57N 52.194[/TD]
[TD]005W 39.756[/TD]
[/TR]
[TR]
[TD]57N 50.915[/TD]
[TD]005W 39.747[/TD]
[/TR]
[TR]
[TD]57N 49.644[/TD]
[TD]005W 35.265[/TD]
[/TR]
</tbody>[/TABLE]

TIA

Steve

 

[Repush]

you could use a scatter-graph with a world map as background of the graph
x/y-coords are degrees + minutes / 60