Chart & Visualization Issues

How to Create an Excel Filled Map for U.S. States and Countries

Phi Hung VoPhi Hung Vo Nov 13, 2026 869 views

Question details

The user needs to create an Excel map chart that colors U.S. states and entire countries according to numeric values in a worksheet.

How to Create an Excel Filled Map for U.S. States and Countries
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user has a list of state and country names with associated numeric values and wants to visualize them on a geographical map.
Observed behavior
The user expects that selecting the location and value data and inserting a map chart will color each state or country by value.
Before you start

Prepare the worksheet with location names in one column and numeric values in the next column. Include a header row above the data before you convert the names and insert the chart.

Solution 1Recommended

Create a Filled Map Chart from State and Country Data in Excel

Use this method when you have a single column of U.S. states and/or countries and a numeric column, and you want Excel to shade each region by value.

Filled map charts work best when the Geography data type recognizes each location. Rename or disambiguate locations before inserting the chart so states and countries appear correctly.

1
Arrange the location and value columns

Open the Excel workbook and put state and country names in one column. Place the numeric values for each location in the adjacent column, and include a header row such as State/Country and Sales.

2
Convert location names to Geography data types

Select only the state and country names, go to the Data tab, click Data Types, and choose Geography. Check the location cards or icons to confirm each name is recognized and assigned to the correct place.

3
Select the data and open Recommended Charts

Select the location names and numeric values, including the header row, then go to the Insert tab and click Recommended Charts.

4
Insert the filled map chart

In the Insert Chart dialog, select the map chart option and click OK. Excel creates a filled map that colors U.S. states and countries according to your values.

Create a Filled Map Chart from State and Country Data in Excel
Supported Excel versions: Filled map charts are available in Excel 2016 for Windows and later, Excel 2019 for Mac and later, and Microsoft 365.
Free Microsoft Office alternative

Use WPS Office Free to Open, Review, and Edit Excel Workbooks

WPS Office is a free, lightweight alternative to Microsoft Excel that opens and saves Excel .xlsx files, supports familiar spreadsheet editing, and provides a ribbon-based interface for a smooth transition when you need an Office suite without the cost.

Free to download and use for spreadsheet, document, and presentation work.Opens and saves Microsoft Excel .xlsx files for easy sharing and migration.Lightweight suite with a familiar ribbon interface that helps Excel users switch quickly.Lets you open Excel workbooks and edit the data behind chart-based reports in a compatible spreadsheet environment.
microsoft office alternative - wps office

Frequently Asked Questions

Why do some of my U.S. states or countries appear blank on the map?

Blank regions usually mean Excel did not recognize the location name or the name was not converted to the Geography data type. Select the location names, choose Data > Data Types > Geography, and click the icon next to ambiguous names to match them to the correct state or country before inserting the map chart.

Can I include both U.S. states and entire countries in one filled map?

Yes. Put both state and country names in the same location column. Excel can chart them together as long as each name is recognized by the Geography data type and the selected data includes the numeric values.

Which Excel versions support filled map charts?

Filled maps are supported in Excel 2016 for Windows and later, Excel 2019 for Mac and later, and Microsoft 365. If you do not see the map chart option, make sure you are using a supported Excel version.

Do I need to convert place names to Geography data types before creating the map?

Yes. Excel uses the Geography data type to recognize locations and match them to map regions. Convert the location names first, verify them, and then select the data and insert a Recommended Chart.