'%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 Choropleth Map Cannot Plot County Data
Question details
The user is unable to generate a choropleth map in Excel using county-level data, such as Nebraska county names and beef cattle statistics.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to create a filled map (choropleth) visualization based on geographic county data.
- Observed behavior
- Excel fails to plot the data, likely due to ambiguous geographic locations, incorrect data formatting, or backend map service identification issues.
Ensure you have an active internet connection, as Excel relies on the Bing Maps service to render geographic data, and verify that your county names do not contain typos or extra spaces.
Separate and Format Geographic Data
Standardize your dataset by separating State and County into distinct columns and formatting numeric values correctly to help the map service identify locations accurately.
The Bing Maps service used by Excel can struggle with ambiguous locations if only a county name is provided. Adding a state column provides the necessary context for accurate plotting.
Insert a new column directly next to your County column and name it 'State'. Fill this column with the corresponding state name (e.g., 'Nebraska') for all rows.
Select the column containing your numerical values (e.g., beef cattle data), right-click, and select 'Format Cells'. Set the category to 'Number' and remove any embedded commas or text formatting.
Highlight the State, County, and Numeric Data columns. Navigate to the 'Insert' tab on the ribbon, click on 'Maps', and select 'Filled Map' to generate the visualization.
Test Excel in Safe Mode and Apply Updates
Run Excel in Safe Mode to bypass conflicting add-ins and ensure your Office installation is fully updated.
Contact Microsoft 365 Support
If your data is formatted correctly and Excel is updated, the backend Bing Maps service might be failing to process the request.
Create Stunning Data Visualizations with WPS Office
If Microsoft Excel's map services continue to fail or require complex troubleshooting, consider switching to WPS Office. It provides a lightweight, highly compatible, and free alternative with powerful data visualization tools.
- 1. Download and Install: Download WPS Office for free from the official website and install it on your device.
- 2. Open Your Dataset: Launch WPS Spreadsheets and open your existing .xlsx workbook seamlessly without losing data formatting.
- 3. Insert Charts: Highlight your data, navigate to the Insert tab, and explore the robust chart library to create beautiful visualizations instantly.
Frequently Asked Questions
Why does my Excel map chart show a blank map?
A blank map usually occurs if the geographic data is ambiguous, misspelled, or if Excel cannot connect to the backend Bing Maps service. Ensuring you have separate State and County columns often resolves this.
Do I need an internet connection to create Map Charts in Excel?
Yes. Excel requires an active internet connection to securely send your geographic data to Bing Maps, which generates and returns the visual map layout.
How do I fix location errors in Excel Maps?
Add secondary geographical columns for broader regions. For example, if a County name fails to plot, adding a 'State' or 'Country' column next to it provides more specific context to the map engine.
Why is Excel confusing my numerical data with text?
If numerical values contain embedded commas or custom text formatting, Excel may treat them as text, preventing them from being mapped. Use the 'Format Cells' menu to set the column strictly to 'Number'.
