Excel Us Map Chart

Using figure a as a guide, enter and select the counties (b3:b7). The editable world map allows users to create visual representations using map pins. This is not what we want.

The solution is to remove the data from pivot table first and then create the map chart. In the data types gallery, click geography. Data can be plotted by country, state, county, zip code.

In other countries, use regions instead of region.

Now that excel has identified our data, we are ready to create a chart. In this example, we’ll create a us state map chart. This is not what we want. Select the map dropdown, filled map option.