Office Compatibility Issues

Fix a Grayed-Out Map Chart in Excel 2016

Steve KSteve K Nov 14, 2026 868 views

Question details

The user needs to create a map chart from geographic data in Excel 2016.

Fix a Grayed-Out Map Chart 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.
Before you start

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.

Solution 1Recommended

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.

1
Check your edition

Open File > Account and review Product Information. Select About Excel for additional version details.

2
Open the workbook in a supported version

Open the workbook in Excel 2019 or Microsoft 365 with a license that includes Excel.

3
Select regional data

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.

4
Insert the map

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.

Use a Supported Excel Edition to Create a Map Chart
Internet connection: Creating a map chart may require an internet connection so Excel can identify geographic locations.
Free Microsoft Office alternative

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.

Organize geographic regions and values in a spreadsheetOpen and edit Microsoft Excel XLSX filesUse a familiar spreadsheet interfaceGet started with a free, lightweight office suite
microsoft office alternative - wps office

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.