How to Display County Names on an Excel Map Chart
Question details
The user wants to display specific county names directly on an Excel map chart for better geographic data visualization.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Creating a map chart to present county-level geographic data and trying to overlay text labels indicating the county names.
- Observed behavior
- Excel can color-code counties based on data categories, but lacks a robust, built-in option to display all county names directly on the map simultaneously.
Ensure your dataset is organized cleanly with a column for 'County' and an adjacent column for 'State' or 'Country' to help the mapping tool accurately identify the geographic regions before applying labels.
Check Built-in Map Label Options
Verify if your current version of Excel supports basic data labels for map charts by accessing the standard chart elements menu.
Click on your existing map chart to select it, then click the '+' (Chart Elements) icon that appears in the top right corner of the chart.
Check the box next to 'Data Labels' to see if any values appear on the map.
Hover over 'Data Labels', click the right arrow, and select 'More Options'. In the Format Data Labels pane, check 'Category Name' to see if Excel can pull your county names onto the map.
Use Microsoft Power BI for Advanced Map Labels
Since Excel map charts natively struggle with county text labels, using Power BI provides a robust, integrated solution for displaying geographic names.
Install a Geographic Mapping Add-in
Utilize third-party Excel add-ins to bypass the limitations of built-in map charts and enable text-based geographic labels.
Visualize and Manage Data Effortlessly with WPS Office
If complex mapping features or heavy software installations are slowing down your workflow, WPS Office offers a highly compatible, lightweight, and free alternative. It provides excellent spreadsheet management with familiar charting capabilities, helping you analyze and present data efficiently.

Frequently Asked Questions
Why are some counties failing to load on my Excel map chart?
Excel's Bing Maps integration relies on precise geographic data. Because many county names are duplicated across different states (e.g., 'Washington County'), you must include an adjacent column with the state or country name to help Excel pinpoint the exact location.
Can I hover over counties to see their names instead of displaying all labels at once?
Yes. Even if Excel does not natively display all county text labels across the map at the same time, you can hover your mouse pointer over any colored region on the chart. A tooltip will appear displaying the county name and its associated data value.
Are map charts available in older versions of Microsoft Excel?
No, the built-in Map Chart feature was introduced in Excel 2019. It is only available in Excel for Microsoft 365, Excel 2021, and Excel 2019. Users on older versions like Excel 2016 or 2013 will need to use add-ins like Bing Maps to create geographic visualizations.





