Fix Excel Map Chart Not Recognizing Maharashtra District Sales Data
Question details
The user needs to create a Maharashtra district-level sales map in Excel and troubleshoot why the Map Chart does not recognize the district names.

- Product
- Microsoft Excel Map Chart
- Device & OS
- not provided
- Scenario
- Creating a geographic sales chart from district-level sales data for Maharashtra, India.
- Observed behavior
- Excel Map Chart does not recognize district-level location data, so the Maharashtra district sales map does not render correctly.
Arrange your data so State, District, and the sales value are in separate columns. Remove summary rows such as Total from the geographic range before inserting the Map Chart.
Restructure Geographic Columns and Use Recognized Maharashtra District Names
Use this when your Excel Map Chart does not plot district-level values because it cannot recognize the location fields.
Excel Map Charts match geographic text against Bing geocoding. If district names are combined with other labels or located in a summary row, Excel cannot identify them as valid map locations.
Open the Excel workbook that contains your district-level sales data.
Add headers such as State, District, and Apple Sales. Fill the State column with Maharashtra on every data row.
Type standard district names such as Pune, Nashik, Nagpur, Aurangabad, Thane, or Mumbai Suburban in the District column.
Delete or move any Total, Grand Total, Average, or other summary row from the geographic data range because Excel treats those labels as invalid locations.
Select the State, District, and Apple Sales columns including headers, then go to Insert > Maps > Filled Map. Excel plots the recognized districts and may show unrecognized names for review.

Check Excel Version and Internet Connectivity for Map Charts
Use this if the Map Chart option is missing or geocoding still fails after the data structure is fixed.
Use WPS Office Spreadsheets as a Free Microsoft Excel Alternative for Sales Charts
When Excel Map Charts keep causing geocoding trouble, WPS Office Spreadsheets offers a free, lightweight, familiar way to open .xlsx sales workbooks and create district-wise charts without replacing your Excel workflow.
- 1. Download WPS Office: Click Download WPS Office Free and install WPS Office on your Windows or Mac computer.
- 2. Open the Excel sales workbook: Launch WPS Office Spreadsheets, go to Menu > Open, and select your .xlsx Maharashtra sales file.
- 3. Create a district-wise chart: Select the State, District, and Apple Sales range, then go to Insert > Chart and choose a bar or column chart for district sales visualization.

Frequently Asked Questions
Why does Excel Map Chart not recognize my Maharashtra district names?
Excel Map Charts require geographic data in dedicated columns and match text against Bing geocoding. Use separate State and District columns, keep Maharashtra in every State cell, and use standard district names.
Does Excel Map Chart work without an internet connection?
No. Excel Map Charts depend on Bing geocoding, so the computer must be online for Excel to match district names and render the map.
Which Excel versions support Map Charts?
Filled Map Charts are available in recent Excel versions such as Microsoft 365 and newer stand-alone Excel releases. If the option is missing, check File > Account to confirm your version.
Can WPS Office Spreadsheets create a filled geographic map chart?
WPS Office Spreadsheets focuses on standard chart types for everyday analysis. You can open the .xlsx file and create a district-wise bar or column chart, but use Excel when a filled geographic map is required.
How do I stop a Total row from breaking the Excel map?
Remove the Total row from the source range before you create the Map Chart. Keep only State, District, and sales value rows so Excel does not treat Total as an unknown location.




