A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
This usually happens because the map data is ambiguous or Excel is not getting enough geographic detail for one region, even when the value is recognized as Geography.
Try these fixes in order:
- Put each geographic level in its own column.
Do not combine values such asBourgogne-Franche-Comté, Francein one cell. Use separate columns, for example:- Region:
Bourgogne-Franche-Comté - Country:
France
- Region:
- Add a higher-level detail column if it is not already present.
Excel map charts can map incorrectly when locations are similar or ambiguous. AddingFranceas a separate country column helps disambiguate the region. - Rebuild the map chart from the updated range.
Select the data range, then go to Insert > Charts > Maps > Filled Map. - If the region names are stored as Geography data types, keep the admin field in the source data anyway.
There is a known issue where map charts that use Geography data types can sometimes map incorrectly. Including admin fields such as Province or Country is the recommended workaround. - If the filled map still omits that region, use 3D Maps instead.
Standard Map charts only support high-level geographic details and can have mapping limitations. In desktop Excel, 3D Maps supports region-based visualizations and more geography formats. - Confirm the chart is being created while online.
Creating new maps requires an online connection because Excel connects to the Bing Map service.
If the goal is specifically a France regional choropleth, the most likely fix is to structure the data with separate columns for Region and Country, then recreate the map.
References: