Missing region in a choropleth map in Excel

Young Tara 20 Reputation points
2026-11-18T13:45:40.7966667+00:00

Hello,

I would like to display a map of France showing its regions.

I have converted the data into "geographical data." Each region appears to be "recognized" by Bing; however, when I display the map, the Bourgogne-Franche-Comté region does not appear.

Does anyone have a solution?

Thank you!

Microsoft 365 and Office | Excel | For business | Windows
0 comments No comments

2 answers

Sort by: Most helpful
  1. Aetherin 4,500 Reputation points Independent Advisor
    2026-11-18T14:19:13.8766667+00:00

    Hi @Young Tara,

    This issue is caused by an inconsistency in how Excel's Map Chart and Bing Maps recognize certain French region names. Although the geographic data type may correctly identify the region, the map visualization can sometimes fail to render it.

    A workaround shared by an MVP for a similar case is to rename the region used in the chart to "Bourgogne Franche-Comté" (remove the first hyphen between Bourgogne and Franche, while keeping the hyphen in Franche-Comté). With this spelling, the region is typically displayed correctly on the choropleth map.

    You can review the original discussion here: Région manquante carte choroplèthe dans Excel - Microsoft Q&A

    User's image

    Note: The discussion is currently available only in French. For easier reference, you may want to use a translation tool.

    If you have any updates, feel free to share them with me. Thank you!

    Was this answer helpful?


  2. AI answer

    2026-11-18T13:45:58.56+00:00

    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:

    1. Put each geographic level in its own column.
      Do not combine values such as Bourgogne-Franche-Comté, France in one cell. Use separate columns, for example:
      • Region: Bourgogne-Franche-Comté
      • Country: France
    2. Add a higher-level detail column if it is not already present.
      Excel map charts can map incorrectly when locations are similar or ambiguous. Adding France as a separate country column helps disambiguate the region.
    3. Rebuild the map chart from the updated range.
      Select the data range, then go to Insert > Charts > Maps > Filled Map.
    4. 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.
    5. 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.
    6. 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:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.