Chart & Visualization Issues

Excel Map Chart Borders Disappear When Showing Only Regions with Data

Natalie TaylorNatalie Taylor Nov 12, 2026 868 views

Question details

The user needs to understand why country or regional borders disappear in an Excel map chart and how to preserve visible boundaries.

Excel Map Chart Borders Disappear When Showing Only Regions with Data
Product
Microsoft Excel Map Chart
Device & OS
not provided
Scenario
A map chart is configured to show only geographic regions that contain data, but the user needs borders for the displayed countries or regions.
Observed behavior
Some borders are not rendered because Excel filters out regions without data and may not draw boundaries for excluded areas in the map layer.
Before you start

Review the geographic fields in the chart data and confirm whether the values represent countries, states, provinces, or another recognized geographic level. Note whether the chart is using the Only show regions with data option before changing the setting.

Solution 1Recommended

Disable Only show regions with data to restore broader map boundaries

Use this option when visible country or regional borders are more important than filtering the map to data-bearing areas.

Excel Map Charts may omit borders for geographic areas excluded by the data-only filter. Showing the full map gives Excel a broader layer from which to render boundaries, although it may also display regions without values.

1
Select the map chart

Click the Excel map chart to display the Chart Design and Format tabs.

2
Open the map options

Right-click the chart and choose Format Data Series, or select Format Selection from the chart formatting controls.

3
Turn off the data-only filter

In the Series Options pane, locate Map Area and clear Only show regions with data.

4
Check the boundaries

Review the chart and confirm whether the country or regional borders are visible after the full map area is restored.

Rendering limitation: This setting does not guarantee every internal boundary will appear. Border visibility also depends on the geographic level and map data recognized by Excel.
Free Microsoft Office alternative

Create clear geographic charts with WPS Office

WPS Office is a free, lightweight Microsoft Office alternative for opening, editing, and presenting compatible Excel workbooks. Its familiar interface supports a smooth migration for spreadsheet and chart workflows, while specialized map-boundary rendering may still require a dedicated visualization tool.

  1. 1. Install WPS Office: Download and open WPS Office, then launch WPS Spreadsheets from the home screen.
  2. 2. Open the Excel workbook: Choose Open, select the .xlsx file containing the map chart, and review the source geographic data.
  3. 3. Adjust or recreate the visualization: Use the spreadsheet and chart tools to revise the data, prepare an alternative chart, or export the result for use in a dedicated mapping tool.
Open and edit Microsoft Excel .xlsx workbooks with familiar spreadsheet tools.Use a lightweight Office alternative for reviewing chart data and preparing visualizations.Maintain compatibility with common Microsoft Excel .xls and .xlsx formats.Move between spreadsheet, presentation, and document workflows in one free Office suite.
microsoft office alternative - wps office

Frequently Asked Questions

Why do Excel map chart borders disappear when Only show regions with data is enabled?

The option filters the map to geographic areas that contain data. Excel may not render borders for regions excluded from that filtered map layer, so missing boundaries are generally a chart-rendering limitation rather than a data-entry error.

How can I show all regions in an Excel map chart?

Select the map chart, open Format Data Series, find the Map Area setting, and clear Only show regions with data. The chart can then use the broader map layer and may display more boundaries.

Will disabling the data-only setting restore every regional border?

Not necessarily. Border visibility also depends on whether Excel recognizes the geographic fields and on the selected level, such as country, state, province, or subregion.

Can using a broader geographic level improve map border visibility?

Yes. Replacing detailed subregions with a recognized broader level such as Country/Region can make the map easier for Excel to interpret and may produce clearer boundaries.

What should I use if visible boundaries are essential?

Keep the Excel map for data display or disable its filtering, then use a visualization tool that supports a separate boundary or outline layer when precise regional borders are required.