'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Excel Map Chart Not Recognizing New India Districts
Question details
Users are unable to plot newly created Indian districts on an Excel Map Chart because the locations are either unrecognized or identified as older districts.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Creating a map chart in Excel to visualize geographic data using recently established Indian district boundaries.
- Observed behavior
- The Excel Map Chart fails to recognize new Indian districts, such as Anakapalli, mapping them incorrectly as older districts or leaving them blank due to an outdated backend geographic database.
Verify that your location names are spelled correctly and formatted properly before concluding that the geographic database is outdated.
Request a Geographic Database Update from Microsoft Support
Because Excel relies on the Bing Maps database for geographic data, missing new districts must be escalated to Microsoft Support for a backend update.
Excel uses a backend geographic mapping service to plot locations. When governments create new districts or borders, it takes time for this service to reflect the changes. The most direct way to resolve this permanently is to have your administrator request an update.
Ask your Microsoft 365 administrator or IT department to log into the Microsoft 365 Admin Center.
In the admin center, navigate to the 'Support' section in the side menu and select 'New service request'.
Provide Microsoft Support with the specific names of the unrecognized districts (e.g., Anakapalli) so they can investigate the map data and determine if the updated district boundaries can be added.
Use Older District Boundaries as a Temporary Workaround
While waiting for Microsoft to update their geographic database, consolidate your data into the older, recognized district boundaries to keep your charts functional.
Try WPS Office for Seamless Spreadsheet Management
If you frequently encounter limitations or frustrating technical issues with your current office suite, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for all your spreadsheet, charting, and data visualization needs without the heavy subscription costs.
- 1. Download the software: Visit the official WPS Office website and download the free installer for your operating system.
- 2. Install WPS Office: Run the installer and follow the on-screen prompts to set up the software in just a few minutes.
- 3. Open your spreadsheets: Launch WPS Spreadsheets and open your existing Excel files directly to continue working on your data seamlessly.
Frequently Asked Questions
Why does Excel Map Chart fail to recognize certain locations?
Excel relies on an external geographic database (Bing Maps) to plot locations. If a district or administrative boundary was recently created, the database may not have been updated yet to include those new borders.
Can I manually add a new district to the Excel Map Chart?
No, you cannot manually update the built-in map database in Excel. The mapping boundaries are controlled server-side by Microsoft, requiring a backend update to add new regions.
How long does it take for Microsoft to update map data?
There is no set timeline for geographic updates. Filing a support ticket through the Microsoft 365 Admin Center can help bring missing regions to their attention and potentially expedite the investigation.
Are there workarounds if my district isn't recognized?
Yes, you can temporarily group your data into the older, recognized parent districts, or you can explore third-party geographic mapping add-ins from the Microsoft Store that might have more up-to-date regional data.
