Excel Map Chart not coloring or locating some Japanese cities

Please note that this is the es-es forum. We kindly recommend posting your question in Spanish so that more community members can assist you. Alternatively, you may consider posting in the English forum if you prefer to use your native language. We sincerely appreciate your understanding.

Hi @Jurado Rodriguez Neri Magdiel

Thank you for providing the detailed examples and screenshots. Please note that I am just a regular user in this community, not a Microsoft employee or support representative, so I can only share suggestions based on Microsoft documentation and my own research.

Based on the screenshots, Excel appears to have included both the "blue" and "orange" groups in the legend but failed to shade all the corresponding municipalities on the map. This suggests the issue likely stems from how the geographic names are matched against existing boundary polygons, rather than the categorical data type or numerical values ​​used for shading. After testing this on my end, I was able to reproduce similar behavior, where some Japanese municipalities appeared in the legend but remained unshaded on the map.

Microsoft has acknowledged an issue where Map Charts using the Geography data type can sometimes map locations incorrectly. They recommend separating geographic levels into distinct columns and including higher-level administrative fields such as prefecture and country to reduce ambiguity. Documentation also indicates that Map Charts primarily support relatively high-level geographic areas. You may want to consult the documentation on creating Map Charts in Excel.

You have already organized your data into separate columns for Country, Prefecture, District, and City. Consequently, if Handa, Kariya, and Ōguchi remain unshaded, simply switching between English and Japanese names, text-based categories, or numerical values ​​is unlikely to resolve the issue of missing or incorrectly matched polygons.

I have not found any official Microsoft documentation confirming a specific behavior affecting these particular Japanese municipalities. Therefore, you can perform a final check by converting each cell containing a city name via Data > Data Types > Geography, and then reviewing any ambiguous results in the selection pane. Excel allows users to select the correct geographic result when the online data source cannot precisely identify the text content. However, if it still doesn’t work, I suggest submitting feedback so that the product team can hear your concerns and consider addressing the issue in a future update.

Please keep me updated.