County-Level Heat Map in Excel: How to Build One

How-to basics · Updated November 18, 2026

Yes—Microsoft Excel for Microsoft 365 can make a county-level heat map with a Filled Map chart. Prepare a table that identifies each county and its state alongside the value to map, select the data, then choose Insert > Maps > Filled Map; check the resulting map carefully because county recognition and detail vary by location.

What a county-level heat map shows

A county-level heat map colors geographic areas according to a numeric measure. For example, a public health analyst might map reported cases per 100,000 residents, a retailer might compare sales by county, or a local government might show average travel time. In a Filled Map chart, counties with different values receive different shades, making geographic patterns easier to spot than in a plain list.

The word heat map can also refer to a grid of colored cells in a worksheet. That is a different kind of visualization: it colors cells, not geographic boundaries. If you need county outlines on a map, use a Filled Map chart. If you only need to compare a large table of numbers, conditional formatting may be simpler.

A map is useful for showing where values are relatively high or low, but it does not explain why a pattern exists. It can also make a large, lightly populated county look more important than a small, densely populated one. Choose a measure that fits the question, and explain what the values represent.

Prepare county data before inserting the map

Excel needs to identify the places in your data as well as the numbers to display. County names are not unique across the United States, so do not rely on a name such as Washington County or Franklin County by itself. Include the state with every county. A practical source table has one row per county and columns for county, state, and the value being mapped.

  • Use consistent names, such as County in one column and State in another. If the chart does not resolve the two columns as intended, try a single location column with the county and state together, such as Autauga County, Alabama.
  • Keep the mapped measure in its own column. Use numeric values rather than numbers stored as text, and include a clear column heading such as Rate per 100,000 or 2025 sales.
  • Check for duplicate county-state pairs. If your source has multiple records for the same county, decide whether to sum, average, or otherwise aggregate them before mapping.
  • Use a consistent geographic scope. A table that mixes counties, states, cities, and ZIP codes can produce unexpected results because Excel may interpret different rows at different geographic levels.

For instance, if a dataset has one row per clinic, first summarize the clinic records into one value per county. A county total and a county average answer different questions, so document which one you use. For population comparisons, a rate or percentage may be more informative than a raw count, provided its denominator and time period are clear.

Create a Filled Map chart in Excel

  1. Put the location information and mapped values in adjacent columns, with a header row. Include both county and state, or make a combined county-and-state location column if that works better with your data.
  2. Select the full range, including the location columns, the measure, and the headings.
  3. On the Windows ribbon, choose Insert > Maps > Filled Map. Excel will send the geographic information to its mapping service to identify regions and draw the chart, so an internet connection is generally required.
  4. Wait for the chart to render, then inspect whether the mapped regions are counties rather than states or another unintended level. A chart appearing on screen does not by itself confirm that every location was matched correctly.
  5. Use the chart controls and the Format Data Series pane to adjust the map area and labels where those options are available. Choose a chart style with enough contrast to distinguish values without making the map difficult to read.

If Maps is unavailable or Excel reports that it cannot create the chart, check that you are using a supported, updated version of Excel and that connected mapping features are available under your organization’s settings. Map charts rely on online geographic services, and organizational privacy controls may restrict connected experiences. Excel for the web and Mac can have different feature availability and controls; if a particular command is missing, use a current Microsoft 365 desktop version on Windows or check Microsoft’s current support guidance for your platform.

Make the map easier to interpret

A good map tells readers what the colors mean. Give the chart a specific title, such as County-level unemployment rate, and state the period and units in the title or a nearby note. Add a source note if the data comes from an external agency. Without these details, a viewer may mistake a monthly count for an annual rate or assume that blank counties have a value of zero.

Consider the color scale carefully. A single sequential scale—light for lower values and dark for higher values—usually works well for values that rise from a meaningful minimum. A diverging scale is useful when the important reference point is a midpoint, such as change above or below zero, but only if the chart settings support the intended scale. Avoid relying on red and green alone: the distinction may be difficult for some readers to perceive, and the colors can carry unintended meanings.

Check the legend and labels at the size at which people will view the workbook. Small counties can be hard to see, and labels may overlap or disappear as the map is resized. A map that looks attractive on a large monitor may be unreadable in a printed report. Keep a county-level table alongside the map when readers need exact values or need to find a particular county.

Verify county matches and map boundaries

Excel interprets geographic text using its mapping services, so ambiguous names, misspellings, abbreviations, and unfamiliar boundary names can cause a location to be placed incorrectly or omitted. Inspect the map against a trusted county list or source map. Pay particular attention to counties whose names appear in multiple states and to records with unusual punctuation or abbreviations.

