Chart & Visualization Issues

How to Fix Excel Map Charts That Ignore Slicer Filters

Chanuka GeekiyanageChanuka Geekiyanage Nov 10, 2026 869 views

Question details

The user needs to restrict an Excel map chart to display only regions selected via a slicer, as it currently ignores the slicer filters.

How to Fix Excel Map Charts That Ignore Slicer Filters
Product
Excel
Device & OS
not provided
Scenario
Filtering geographical data in an Excel map chart using slicers.
Observed behavior
The map chart continues to display regions that fall outside the selected slicer values instead of updating dynamically to show only filtered data.
Before you start

Ensure that your map chart is properly linked to the source data table and that your slicer is connected to the same pivot table or dataset driving the chart.

Solution 1Recommended

Configure Map Area to Show Only Regions with Data

Adjusting the Format Data Series settings ensures the map dynamically zooms to and displays only the regions currently selected by your slicer.

By default, Excel map charts may be set to display a broader geographic area, such as 'Automatic' or 'World'. When you apply a slicer filter, the data points change, but the map boundary remains static unless specifically configured to shrink down to only the regions containing data.

1
Select the Map Chart Data Series

Click directly on the colored regions inside your map chart to select the data series, rather than clicking the outer chart border.

2
Open Format Data Series

Right-click the selected geographic regions and choose 'Format Data Series' from the context menu to open the formatting pane on the right side of your screen.

3
Adjust Map Area Settings

In the Format Data Series pane, navigate to 'Series Options'. Look for the 'Map area' dropdown menu and change the selection from 'Automatic' to 'Only regions with data'.

4
Verify Slicer Connections

Test the map by selecting different values in your slicer. The map should now automatically zoom in and out to frame only the filtered regions.

Configure Map Area to Show Only Regions with Data
Dynamic Map Updating: Your map will now dynamically adjust its boundaries and visible regions whenever you apply a filter using the slicer.
Free Microsoft Office alternative

Looking for a smoother spreadsheet experience? Try WPS Office

If Microsoft Excel charts and slicers are causing frustration with slow performance or settings quirks, WPS Office offers a free, lightweight, and highly compatible alternative. Enjoy seamless data analysis, a familiar interface, and perfect compatibility with Excel formats without the heavy subscription costs or steep learning curves.

  1. 1. Download and Install WPS Office: Get the free WPS Office suite from the official website and install it quickly on your device.
  2. 2. Open Your Excel File: Launch WPS Spreadsheet and open the .xlsx file containing your charts, pivot tables, and slicers.
  3. 3. Analyze Data Without Hassle: Use the familiar interface to filter your data and interact with visualizations smoothly.
100% compatible with Microsoft Excel (.xlsx, .xls) files and chart formatsLightweight application that runs smoothly on any Windows, Mac, or Linux deviceFamiliar user interface makes switching from Microsoft Office completely effortlessRobust built-in pivot tables and data visualization tools for accurate reporting
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel map chart show the whole world instead of filtered data?

By default, Excel map charts may be set to 'Automatic' or 'World' in the Map Area settings. If your slicer removes data for certain regions, the map won't automatically zoom in unless you change the 'Map area' setting to 'Only regions with data'.

How do I ensure my slicer is connected to my map chart?

To connect a slicer to a map chart, right-click the slicer and choose 'Report Connections'. In the dialog box, ensure the checkbox is ticked for the specific PivotTable or data source that feeds into your map chart.

Why is the 'Only regions with data' option missing in the format pane?

This option might be missing if you haven't clicked directly on the plotted data series within the map. Ensure you select the actual colored map regions, not just the blank chart background, before opening the Format Data Series pane.

Does the map chart require an internet connection to update when I use a slicer?

Yes, Excel map charts use Bing Maps to plot geographic data. An active internet connection is required to resolve geographic locations and redraw the map boundaries when slicer filters are applied.