Fix Excel Map Recognition for the Swiss Canton of Neuchâtel
Question details
The user needs Excel Map charts to identify Neuchâtel as a canton in Switzerland rather than incorrectly recognizing it only as a city or not recognizing it at all.

- Product
- Microsoft Excel Map chart and Geography data type
- Device & OS
- not provided
- Scenario
- The user is preparing geographic data for a Switzerland map chart and needs to plot the canton of Neuchâtel accurately.
- Observed behavior
- Excel's geographic recognition service may treat Neuchâtel as a city, return an ambiguous result, or fail to classify it as a Swiss canton.
Make sure the canton name is entered as “Neuchâtel,” including the accented character. If your workbook contains location data from an import, check that no extra spaces, hidden characters, or abbreviations are attached to the value.
Add Switzerland context and verify Neuchâtel with the Geography data type
Use this method when Excel can identify Neuchâtel but may confuse the city with the canton. Adding a country field gives the map service more geographic context.
Excel Map charts rely on Microsoft's geographic data service. A separate Country column and the Geography data type can help you inspect which location Excel has matched before creating the chart.
In the worksheet, place the canton name in one column and add a nearby column named Country. Enter Switzerland in the Country column for the Neuchâtel row and for all other Swiss canton rows.
Select the location cell and enter Neuchâtel exactly, including the accent. Avoid abbreviations or combined values such as “NE - Neuchâtel” unless Excel has already confirmed that format.
Select the Neuchâtel cell, then choose Data > Geography. Click the small Insert Data button that appears beside the selected cell or open the data card to review the location Excel recognized.
Select the geographic labels and their numeric values, then choose Insert > Maps > Filled Map. If a map already exists, right-click it and select Refresh Data when that option is available.

Update Excel and use a supported geographic identifier
Use this option when Neuchâtel still is not classified correctly after you add country context and verify the spelling.
Analyze Swiss canton data in WPS Spreadsheet with familiar XLSX tools
If Microsoft Excel's map service cannot classify Neuchâtel at the canton level, WPS Office provides a free, lightweight spreadsheet alternative for organizing, analyzing, and visualizing your location data. Its familiar spreadsheet interface supports a smooth move from Excel while preserving common workbook formats.
- 1. Open the Excel workbook: Launch WPS Spreadsheet, select Menu > Open, and choose your .xlsx or .xls workbook containing the Swiss canton data.
- 2. Review the location table: Use Data > Filter or Data > Sort to check canton names, country values, and the numeric data that you want to compare.
- 3. Create a comparison chart: Select the canton and value columns, then choose Insert > Chart and select a suitable column, bar, or line chart.

Frequently Asked Questions
Why does Excel recognize Neuchâtel as a city instead of a canton?
Neuchâtel can refer to both a city and a canton. Excel's mapping service may select the city when the worksheet does not provide enough context. Add a Country column with Switzerland and check the result through Data > Geography.
Should I spell Neuchâtel with the accent in Excel?
Yes. Enter the official spelling, “Neuchâtel,” including the accent. Also check imported data for extra spaces or altered characters that can affect location recognition.
How can I see which place Excel matched to my location value?
Select the cell, choose Data > Geography, and then open the Geography data card or click the Insert Data button beside the cell. The card shows the location Excel recognized.
Can I force an Excel Filled Map chart to use cantons instead of cities?
You can improve recognition by supplying country context and using verified Geography data, but you cannot force a canton-level result when Microsoft's map dataset does not support or distinguish that administrative region.
What should I use if Excel Map cannot display Neuchâtel as a canton?
Use Neuchâtel as a text category in a standard chart through Insert > Column or Bar Chart, or use another supported geographic identifier if your reporting workflow requires a map.




