'%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)
How to Fix Excel Map Chart Missing from the Chart List
Question details
The user is unable to find the Filled Map chart option in Microsoft Excel, even after following standard instructions to locate and enable map charts.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to insert a Filled Map chart to visualize geographical data in a spreadsheet.
- Observed behavior
- The Filled Map chart option is completely missing from the Insert Charts menu.
Ensure your computer has an active internet connection, as Map Charts require online services to process geographic data, and save your current workbook before running any Office repair tools.
Verify Excel Version and Locate the Map Chart
Check if your current Excel version supports Map Charts and verify you are looking in the correct menu path.
Map Charts are only available in Microsoft 365 subscriptions, Excel 2019, and Excel 2021. Older standalone versions like Excel 2016 do not support this feature. Additionally, some enterprise update channels may delay the rollout of newer visualization tools.
Open your Excel workbook, select your geographical data, click on the 'Insert' tab on the ribbon, and navigate to 'Charts' > 'Maps' > 'Filled Map'.
Click on 'File' in the top-left corner and select 'Account' (or 'Help' in older versions). Look under 'Product Information' to confirm you are using Microsoft 365, Excel 2019, or Excel 2021.
While on the 'Account' page, click 'Update Options' and select 'Update Now' to ensure you have the latest features installed.
Perform an Online Repair of Microsoft Office
If your Excel version supports map charts but the feature is still missing, repairing the Office installation can restore missing or corrupted components.
Use WPS Office for Free and Seamless Spreadsheet Data Visualization
If Microsoft Excel is experiencing licensing issues or missing features, WPS Office offers a free, lightweight, and highly compatible alternative. It provides robust charting tools to help you visualize your spreadsheet data effortlessly without expensive subscriptions.
- 1. Download and Install: Download WPS Office from the official website and follow the quick, lightweight installation process.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing .xlsx data files directly without losing any formatting.
- 3. Visualize Your Data: Highlight your data, navigate to the Insert tab, and choose from a wide variety of professional charts to visualize your information.
Frequently Asked Questions
Why is the Map Chart option grayed out in Excel?
The Map Chart option is typically grayed out if you are working in an older Compatibility Mode format like .xls, or if your selected data is not formatted properly. Try saving your workbook as a modern .xlsx document.
Do I need an internet connection to use Map Charts in Excel?
Yes, Excel Map Charts require an active internet connection because the feature relies on Bing Maps online services to accurately process and plot your geographical data.
Are Map Charts available in Excel 2016?
No, the Map Chart feature was introduced after Excel 2016. It is only available to users with Microsoft 365 subscriptions, or standalone versions of Excel 2019 and Excel 2021.
Can I create a map chart without geographical data?
No, map charts are specifically designed to plot geographical information. Your dataset must contain valid geographic text such as countries, regions, states, or postal codes.
