I want to make a map dynamic based on an excel file.
Where do i start. this is a big q!!
Lets say i have cities that are in a row and for every city there is either a name , joe, bob , or mike, and for every joe, bob , or mike, there is a color, red, green, or blue.
I want the city on the map to reflect the color of joe if joe is listed with that city on that excel sheet.