Chart & Visualization Issues

Fix Excel Maps Not Showing All Norwegian Counties

Rana GarciaRana Garcia Oct 21, 2026 869 views

Question details

The user is experiencing issues with Excel 2D Maps where Norwegian counties are displayed with outdated names, incorrect boundaries, or inappropriate sea area inclusions following recent administrative changes in Norway.

How to Fix Excel Maps Not Showing All Norwegian Counties
Product
Microsoft Excel
Device & OS
not provided
Scenario
Creating geographic data visualizations using Excel 2D Maps for regions in Norway.
Observed behavior
Excel Maps fails to recognize new Norwegian county boundaries, displays incorrect borders that include sea areas, and only plots data correctly when former pre-change county names are used in the dataset.
Before you start

Ensure you have a stable internet connection, as Excel 2D Maps requires online access to Bing Maps to render geographic data. It is also recommended to update your Office application to the latest version to ensure you have the most recent data patches.

Solution 1Recommended

Use Former Norwegian County Names in Your Data

Since Excel's mapping service has not fully updated to reflect Norway's new county structure, using the older, recognized county names ensures your map renders correctly.

This is currently the most reliable workaround for the mapping limitation. The Bing Maps service integrated into Excel still relies on the legacy geographic boundaries for Norway.

1
Review your dataset

Open your Excel workbook and locate the column containing your geographic data and Norwegian county names.

2
Revert to former names

Replace the newly established county names in your cells with their former names (the pre-administrative change names) that the mapping service still recognizes.

3
Refresh the map

Select your updated data range, go to the 'Insert' tab on the ribbon, and click 'Maps' to generate the 2D Map again with the recognized names.

Use Former Norwegian County Names in Your Data
Data Accuracy: While this workaround allows the map to render, keep in mind that the visualized boundaries will represent the historical county layout rather than the current political map of Norway.
Free Microsoft Office alternative

Try WPS Office for Your Data Visualization Needs

If you are frustrated by unresolved bugs and server-side data limitations in Microsoft Excel, WPS Office offers a free, highly compatible, and lightweight alternative for your spreadsheet and charting tasks.

  1. 1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite on your device.
  2. 2. Open your data files: Launch WPS Spreadsheet and open your existing .xlsx files containing your regional data without losing any formatting.
  3. 3. Create alternative visualizations: Use WPS Spreadsheet's built-in, offline-friendly chart tools to create clear, accurate bar or pie charts for your regional data while waiting for Microsoft's map updates.
Fully compatible with Microsoft Excel formats including .xlsx, .xls, and .csv.Offers robust standard charting and visualization tools that avoid complex server dependencies.Lightweight application with a familiar user interface for a seamless migration.Completely free to download and use for your daily spreadsheet and reporting needs.
QA img-9

Frequently Asked Questions

Why does Excel Maps show incorrect boundaries for Norway?

Excel 2D Maps relies on the Bing Maps service for its geographic data. This service has not yet been updated on Microsoft's end to reflect Norway's recent administrative county changes, resulting in outdated borders and misaligned sea areas.

Can I manually fix or redraw the map boundaries in Excel?

No, the map boundaries are pulled directly from the cloud-based Bing Maps service. Users cannot manually edit, adjust, or redraw geographic boundaries within the Excel 2D Maps feature.

How long does it take for Microsoft to update map data in Excel?

Updates to Bing Maps and Excel's mapping service occur periodically on Microsoft's end without a publicly announced schedule. Submitting feedback through the Excel app is the best way to bring attention to specific regional inaccuracies.

Are there alternative ways to visualize this regional data?

If geographic accuracy is critical and 2D Maps fails, consider using standard bar charts, column charts, or pie charts to represent your regional data metrics, or use dedicated GIS (Geographic Information System) software for precise mapping.