Chart & Visualization Issues

How to Display Palestine and the West Bank in Excel Map Charts

Anum MushtaqAnum Mushtaq Nov 10, 2026 868 views

Question details

The user needs to display Palestine, the West Bank, and Gaza in an Excel Map chart, but the regions are not recognized or plotted correctly.

How to Display Palestine and the West Bank in an Excel Map Chart
Product
Microsoft Excel
Device & OS
not provided
Scenario
Creating a Map chart or using Geography data types with Middle Eastern regional data.
Observed behavior
The locations do not display as expected or appear as unplotted data because the geographic database fails to recognize the region names or boundaries.
Before you start

Ensure you have an active internet connection, as Map charts and Geography data types require online access to Microsoft's Bing Maps service to resolve location names.

Solution 1Recommended

Use Fully Qualified Geographic Names

Adjusting the location names in your dataset helps Excel's mapping service better identify and plot politically sensitive or specific regions.

Excel relies on Bing Maps for its Geographic data types. Disputed or politically sensitive regions sometimes require highly specific naming conventions to be recognized and plotted on the map.

1
Modify region names

Change 'Palestine' to 'State of Palestine' in your data column to match the geographic database's recognized terminology.

2
Separate specific territories

Use separate, distinct rows for 'Gaza' and 'West Bank' rather than grouping them under a single ambiguous name.

3
Add geographic context

Include adjacent columns for higher-level geographic context, such as 'Middle East' or 'Region', to help the engine pinpoint the exact locations.

4
Refresh the Map chart

Select your updated data range, navigate to the 'Insert' tab, and click 'Maps' to generate the chart again with the newly recognized names.

Use Fully Qualified Geographic Names
Database Limitations: If the locations still fail to plot, Excel's current map boundaries may not support these specific regions natively, and you will need to use a custom shape map.
Free Microsoft Office alternative

Try WPS Office for Seamless Data Visualization

If you frequently encounter database limitations or missing features with Microsoft Office charts, consider switching to WPS Office. It offers a lightweight, highly compatible alternative for handling complex datasets and creating professional visualizations without the heavy resource requirements.

  1. 1. Download and Install: Download WPS Office from the official website and follow the simple installation instructions.
  2. 2. Open Your Data File: Launch WPS Spreadsheets and seamlessly open your existing .xlsx workbooks.
  3. 3. Create Visualizations: Select your data and use the rich built-in charting tools found under the 'Insert' tab to accurately visualize your statistics.
Fully compatible with Microsoft Excel (.xlsx) files.Rich library of customizable charts and data visualization tools.Free to download and use with a highly intuitive user interface.Lightweight software that runs smoothly on almost all devices.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel show a 'Map chart cannot plot this data' error?

This error occurs when Excel's geographic database cannot recognize the location names provided. This often happens with disputed territories, historical names, or highly localized regions that are not mapped in the Bing Maps service.

Can I manually draw or adjust regional boundaries in Excel Map charts?

No, Excel's native Map charts do not allow manual adjustment of regional boundaries. If a boundary is missing or incorrect, you must use a custom vector shape map or a specialized third-party mapping add-in.

Do I need an internet connection to use Excel Geography data types?

Yes, Geography data types and Map charts require an active internet connection to securely send your location data to Microsoft's online mapping service for geographic resolution.