Show Washington, D.C. in an Excel Filled Map
Question details
The user needs Washington, D.C. to appear 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.
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.
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.
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.
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.
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.
If the existing chart remains blank, select the updated table and choose Insert > Maps > Filled Map. Check whether Washington, D.C. is now recognized.

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.

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.




