Fix Excel Map Chart Showing Entire Country Instead of City
Question details
The user is trying to plot specific cities (such as Bangkok) on an Excel Map Chart, but the chart inaccurately displays the entire country instead of zooming in on the targeted location.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Creating a map chart to visualize data at the city level.
- Observed behavior
- The map chart plots high-level geographic regions (the whole country) because the specific city names are considered ambiguous or are not recognized by the map service.
Ensure you have an active internet connection, as Excel's Map Charts and Geography data types rely heavily on Bing Maps online services to accurately resolve location names.
Clarify Location Data with Additional Geographic Fields
Adding higher-level geographic data like country, state, or province helps Excel accurately pinpoint the specific city without confusing it with similar names globally.
Map charts rely on an online database that might find duplicate city names across different countries. Providing context through additional columns ensures the map service understands exactly which city you intend to plot.
Insert a new column next to your existing city data and label it 'Country', 'State', or 'Province'.
Enter the corresponding higher-level geographic location for each city. For example, if your city is 'Bangkok', enter 'Thailand' in the adjacent Country column.
Highlight both the new context columns and your original city data, along with the numerical values you want to plot.
Go to the 'Insert' tab on the Excel ribbon, click on 'Maps' in the Charts group, and select 'Filled Map' to generate the updated visualization.

Verify Locations Using the Geography Data Type
Use Excel's built-in Geography data type to validate whether Bing Maps officially recognizes your specific cities before generating the chart.
Try WPS Office for a Seamless and Lightweight Charting Experience
If you frequently encounter difficulties with complex integrations or heavy data types in Microsoft Excel, consider switching to WPS Office. It provides a lightweight, highly compatible alternative with robust spreadsheet charting tools that are intuitive and fast.
- 1. Download and Install: Visit the official WPS Office website to download the free suite and install it on your device.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheet and easily open your existing .xlsx files with full formatting retained.
- 3. Create Your Charts: Highlight your data, navigate to the Insert tab, and choose from a wide variety of charting options to visualize your data.

Frequently Asked Questions
Why does my Excel map chart show a blank map?
A blank map chart typically occurs when the geographic data is completely unrecognized or when there is no active internet connection. Excel relies on Bing Maps to render the visuals, so ensure you are online and that your locations are spelled correctly.
Can I plot zip codes or postal codes on an Excel map chart?
Yes, Excel map charts support postal codes. However, because postal codes can overlap across different countries, it is highly recommended to include a adjacent 'Country' column to prevent the map from plotting the codes in the wrong global region.
How do I change the map projection in an Excel Map Chart?
Right-click on the plotted area of your map chart and select 'Format Data Series'. In the Format pane under Series Options, look for the 'Map Projection' dropdown menu, where you can choose between Automatic, Mercator, Miller, or Albers.
Does WPS Spreadsheet support viewing Excel map charts?
WPS Spreadsheet is highly compatible with .xlsx files and supports most standard chart types perfectly. However, features that rely strictly on Microsoft's proprietary online services (like Bing Maps integration) may display as static images or require standard charts for dynamic visualization.




