How to Fix Excel Map Chart Not Coloring Recognized Regions
Question details
The user needs to make an Excel Map chart properly color all recognized regions when displaying a full country map or using the automatic map mode.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Creating a Map chart in Excel using regional geographic data.
- Observed behavior
- The map recognizes the region and displays its data label, but fails to apply color to the region polygon unless 'Only regions with data' is enabled.
Ensure your geographic data is spelled correctly and formatted consistently. An active internet connection is also required for Excel's Bing Maps service to plot and render locations accurately.
Enable 'Only regions with data' Option
This is the most reliable workaround for the bug where Excel fails to color specific regions with long or complex names in automatic or full-map mode.
By restricting the map area to only show regions that contain data, you force Excel's mapping engine to redraw the boundaries, which bypasses the rendering bug and applies the correct colors.
Right-click on your map chart and select 'Format Data Series' from the context menu to open the formatting pane.
In the Format Data Series pane on the right side of your screen, click on the 'Series Options' icon, which looks like three columns.
Locate the 'Map area' dropdown menu and change the selection from 'Automatic' to 'Only regions with data'.
Check the map chart to ensure the previously uncolored regions are now properly filled with the correct data-driven colors.

Refine Geographic Data with Context
Adding more specific geographical identifiers can sometimes help the Bing Maps engine accurately plot and color the regions in automatic mode without requiring workarounds.
Try WPS Office for Seamless Data Visualization
If you frequently encounter bugs and inconsistencies in Microsoft Excel's charts, consider switching to WPS Office. It provides a lightweight, highly compatible spreadsheet tool with robust charting features, completely free of charge.
- 1. Download and Install: Visit the official WPS website to download and install WPS Office for free on your device.
- 2. Open Your Excel File: Launch WPS Spreadsheet and open your existing .xlsx file directly. Your data and layout will remain intact.
- 3. Create Your Charts: Highlight your data and insert standard or advanced charts from the Insert tab to visualize your information without mapping bugs.

Frequently Asked Questions
Why does Excel Map recognize the region label but not color it?
This is a known bug in Excel's Bing Maps integration. The map service can identify the location well enough to place a data label, but occasionally fails to render the geometric boundary polygon required for coloring, especially with longer regional names or when viewing the full country.
Does changing the map projection fix the coloring issue?
Changing the map projection (e.g., Mercator, Miller, Albers) typically only alters how the 3D globe is flattened into a 2D map. It generally does not resolve the missing color issue. The most effective workaround remains setting the map area to 'Only regions with data'.
How can I report this map chart bug to Microsoft?
You can report this issue directly within Excel by navigating to 'File' > 'Feedback' > 'Send a Frown'. Describe the issue where recognized regions are not colored in automatic mode, and attach a screenshot of the chart to help their engineers investigate.
Do Map charts in Excel require an internet connection to work?
Yes, Excel Map charts rely entirely on the Bing Maps service to process geographic data. You must be connected to the internet for the chart to identify regions, plot locations, display labels, and apply colors.