Compare the number of county records in the source with the places that appear on the chart. This is a useful first check, but it is not a complete validation: duplicate locations can obscure missing ones, and a place might be recognized at the wrong level. Look for obvious signs that an entire state has been shaded when you expected individual counties. Also check that the values shown in the legend match the range of your source values.

Boundary definitions and names can change over time, and a map service may not reflect every local boundary or naming convention. If precise legal boundaries matter, do not treat a general-purpose spreadsheet map as an authoritative boundary source. State the data year and mapping scope so that readers understand what the map represents.

Common problems and practical fixes

  • The map shows states instead of counties: Confirm that county and state are both supplied and that the selected range includes the county-level location fields. Try a combined county-and-state label, then recreate or refresh the chart and inspect the result.
  • A county is missing or appears in the wrong place: Check spelling, state identification, and duplicates. Try the full county name with its state rather than a short form. Correct the source data and rebuild the chart if necessary.
  • The map is blank or Excel cannot create it: Check your connection, Excel updates, and any organization settings that control connected services. Confirm that the selected data includes recognizable location information and numeric values.
  • Every county has nearly the same color: Review the values and the legend. A few unusually large values can compress the apparent differences among the rest. Check whether the measure is stored as numbers and whether a raw count is appropriate for comparison.
  • Blank areas are confusing: A blank may mean no data, an unrecognized location, or a region outside the displayed map area. Explain missing data in a note rather than letting viewers assume that a blank means zero.

Do not fix a mismatched county by changing its numeric value or inserting a guessed location. Correct the geographic field, then verify the result again. If a particular county cannot be reliably represented in the native chart, a table or a different mapping tool may be more honest than a polished but inaccurate map.

When Excel’s map is not enough

A Filled Map chart is convenient for a quick county comparison, but it offers less control than a dedicated geographic information system. It may not provide the exact boundary vintage, custom projections, multiple data layers, or detailed label placement needed for formal cartography. It is also not a substitute for a carefully designed map when small counties, islands, or complex regional boundaries are central to the analysis.

For a small project, a county map image or vector map can be placed behind a carefully aligned set of shapes and colored manually, but this is labor-intensive and becomes difficult to maintain as data changes. For repeatable reporting or custom boundaries, consider a GIS application or a mapping platform that supports the required county boundary files. Check licensing, data-handling requirements, and the source of geographic boundaries before choosing a service.

Another option is to skip the map when geography is not the main point. A sorted bar chart can make county rankings easier to compare, and a table with conditional formatting can preserve exact values. For a report, pairing a map with a ranked list often gives readers both the geographic pattern and the specific counties behind it.

Sharing, updating, and responsible use

When the source values change, confirm that the chart’s data range includes the new rows and refresh or recreate the chart as needed. Turning the source range into an Excel table with Insert > Table can make it easier to manage growing data, though you should still verify that the map includes new counties after an update. Keep a clean source-data sheet so readers can check the values behind the colors.

Before sharing a workbook, consider whether the location and measure could reveal sensitive information. County-level aggregation is less precise than an address-level map, but small counts can still expose information in some contexts. Follow your organization’s data rules, suppress or combine small groups where appropriate, and avoid including personal data that is not necessary for the analysis.

Frequently Asked Questions

Can Excel make a map of U.S. counties?
Yes, a Filled Map chart can display county-level data when Excel recognizes the locations. Include the state with each county, then verify that the chart is showing counties and that the matches are correct. Recognition can vary with names and available map coverage.

How do I make a county heat map in Excel?
Prepare a table with county, state, and a numeric measure, select the data, and choose Insert > Maps > Filled Map. Add a clear title and legend, then check missing and ambiguous locations against the source.

Why is Excel mapping my counties as states?
Excel may have interpreted the location fields at a broader level, or it may not have resolved the county names. Include both county and state, try a combined county-and-state location label, and inspect the rebuilt chart before relying on it.

Can I use a county map without internet access?
Excel’s map chart depends on online mapping services to identify and display geographic regions, so creating or updating one generally requires an internet connection. If offline access is essential, use a previously prepared static map or another workflow that supplies local boundary data.

Does a blank county mean its value is zero?
No. A blank region can indicate missing data, a location Excel did not recognize, or an area not shown by the map. Keep zero values distinct from missing values in the source and explain gaps in a note.

Is a Filled Map the same as conditional formatting?
No. A Filled Map colors geographic regions according to data; conditional formatting colors worksheet cells. Use the map for spatial patterns and conditional formatting for a colored table or matrix.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.