If you've got data to map, you might want to using the geo chart maps in Google Sheets. As long as you have some type of value that can be mapped like city, state or country, you can assign colors or markers to your data on a geographic map. All you need are two columns; one for the locale and the other to represent some quantitative value. The catch is that there are just to geo map options to use in Google sheets. Also you can't map latitude and longitude. However there is a workaround to that which involves some script (don't worry it's a copy/paste) and later on I'll even so you how to incorporate google sheet data with the google maps application.
0:00 Intro
2:13 Create a Geo Map
5:09 Create a Geo Map with Markers
10:36 Create a Geo Map with Latitude / Longitude
14:36 Using map data in Google Sheets with Google Maps
Get the script for the Latitude / Longitude solution at stackoverflow.com/questions/2...
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltraining101.com/p/tr...
📚 Excel Books & Tech Gear ➜ www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ www.tubebuddy.com/et101
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to www.buymeacoffee.com/dough
#googlesheets
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~