How to Fix Excel Map Charts That Ignore Slicer Filters
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.

- 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.
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.
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.
Click directly on the colored regions inside your map chart to select the data series, rather than clicking the outer chart border.
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.
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'.
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.

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. Download and Install WPS Office: Get the free WPS Office suite from the official website and install it quickly on your device.
- 2. Open Your Excel File: Launch WPS Spreadsheet and open the .xlsx file containing your charts, pivot tables, and slicers.
- 3. Analyze Data Without Hassle: Use the familiar interface to filter your data and interact with visualizations smoothly.

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.




