Excel Geographical Heat Map: Create and Troubleshoot One

How-to basics · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, select a column of named geographic regions and a column of values, then choose Insert > Charts > Maps > Filled Map. Excel colors each region according to its value; this is a choropleth map, not a map of individual points or a true density heat map.

What Excel means by a geographical heat map

People use “geographical heat map” to describe several different visuals. Excel’s built-in Filled Map chart is the simplest option when the data is grouped by areas such as countries, states, or counties. It shades each area according to a numeric measure, such as sales, population, or the number of service calls.

A Filled Map is technically a choropleth. A darker or more intense fill represents a larger or smaller value, depending on the color scale. The color applies to the whole geographic region, so it does not show where within a state or county the underlying events occurred.

  • Filled Map: compares values attached to geographic regions.
  • Point or bubble map: places markers at locations, often using latitude and longitude.
  • Density heat map: shows clusters of many point locations as areas of higher intensity.
  • Cell heat map: uses conditional formatting to color spreadsheet cells; it is not a map.

This distinction matters when choosing a chart. For example, state-level revenue belongs naturally in a Filled Map. Store coordinates or individual incident locations call for a point-based map or a dedicated mapping tool instead.

Prepare the data before inserting the map

Map charts work best with a clean table in which each row has a recognizable location and a numeric value. A simple example might have the headers State and Orders, followed by rows for California, Texas, and other states. Keep the location and value fields in separate columns, and use one row per geographic area after aggregation.

Use full, consistent place names rather than abbreviations where possible. “Georgia,” for example, could mean a U.S. state or a country. Adding a country column can help distinguish ambiguous places. A location column that mixes countries, states, and cities can also cause Excel to interpret some entries at an unexpected level.

  • Use a descriptive header for each column and remove blank rows within the data.
  • Check that values are numeric, not numbers stored as text.
  • Combine duplicate region rows if the goal is one value per region. A PivotTable can summarize detailed records by state or country.
  • Use consistent names and include a parent location, such as country, when names could be ambiguous.
  • Decide how missing values should be represented. A missing figure is not necessarily the same as zero.

Geographic recognition depends on Excel identifying the text as a place. If a name is ambiguous or unfamiliar, Excel may leave it unmapped or place it incorrectly. Check the chart against the source list rather than assuming that every label was resolved correctly.

Create a Filled Map in Excel for Microsoft 365

On Windows, create the chart from the prepared table using these steps:

  1. Select the geographic labels and their corresponding numeric values, including the column headers.
  2. Open the Insert tab, then choose Charts > Maps > Filled Map. Depending on the ribbon layout, Maps may appear as a chart button or in the recommended chart options.
  3. Wait for Excel to resolve the locations and draw the map. If prompted about geographic data, review the information and allow the map service if your organization permits it.
  4. Select the chart to use the chart tabs. Add a clear title, adjust the color scheme, and resize the chart so labels and the legend are readable.
  5. Inspect the result for missing or misplaced regions. Correct the source labels or add geographic context, then refresh or recreate the chart if necessary.

Excel for the web has chart support that can differ from the Windows desktop app, and the desktop Mac app may have a different feature set or ribbon layout. If Maps is absent, check the version and platform, and open the workbook in current Excel for Microsoft 365 on Windows to access the workflow described here. Organizational settings and connected-service availability can also affect map features.

Format the map so the colors communicate clearly

After selecting a Filled Map, use the chart formatting controls to choose colors and set a useful title. A good title states both the measure and the time period, such as “Orders by State, Q2 2026.” Keep the legend visible if readers need to interpret the shades, and avoid a palette where neighboring values are nearly indistinguishable.

Think carefully about what the colors mean. A sequential scale is suitable when values run from low to high. A diverging scale can be useful when the meaningful reference point is a midpoint, such as above or below a target, provided the chart offers an appropriate scale for the data. Do not imply that a darker shade always means “better”: the legend and title should make clear whether the measure is revenue, complaints, risk, or something else.

Map labels depend on the area and the chart’s available space. A map covering many small regions can become crowded, so labels may be less useful than a clear legend and a companion table. If readers need exact values, include a table or data labels where practical rather than asking them to estimate values from color alone.

