Fix Missing Map Chart Region Options in Excel
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.

- 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.
Ensure your device has an active internet connection, as Excel Map Charts rely on Bing Maps to process geographic data and render regions accurately.
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.
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.
Click the Trust Center Settings button, then select Privacy Options from the left pane, and click the Privacy Settings button.
Scroll down to the Connected Experiences section and check the box next to 'Turn on optional connected experiences'.
Click OK to save your changes, close Microsoft Excel completely, and reopen your workbook to attempt creating the Map Chart again.
Format and Clarify Geographic Data
Unclear data labels or ambiguous location names prevent Excel from identifying the correct geographical boundaries, causing it to restrict map options.
Verify Microsoft 365 Account and Version
The dynamic Map Chart feature and its full range of formatting options are exclusively available to Microsoft 365 subscribers.
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. Download and Install: Get WPS Office for free from the official website and easily install it on your Windows, Mac, or Linux device.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing .xlsx or .xls files seamlessly without formatting loss.
- 3. Visualize Your Data: Select your data and use the Insert tab to choose from a variety of professional charts to visualize your metrics.

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.




