Excel Map chart not recognizing France region

Our take

If you're facing challenges with Excel Map charts not recognizing the Bourgogne Franche-Comté region in France, you're not alone. Despite correctly formatting the geography data and acknowledging the region in Bing Maps, it remains greyed out on your map. This issue can be frustrating, especially when you've already adjusted your data for other regions. As you seek a reproducible solution for multiple maps, consider community insights on troubleshooting this geographic recognition problem, as it can significantly enhance your market analysis.

Hi,

I am doing a market analysis of European countries. So far, the Excel Map chart has worked well. However, for France, one specific region is not being recognized and is left greyed out on the map (Bourgogne Franche-Comté)

I don't understand because the geography data format recognizes it as a region, even when I specifically write "Bourgogne Franche-Comté, France", and Bing Map also recognizes the region.

Just to be clear, I've got one row with the regions and one row with the data, like population numbers or various percentages representing different things.

I had to go down one level of region preciness already because there were many regions it didn't recognize.

Does anyone know why that is happening and how to fix it? I need a reproductible method because I have multiple maps to do. Apparently you can do it with Power BI, but I'd rather not because 1. I'm not familiar, that's fine but still time consuming to learn and 2. The aesthetic is very different from the excel charts, so doesn't look really good in a deck if the style changes mid way.

I would appreciate any suggestions!! Thank you in advance

submitted by /u/Ijusti
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article →

Tagged with

#Excel alternatives for data analysis#generative AI for data analysis#Excel compatibility#Excel alternatives#conversational data analysis#real-time data collaboration#financial modeling with spreadsheets#data analysis tools#big data management in spreadsheets#row zero#intelligent data visualization#data visualization tools#enterprise data management#big data performance#data cleaning solutions#rows.com#natural language processing for spreadsheets#enterprise-level spreadsheet solutions#real-time collaboration#interactive charts