Chart & Visualization Issues

Fix Excel Map Chart Not Showing Loire-Atlantique

Nimra MalikNimra Malik Nov 3, 2026 870 views

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.

How to Fix Excel Map Chart Not Showing Loire-Atlantique
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.
Before you start

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.

Solution 1Recommended

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.

1
Select Your Geographic Data

Highlight the entire data range that includes your regional names and the corresponding numerical values you want to visualize.

2
Launch 3D Maps

Navigate to the 'Insert' tab on the Excel ribbon, locate the 'Tours' group, and click on '3D Map' to open the 3D Maps interface.

3
Map Your Location Fields

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'.

4
Customize and Render

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.

Use 3D Maps for Custom Regional Data
Alternative Plotting: If 3D Maps still fails to map the region by name, you can add Latitude and Longitude columns to your dataset to plot Loire-Atlantique exactly via geographic coordinates.
Free Microsoft Office alternative

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. 1. Download the Software: Visit the official WPS website to download and install WPS Office for free.
  2. 2. Open WPS Spreadsheets: Launch the application and select the 'Spreadsheets' module.
  3. 3. Import Your Data: Open your existing Excel workbook directly in WPS Office to continue editing and visualizing your charts without compatibility loss.
Highly compatible with Microsoft Excel formats (.xlsx, .xls, .csv), ensuring smooth file transitions.Provides a robust set of 2D and 3D chart tools to easily and accurately visualize your regional data.Lightweight application that uses minimal system resources while maintaining fast performance.Familiar user interface makes switching from Microsoft Office completely intuitive and effortless.
microsoft office alternative - wps office

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.