Chart & Visualization Issues

Fix Excel Map Chart Showing Entire Country Instead of City

Adam DavisAdam Davis Oct 28, 2026 873 views

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.

How to Fix an Excel Map Chart Showing an Entire Country Instead of a City
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.
Before you start

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.

Solution 1Recommended

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.

1
Add geographic context columns

Insert a new column next to your existing city data and label it 'Country', 'State', or 'Province'.

2
Fill in the specific regions

Enter the corresponding higher-level geographic location for each city. For example, if your city is 'Bangkok', enter 'Thailand' in the adjacent Country column.

3
Select the expanded data range

Highlight both the new context columns and your original city data, along with the numerical values you want to plot.

4
Recreate the map chart

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.

Clarify Location Data with Additional Geographic Fields
Tip for Best Results: Always format your data as an Excel Table (Ctrl + T) before creating a map chart. This ensures that any new locations you add later will automatically update the chart.
Free Microsoft Office alternative

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. 1. Download and Install: Visit the official WPS Office website to download the free suite and install it on your device.
  2. 2. Open Your Spreadsheet: Launch WPS Spreadsheet and easily open your existing .xlsx files with full formatting retained.
  3. 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.
Highly compatible with all Microsoft Excel (.xlsx and .xls) file formats.Free, lightweight, and fast-loading spreadsheet editor.Familiar user interface that requires zero learning curve.Includes a rich set of built-in chart types for effective and easy data visualization.
microsoft office alternative - wps office

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.