Chart & Visualization Issues

How to Fix and Restore a Shrunken Excel Map Chart

Elise Williams Oct 1, 2026 869 views

Question details

The user needs to restore the size of a map chart in Excel that has shrunk after adding new geographic data.

How to Fix a Shrunken Map Chart in Excel

Product: Microsoft Excel
Device & OS: not provided
Scenario: Adding new geographic data to an existing Excel map chart causes the chart layout to distort, leaving a large plot area and a tiny map.
Observed behavior: The map chart shrinks significantly within the plot area when new data is added, making it difficult to read.

Before you start

Before adjusting chart settings, verify that your geographic dataset does not contain hidden blank rows or extreme geographical outliers, as these can force the map to zoom out excessively.

Solution 1Recommended

Adjust Map Area and Projection Settings

Modify the map area settings to focus only on the regions containing data, which prevents the map from shrinking to accommodate distant or empty areas.

By default, Excel map charts may attempt to display a global or continental view if the data range is ambiguous. Restricting the map area helps maintain a proper scale.

Open Format Data Series

Right-click directly on the map inside your chart and select 'Format Data Series' from the context menu to open the formatting pane on the right.

Change Map Area Settings

In the Format Data Series pane, expand the 'Series Options' menu. Locate the 'Map Area' dropdown and change it from 'Automatic' to 'Only regions with data'.

Adjust Map Projection

Directly below Map Area, find the 'Map Projection' setting. Test the 'Mercator' or 'Miller' options to see which projection scales your specific geographic data best.

Chart Restored: Setting the map area to only regions with data usually immediately forces the map graphic to expand and fill the plot area.

Solution 2

Clean Up Source Data Range

Remove blank rows and invalid geographical names from your source data that might be causing the map to scale incorrectly.

Free Microsoft Office alternative

Create Beautiful Data Visualizations with WPS Office

If you frequently encounter layout and formatting issues in Microsoft Excel, consider trying WPS Office. It provides a lightweight, highly compatible, and free alternative with powerful spreadsheet tools and a familiar interface for managing your data effortlessly.

1. Download and Install: Get the free WPS Office suite from the official website and install it on your device.
2. Open Your Data: Launch WPS Spreadsheet and easily open your existing Excel workbooks without losing any data.
3. Insert Charts Seamlessly: Highlight your data and use the Insert tab to add perfectly scaled charts and graphs in seconds.

Free to use with a lightweight, fast installationHighly compatible with Microsoft Excel (.xlsx, .csv) formatsRich built-in chart templates for easy data visualizationFamiliar user interface ensures a seamless migration

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel map chart suddenly become so small?

This usually happens when the 'Map Area' is set to 'Automatic' and your data contains geographic locations that are very far apart, or if there are blank rows in your selected data range. Excel zooms out to try and fit everything into one view.

Can I manually drag and resize the map graphic inside the plot area?

No, Excel does not allow you to manually drag the corners of the map graphic to resize it independently of the plot area. You must fix the scaling by adjusting the 'Map Area' settings in the Format Data Series pane.

Why is my geographic data not mapping correctly?

Ensure your location names are spelled correctly and recognized by Bing Maps. You can highlight your locations, go to the 'Data' tab, and assign them the 'Geography' data type to resolve ambiguities.

Excel & Data Problems