Fix Excel Map Chart Not Showing Loire-Atlantique
Question details
The user is unable to display the French department Loire-Atlantique in an Excel map chart despite using the correct geographic data type.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Creating a geographical map chart in Excel to visualize regional data across different French departments.
- Observed behavior
- The Excel map chart renders most regions correctly but completely omits Loire-Atlantique from the map.
Verify that your location data is spelled correctly and that the cells are formally set to the 'Geography' data type under the Data tab before proceeding with troubleshooting.
Use 3D Maps for Custom Regional Data
Since standard Map Charts rely on a specific set of Bing Maps geographic data that may omit certain regions, using 3D Maps gives you more flexibility to plot unrecognized locations.
The native Map Chart tool in Excel uses a simplified Bing Maps database which sometimes fails to recognize specific local regions like Loire-Atlantique. 3D Maps offers a more robust mapping engine and allows for customized location mapping.
Highlight the entire data range that includes your regional names and the corresponding numerical values you want to visualize.
Navigate to the 'Insert' tab on the Excel ribbon, locate the 'Tours' group, and click on '3D Map' to open the 3D Maps interface.
In the Layer Pane on the right, ensure your region column is added to the 'Location' box. Use the dropdown next to the field name to specify it as 'Region' or 'County'.
Add your data values to the 'Height' or 'Category' fields to render the visualization. 3D Maps will typically recognize complex regions better than the standard 2D map.

Utilize the Bing Maps Add-in
The Bing Maps Add-in provides an alternative rendering method directly within your spreadsheet and sometimes successfully charts data that the native Map Chart tool misses.
Submit Feedback to Microsoft
Reporting the missing geographic data directly to Microsoft helps them update the underlying Bing Maps database for future Excel updates.
Try WPS Office for Seamless Data Visualization
Struggling with missing data points and mapping glitches in Microsoft Excel? Switch to WPS Office. It provides robust spreadsheet tools, complete file compatibility, and an extensive library of reliable charts—all without expensive subscription fees.
- 1. Download the Software: Visit the official WPS website to download and install WPS Office for free.
- 2. Open WPS Spreadsheets: Launch the application and select the 'Spreadsheets' module.
- 3. Import Your Data: Open your existing Excel workbook directly in WPS Office to continue editing and visualizing your charts without compatibility loss.

Frequently Asked Questions
Why does my Excel Map Chart show errors for certain locations?
Excel relies on the Bing Maps geocoding service to match text in your spreadsheet to geographic polygons. If a region's name is recently changed, ambiguous, or simply missing from Bing's internal database (like Loire-Atlantique in some instances), Excel cannot draw the map for that specific area.
Can I manually add a location polygon to an Excel Map Chart?
No, you cannot manually alter or add location boundaries in a standard Excel Map Chart. You must rely on the regions predefined by Bing Maps. If a region is missing, your best workaround is to use 3D Maps where you can plot custom regions via coordinates.
Are Map Charts available in older versions of Excel?
The native Map Chart feature is only available in Microsoft 365 subscriptions, Excel 2019, and Excel 2021. If you are using Excel 2016 or earlier, you will need to use the Bing Maps Add-in or 3D Maps (formerly Power Map) to visualize geographic data.




