How to Display Palestine and the West Bank in Excel Map Charts
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.

- 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.
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.
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.
Change 'Palestine' to 'State of Palestine' in your data column to match the geographic database's recognized terminology.
Use separate, distinct rows for 'Gaza' and 'West Bank' rather than grouping them under a single ambiguous name.
Include adjacent columns for higher-level geographic context, such as 'Middle East' or 'Region', to help the engine pinpoint the exact locations.
Select your updated data range, navigate to the 'Insert' tab, and click 'Maps' to generate the chart again with the newly recognized names.

Insert a Custom Map Shape
When native Map charts fail to support specific regional boundaries, using a custom vector shape map is the best alternative to visualize your data.
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. Download and Install: Download WPS Office from the official website and follow the simple installation instructions.
- 2. Open Your Data File: Launch WPS Spreadsheets and seamlessly open your existing .xlsx workbooks.
- 3. Create Visualizations: Select your data and use the rich built-in charting tools found under the 'Insert' tab to accurately visualize your statistics.

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.