Choose the right measure and geographic level

Raw totals can make large or populous places appear more important simply because they contain more people, customers, or locations. Suppose one state has 10,000 support requests and another has 2,000. The first has the larger count, but it may not have the higher request rate once population or customer count is considered. If the question is about intensity or performance, a rate or per-capita measure may be more informative than a total.

The geographic level should match the decision. Country-level data can obscure differences within a country; county-level data can be more revealing but may be harder to label and interpret. A regional map is a summary, not evidence that every part of the shaded region has the same value. For small-area analysis, verify that the chart supports the intended geography and that the source data is sufficiently reliable.

Be cautious when comparing periods. If the map’s scale changes between charts, the same shade might represent different values in each period. For a fair visual comparison, use consistent units and comparable color ranges, or show the actual values alongside the maps.

Filled Map versus 3D Maps and other options

Use a Filled Map when your records are already summarized by recognized areas and the key task is comparing those areas. It is a standard chart embedded in the worksheet and is convenient for reports and dashboards.

Excel’s 3D Maps feature is a different tool, available in supported Windows desktop versions. It is designed for geographic data such as addresses or coordinates and can plot records as points or other layers; its available visualizations include a heat map layer in supported versions. It is better suited to exploring many locations than shading states by a single aggregate value. Its interface and availability differ from the ordinary chart workflow, and it is not the same as a Filled Map. 3D Maps is not available in Excel for Mac in the same way as the Windows desktop feature.

Other options include mapping software or a web-based geographic information system when you need custom boundaries, detailed point analysis, specialized projections, or more control over geographic layers. For a quick spreadsheet comparison of standard regions, a Filled Map is usually simpler. For a cell-based view of a matrix, use Home > Conditional Formatting instead; that colors cells but does not place data on a geographic outline.

Common problems and how to fix them

  • The Maps command is missing: Confirm that you are using a supported desktop version and that your organization has not disabled connected experiences or map services. Try opening the file in Excel for Microsoft 365 on Windows.
  • A location is missing or wrong: Replace abbreviations with full names, add a country or state column to clarify the place, and check for spelling errors. A name can be valid in more than one geographic context.
  • The chart has unexpected totals: Look for duplicate location rows, text-formatted numbers, or detail records that were not aggregated. Summarize the data to the intended map level.
  • Some regions are blank: Check whether Excel recognized the label and whether the value is missing, text, or zero. These conditions can produce different results.
  • The map does not show points: A Filled Map colors areas; it does not plot latitude and longitude as individual markers. Use 3D Maps or a mapping tool for point data.
  • The visual seems misleading: Review the metric, units, legend, and geographic level. A map of totals answers a different question from a map of rates.

Map charts rely on online geographic information and may be affected by network access, privacy settings, regional availability, or workplace policies. If the chart cannot resolve locations, check the connection and Excel’s connected experiences settings, or ask your Microsoft 365 administrator whether the service is restricted.

Frequently Asked Questions

Can Excel make a heat map from latitude and longitude?
A Filled Map chart is not designed to plot individual latitude-and-longitude points. In supported Windows desktop versions, Excel 3D Maps can work with geographic fields and includes a heat map layer; for advanced density analysis, a dedicated mapping application may offer more control.

Is an Excel Filled Map the same as a heat map?
Not exactly. A Filled Map is a choropleth that shades defined regions using their values. A density heat map highlights concentrations of point locations, while Excel conditional formatting colors worksheet cells.

Can I map city, county, or ZIP code data?
Excel can recognize several geographic levels, but coverage and recognition depend on the location type and how clearly the data identifies it. Postal-code support can be limited or context-dependent. Test a small sample, include parent geography where needed, and check the plotted results.

Why is my Filled Map blank?
Common causes include unrecognized place names, ambiguous abbreviations, values stored as text, disabled online map services, or an unsupported Excel environment. Try full place names with a country or state context, verify the values, and check service access.

Can I use a custom boundary map in Excel?
Filled Map charts use geographic regions Excel can identify; they are not a general custom-boundary editor. If your territories are sales districts or other nonstandard shapes, use mapping software that supports custom geographic files, or choose a different visual such as a labeled diagram.

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.