Plot Cities On A Map Excel

If all goes well, a little map icon will appear to the left of the county name. When you’re ready to create the map chart, select your data by dragging through the cells, open the “insert” tab, and move to the “charts” section of the ribbon. We are tracking donations to an organization by church and want to see what part of the county donations are coming from.

If all goes well, a little map icon will appear to the left of the county name. Using filled map chart to plot cities map chart is an additional type of chart in excel which helps you to plot information based on geographic locations. Let’s take a simple example of a map chart to just get an overview of how this works in excel.

Plotting cities from different states in this example, we will plot 280 cities from different states.

This mapping program includes driving directions, street view imagery, and a satellite view. Select inset, and in chart options, you can see the maps option there. Easymapmaker takes the work out of manually plotting multiple locations on a map. Ideally, larger circles would represent larger donations, but that is.