Chart & Visualization Issues

Fix Missing Map Chart Region Options in Excel

Maira MehtabMaira Mehtab Nov 10, 2026 869 views

Question details

The user is unable to find specific region options such as Multiple countries or regions and Countries or regions when customizing a Map Chart in Excel, as only World and Regions with Data are available.

How to Fix Missing Map Chart Region Options in Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
Creating and customizing geographic visualizations using the Map Chart feature in Excel.
Observed behavior
The Map Chart formatting options lack the expected regional choices, limiting the user's ability to adjust the geographic display boundaries.
Before you start

Ensure your device has an active internet connection, as Excel Map Charts rely on Bing Maps to process geographic data and render regions accurately.

Solution 1Recommended

Enable Connected Experiences in Trust Center

Map Charts rely on Microsoft's cloud-based connected experiences. If these privacy settings are disabled, the dynamic region options will fail to load properly.

Excel sends geographic data to Bing Maps over the internet to generate map charts. Without connected experiences enabled, the software cannot communicate with Bing Maps, resulting in missing region options and limited functionality.

1
Open Trust Center

Launch Excel, click on the File tab in the top-left corner, select Options at the bottom, and click on Trust Center in the left sidebar.

2
Access Privacy Settings

Click the Trust Center Settings button, then select Privacy Options from the left pane, and click the Privacy Settings button.

3
Turn on Connected Experiences

Scroll down to the Connected Experiences section and check the box next to 'Turn on optional connected experiences'.

4
Restart Excel

Click OK to save your changes, close Microsoft Excel completely, and reopen your workbook to attempt creating the Map Chart again.

Feature Unlocked: Once connected experiences are enabled, Bing Maps will successfully retrieve all available geographic boundaries.
Free Microsoft Office alternative

Create Stunning Charts and Visualizations with WPS Office

If you're experiencing missing features, subscription restrictions, or complex privacy settings in Microsoft Excel, consider switching to WPS Office. It provides a comprehensive, free, and lightweight spreadsheet tool that natively supports Microsoft Excel formats, offering powerful data visualization capabilities without the heavy subscription costs.

  1. 1. Download and Install: Get WPS Office for free from the official website and easily install it on your Windows, Mac, or Linux device.
  2. 2. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing .xlsx or .xls files seamlessly without formatting loss.
  3. 3. Visualize Your Data: Select your data and use the Insert tab to choose from a variety of professional charts to visualize your metrics.
100% compatible with Microsoft Excel (.xlsx, .xls) files and formulas.Rich built-in chart types and visualization tools for effective data analysis.Free to use with a familiar, easy-to-navigate interface.Lightweight installation that runs smoothly even on older devices without internet dependencies.
microsoft office alternative - wps office

Frequently Asked Questions

Why is my Excel Map Chart only showing the World option?

This usually happens if Excel cannot recognize your data as specific countries or regions. Ensure your data columns are explicitly labeled (e.g., 'Country' or 'State') and that your Microsoft 365 connected experiences are turned on.

Can I use Excel Map Charts without an active internet connection?

No, generating and modifying Map Charts requires an active internet connection because Excel must send the geographic data to Bing Maps in the cloud to render the visual map regions securely.

Can I use Excel Map Charts without a Microsoft 365 subscription?

Map Charts are a premium feature that requires an active Microsoft 365 subscription. Standalone perpetual licenses like Excel 2016 or Excel 2019 do not support dynamic Map Charts.

What data types work best for Excel Map Charts?

Map Charts work best with high-level geographic data, such as Country/Region, State/Province, County, or Postal Codes. Highly specific metrics like street addresses, GPS coordinates, or latitude/longitude are not supported.