How to make a map in excel with latitude and longitude co-ordinates

okay first of all I have here a list of campaigns in which air samples were collected and I have here the latitude and longitude coordinates or the locations where each of the air samples was collected and then I also numbered each of the samples so I'm going to go to insert and then I'm going to select 3d map and the first time that you select first you'll have to enable the 3d map adèle and here is my map and it have made the column toilet water gratitude into the gratitude coordinates and then they have labeled the column that I had and longitude as the longitude coordinates and now each of the locations where my air samples were collected from is represented by a little blue dot now here this is called detour editor and here it is called the layout pane and then this is called the fields list and I'm going to make this map into a flat lip and then at the moment each of my dots in a square and I want it to be a circle so I'm going to select the bubble channel and then I'm going to zoom out so I can see the whole of the map and then I'm going to go to layer options and I'm going to increase the size of the top so that I can see them properly and I could also change the color with these dots and if I go up to your category and select add field and select champagne I can make each of my campaigns be a different color and so this here is the legend and I'm just going to delete that and I can also add annotations to this map if I right click and select add annotation and then I'm going to call this Raymond and you can obviously also be appearance of this you won now I'm going to place it on the left hand side and I'm going to select okay and you can also add images benefits if you right click and add annotation and then select image and then just choose whatever image you would like and then select ok and you can also change the background of this map so if I select map labels I now have labels for all of the countries and also all of the seas and oceans now there are also a number of different things in can choose from and is give you a range of different options to how you want the map to look and then also if I go to scene options and map type and change and then select narrow custom at that and then I can select any image I want to be the background so this is just an image that I got offline and now I'm going to change the size of the dots together to make them smaller I'm just going to try and arrange this to get a dots back where they were before and I think that's about right and then I'm going to select apply and I'm going to select done now I'm going to close all of these things and I'm going to can't tilt the map back up again with servitudes client I'm going to zoom in to this and now there's obviously a lot of different things that you can do with 3d maps this is just an example of some of the features now if I wanted to save this image I would go to screen its natural or capture screen and select this and then I open up a word document and control-v to paste and then I'm just going to crop this image to get rid of the blue background and then obviously I can resize this image as well okay and then I can save it and you get how in for our one and that is in

Channel: Karina Adcock

Views: 230,933

Keywords: Excel 2016, excel tutorial, excel 3D map, excel 2D map, simple map, plot latitude and longitude, latitude and longitude excel, plot latitude and longitude excel, latitude and longitude map in excel, lat and long excel map, latitude longitude excel map, map in excel, excel map chart latitude longitude, excel 3d maps, excel 3d maps tutorial, excel 3d map latitude longitude, excel 3d map longitude latitude

Id: f2bZ7EkIcpU

Length: 4min 27sec (267 seconds)

Published: Wed Aug 02 2017