Fix a Grayed-Out Map Chart in Excel 2016
Question details
The user needs to create a map chart from geographic data in Excel 2016.

- Product
- Microsoft Excel 2016
- Device & OS
- not provided
- Scenario
- Geographic address data is selected for a map chart.
- Observed behavior
- The Map Chart command remains grayed out.
In Excel, open File > Account and check the product name and licensing edition. Organize the data into geographic regions, such as countries, states, counties, or postal codes, alongside the values you want to chart.
Use a Supported Excel Edition to Create a Map Chart
Use this approach if your installed Excel 2016 edition does not include modern filled map charts.
The standalone Excel 2016 edition generally does not include the modern Map Chart feature. Some Microsoft 365 subscription builds branded as Excel 2016 may support it, so check the product name and license before changing versions. Repairing Office cannot add a feature that your edition does not include.
Open File > Account and review Product Information. Select About Excel for additional version details.
Open the workbook in Excel 2019 or Microsoft 365 with a license that includes Excel.
Select the cells containing geographic regions and their values, including the column headings. Use regions such as states or postal codes rather than individual street addresses.
Choose Insert > Maps > Filled Map. If Excel prompts you to identify ambiguous locations, add another geographic column, such as country or state, and try again.

Create a Map Visualization in Power BI Desktop
Use Power BI Desktop on Windows if you cannot use a supported Excel edition and want another way to visualize geographic data.
Work With Geographic Data in WPS Spreadsheet
WPS Office is a free, lightweight alternative with a familiar interface for working on Excel files. Open and edit your geographic data in WPS Spreadsheet for an easier transition between office suites; it does not enable Excel's Map Chart feature.

Frequently Asked Questions
Does Excel 2016 support filled map charts?
Standalone Excel 2016 generally does not include the modern Map Chart feature. Some Microsoft 365 subscription builds branded as Excel 2016 may support it. Check File > Account for your product and license.
Will repairing Office add the missing Map Chart feature?
No. An Office repair cannot add a feature that is unavailable in your installed edition. Check File > Account before deciding whether to use a newer supported version.
What geographic data works with an Excel map chart?
Filled map charts compare values across regions such as countries, states, counties, or postal codes. Select the region and value columns, then choose Insert > Maps > Filled Map in a supported Excel version.
Why can't Excel identify my locations?
Some place names or postal codes are ambiguous. Add a country or state column to the selected data, and make sure you have an internet connection when creating the map.
Can WPS Office turn on Excel's Map Chart command?
No. WPS Office cannot change the features available in Microsoft Excel. You can use WPS Spreadsheet to open and organize XLSX data, then use a supported mapping tool to create the visualization.




