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

preview_player
Показать описание
How to use excel 3D Map to make a 2D map.

In this video I plot on a map the longitude and latitude locations of places air samples were collected from in a number of different research campaigns. I use the 3D Map feature in excel to make a 2D map using a list of longitude and latitude coordinates in an excel spreadsheet and plot dots on the map. I also change the size and colour of the dots and add annotations and images to the map. I then show you how to change the map background and how to customise the map background and the simplest way to save it as an image to use later.
---------------------------------------------------------------------------------
#exceltutorial #excelmap #excel3dmaps

VIDEO INFO: These data are related to my PhD research.
---------------------------------------------------------------------------------
IF YOU LIKE THIS VIDEO YOU MAY ALSO LIKE:
Рекомендации по теме
Комментарии
Автор

Absolutely the best Youtube tutorial I've seen on anything ever. So much great info in 4.5 minutes

lisag
Автор

Quite possibly the best excel tutorial I've seen. THANK YOU!!!

annaevatt
Автор

Awesome - is there anyway to embed it in a spreadsheet so it updates when the source data updates?

chrisblain
Автор

I've done everything as told but still coordinates will not plot?

Jeevesjee
Автор

hello, you can use the time in the new actualization ?
Please show me how you do it, i have troubles with my times data in the Pmap

josepablomayorga
Автор

Great video. When I overlay a different map underneath, the dots in the original map disappear (sec 3:30/4.26). The overlaying tray is totally transparent with nothing on it. What am I missing? Thanks!

drustopia
Автор

Hi, thanks so much for sharing! Is there a way to make each bubble different sizes? (If I were to make an abundance value = size of bubble)

soliegh
Автор

how to receive phone calls in excel and make calls with excel via android? how to receive gps signal from phone in excel?

vadimvadim
Автор

I have over 1000 addresses I need to convert to Long and Lat. Is there a possiblity?

SARUJAN
Автор

Great video, very helpful. Your uptalk was a little annoying but otherwise great video thank you very much.

tt
Автор

Hi..I have an idea to convert UTM coordinates excel sheet (in any datum or zone) to google maps kml data.. How can you connect you? @karinaadcock

jovin