Chart & Visualization Issues

Show Washington, D.C. in an Excel Filled Map

Kushani NimanthikaKushani Nimanthika Nov 13, 2026 869 views

Question details

The user needs Washington, D.C. to appear in an Excel Filled Map.

How to Show Washington, D.C. in an Excel Filled Map
Product
Microsoft Excel Filled Maps
Device & OS
not provided
Scenario
A map uses geographic data with Washington in a County column and D.C. in a State column.
Observed behavior
Washington, D.C. appears as a blank area on the map.
Before you start

Check that your Excel version supports Filled Map charts and that you have an internet connection for geographic data recognition. Locate the source table and the value you want to plot for Washington, D.C.

Solution 1Recommended

Clarify the geographic data and update the Filled Map

Use full geographic names and a Country column to help Excel distinguish Washington, D.C. from other places named Washington.

1
Edit the location fields

In the source table, use clear headers such as County, State, and Country. For the affected row, enter Washington under County, District of Columbia under State, and United States under Country.

2
Check the plotted value

In the same row, enter or verify the numeric value you want the map to display. A blank value may leave the area unfilled even if the location is recognized.

3
Update the chart range

Select the map, open Chart Design > Select Data, and make sure the chart data range includes the Country column and the Washington row. Confirm the selection to update the chart.

4
Recreate the map if needed

If the existing chart remains blank, select the updated table and choose Insert > Maps > Filled Map. Check whether Washington, D.C. is now recognized.

Clarify the geographic data and update the Filled Map
Map boundary limitations: Recognition and available boundaries depend on Excel's mapping service. Washington, D.C. and independent Virginia cities may be treated as separate areas, so clearer labels do not guarantee that every area will be filled.
Free Microsoft Office alternative

Work with Excel map source data in WPS Office

WPS Office is a free, lightweight Office alternative with a familiar spreadsheet interface. It supports Excel formats, making it easy to move and edit your source data, although it does not fix Excel's Filled Map recognition.

Edit geographic source tables in WPS SpreadsheetsCompatible with Microsoft Excel XLS and XLSX formatsFamiliar spreadsheet tools for an easier transitionFree and lightweight Office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why is Washington, D.C. blank on my Excel Filled Map?

Excel may not recognize an abbreviated or ambiguous location, or the row may have no plotted value. Use Washington, District of Columbia, and United States in clearly labeled columns, then check the chart's data range.

How do I include a Country column in an existing map?

Add a Country column to the source table and enter United States for the relevant rows. Select the chart, open Chart Design > Select Data, and expand the chart data range to include the new column.

Why are some Virginia cities also white on the map?

Some Virginia cities are independent of counties and may be treated as separate geographic areas. Check their names and plotted values, but note that the mapping service determines which boundaries are available.

Can WPS Office fix Excel's Filled Map recognition?

No. WPS Spreadsheets can edit the XLS or XLSX source table, but Excel's Filled Map recognition and boundaries depend on its mapping service.