Yes. In Excel for Microsoft 365 on Windows, make a geographic heat map with a table containing a place name and a numeric value, then choose Insert > Charts > Maps > Filled Map. Excel colors recognized areas according to their values; the sample layout and setup steps below can serve as a reusable template.
What an Excel geographic heat map shows
Excel’s Filled Map chart is a choropleth map: it colors geographic regions to represent values associated with them. For example, a sales team could shade each U.S. state according to its sales total, or a nonprofit could compare program participation by country. A darker or more saturated shade usually represents a higher value, depending on the color scale you choose.
This is different from a point-density heat map. A Filled Map does not place a marker at every address, calculate distance between points, or show a cloud of overlapping locations. It colors recognized boundaries such as countries, states, provinces, or counties. If you need to plot individual stores, addresses, or latitude-and-longitude coordinates, a map chart may not be the right tool.
Excel identifies geographic names and matches them to map regions. The chart is most dependable when each name is specific and consistently written. If a place name could mean more than one thing, include its larger geographic context in the data rather than expecting Excel to infer it.
A simple template layout
Keep the chart source straightforward: one geographic field and one numeric field. For instance, a U.S. state-level sales sheet could begin like this:
- State — a recognized state name, such as California.
- Sales — a numeric total for the same reporting period and currency.
Example rows might be California — 125000, Oregon — 42000, and Washington — 68000. These are illustrative figures, not benchmark data. In a workbook, put the field names in the first row and one state per row below them. The map should then compare like with like: each value must refer to the same period, unit, and type of measure.
You can add useful supporting columns, such as reporting month, product category, or region manager, but keep the map’s geographic labels and values easy to identify. If your source has several rows for California because it lists individual stores, summarize the values by state first. A map needs a meaningful value for each area, not a pile of duplicate labels whose totals may be unclear.
For example, a national template can use Country and Orders, while a state-level template can use State and Orders. Avoid mixing countries and states in the same geographic column: they are different levels of geography, and the resulting map may be difficult to interpret.
Create the Filled Map chart in Excel
- Enter your geographic names and numeric values in adjacent columns, with clear headers such as State and Sales. Check that the values are stored as numbers rather than text.
- Select the two columns, including their headers. If you have extra fields, select only the geography and the value you want the map to show.
- On the ribbon, choose Insert > Charts > Maps > Filled Map. Excel creates a chart and attempts to match the labels to geographic areas.
- Review the map before formatting it. Look for unrecognized places, missing regions, or unexpected matches. Correct the source data if the geography is wrong.
- Use the chart controls and ribbon options to add a descriptive chart title, adjust colors, and show map labels if those labels help readers. Keep the title specific, such as State sales by quarter, rather than simply Map.
- Save the workbook and test the chart after changing a value or adding a region. This confirms that the chart reflects the data range you intend to maintain.
Map charts use online geographic information, so an internet connection may be needed to create or render the map. The exact availability of map features can depend on the Excel edition, update channel, and organizational settings. If Maps is missing from the Insert ribbon, check that Excel is current and that your installation supports map charts. Excel for Mac and Excel for the web can have different feature availability and ribbon layouts; if you cannot create the chart there, use the desktop Windows steps above and check the Maps options in the other version before relying on it.
Choose the right geographic level and values
Decide the level of geography before preparing the data. Countries work well for international comparisons; states or provinces are more useful for regional reporting; counties can add detail where Excel recognizes them. More detailed geography is not always better. A map with dozens of small areas can become hard to read, and some boundaries may not be available or may be difficult to identify from a name alone.
Use a measure that makes sense when compared across regions. Total revenue can show where revenue is largest, but it does not account for differences in population or customer base. A per-capita rate, conversion rate, or percentage may answer a different question. State clearly which measure the map displays and keep its units consistent. A map of percentages should not be labeled as raw counts.
Consider the effect of scale. If one region’s value is much larger than all others, a color gradient may make most regions look nearly identical. That does not necessarily mean Excel is broken; the range of values may be highly uneven. A separate table, a suitable rate, or a carefully chosen classification may help readers see useful differences without implying more precision than the data supports.
When names are ambiguous, add context. For example, Springfield alone could refer to multiple places, while a place paired with its state or country is clearer. Use one consistent spelling style and avoid abbreviations unless you know Excel recognizes them. If you have postal codes or less common administrative areas, test a few records before building the full workbook.
Format the map so it communicates clearly
Choose a restrained color scale with enough contrast to distinguish low, middle, and high values. A sequential palette, where shades grow steadily stronger, is generally appropriate for values that rise from low to high. Avoid colors that suggest a positive-versus-negative meaning unless the data actually has that meaning. Check that the map remains understandable for readers with color-vision differences; labels or a companion table can provide another way to compare values.
Give the chart a title that names the measure, geography, and time period when relevant. A title such as Monthly service requests by county, October 2026 tells readers more than Regional heat map. Include units in the title or a nearby note if the values are dollars, percentages, or rates. If the map does not show exact values clearly, keep a small source table alongside it rather than asking readers to estimate precise numbers from color alone.
Be careful when describing colors as good or bad. A high value might mean strong sales, but it could also mean a high complaint rate or a large number of overdue cases. Use a legend or explanatory note to state what the measure means and whether higher values are desirable. The map itself cannot explain that context.
Common problems and how to fix them
- A region is blank or not shaded: Check for misspellings, leading or trailing spaces, unsupported geography, or a value stored as text. Add a country or state context where a name is ambiguous. Confirm that the location is available at the map’s supported level.
- Excel maps the wrong place: Make the name more specific. A city or region name by itself can match more than one location. Include the state, province, or country in a separate field or in a clearly formatted location label, then inspect the result again.
- The chart shows unexpected totals: Look for duplicate geography rows. Summarize detailed records by the intended area before charting, and confirm that the values use the same currency, time period, and unit.
- Every region looks almost the same: Compare the smallest and largest values. A few extreme numbers can compress the visible color differences. Check for data-entry errors and consider whether a rate or a separate view would answer the question more clearly.
- The map is empty or unavailable: Check the internet connection, Excel version, and organizational settings. Map charts depend on geographic mapping services and may be restricted in managed environments.
- New rows do not appear: Check whether the chart’s source range includes them. Keeping source data in a well-structured Excel table can make ongoing additions easier to manage, but verify the chart range after expanding the dataset.
Make the template reusable
For a recurring report, keep the source data in one tidy table with a single header row and no blank rows splitting the records. Select the data and choose Insert > Table, then confirm that the table has headers. Use consistent column names and keep notes, totals, and footnotes outside the chart’s source columns. This structure makes it easier to append new observations and to filter or review the source.
Keep a stable geography field and separate reporting details into their own columns. For example, a table with State, Month, Product, and Sales can support different filtered views, while the map itself should show one selected measure at a time. Before sharing a refreshed report, verify that the selected period is correct and that no region has been omitted from the source.
If you start with store-level records, prepare a summary by geography using a PivotTable or another aggregation method, then use the summarized result for the map. Do not treat a repeated state name as a guarantee that Excel will add all underlying records in the way your analysis requires. A deliberate summary also makes it easier to check totals and explain how the map was produced.
Save a clean copy as a template only after removing example figures or labeling them clearly as examples. A template should explain the required geography level, the unit of the value, the reporting period, and any filters that affect the display. That small amount of documentation helps prevent a later user from interpreting the map as a different measure than it actually shows.
When to use another mapping option
A Filled Map is a practical choice for quick comparisons among administrative areas already recognized by Excel. It is not a full geographic information system. It offers limited control over boundaries and map layers, and it is not designed to calculate travel distances, display routes, or analyze exact coordinates.
If your data consists of latitude and longitude points, or if you need custom boundaries, detailed spatial analysis, or multiple layers, a dedicated mapping or geographic information system may be more appropriate. For simple point locations, other Excel chart types may be useful, but they do not replace a region-shading map. For a report where exact comparisons matter more than location, a sorted bar chart or a table can also be clearer and easier to access than a map.
Choose the map because geography is part of the question, not just because it looks engaging. A state map can reveal regional patterns, but it can also make large geographic areas appear more important than smaller ones. Pair it with values, rates, or a ranked list when readers need accurate comparisons.
Frequently Asked Questions
Does Excel have a geographic heat map template?
Excel includes Filled Map chart functionality, but the most flexible starting point is usually a workbook with your own geography-and-value table. Use the sample two-column structure above, then insert a Filled Map chart. Available prebuilt templates can vary, so check Excel’s template gallery if you specifically want a downloadable workbook.
How do I create a heat map by state in Excel?
Put one state name per row in one column and the corresponding numeric value in another. Select those columns and choose Insert > Charts > Maps > Filled Map. Review the matches and format the title and colors. Add country context if a label is ambiguous.
Can Excel make a heat map from ZIP codes or addresses?
Excel may recognize some postal or address data, but coverage and matching can vary. A Filled Map shades supported areas; it is not a reliable way to plot every street address as a point. Test a small sample first. For precise address or coordinate mapping, consider a dedicated mapping tool.
Why is my Excel map chart not showing some locations?
The place may be misspelled, ambiguous, unsupported at that boundary level, or missing a numeric value. Add geographic context, standardize the labels, check that the value is numeric, and confirm your Excel version and connection. Some mapping features may also be unavailable because of organization settings.
Can I use an Excel map chart without internet?
Map charts rely on online geographic mapping information, so an internet connection may be needed to create or display them. Offline behavior can vary by version and the chart’s existing state. If a workbook must work offline, test it in the actual environment and provide a table or conventional chart as a fallback.
Related
- Excel Data Table Cycling Through Results? Fixes Explained
- Excel Data Table Greyed Out? Causes, Checks, and Fixes
- Excel Solver Add-In: How It Works and How to Use It
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Weekday Text: Show Dates as Day NamesTo show a date as weekday text in Excel, use =TEXT(A2,"dddd") when A2 contains a real Excel date;…
- Excel Data Model Won’t Open? Causes and FixesIf an Excel Data Model won’t open, first confirm that the workbook has finished loading, then try opening…
- Excel Slicers Explained: Filtering PivotTables and TablesExcel slicers are on-sheet buttons that let you filter an Excel Table or PivotTable by clicking values such…
- How to Sort by Date in Google SheetsTo sort dates in Google Sheets, select the entire table, choose Data > Sort range > Advanced range…
- Share an Outlook Calendar Externally: Steps and OptionsYes. You can share an Outlook calendar with someone outside your organization by inviting their email address and…
- Excel Table Multiple Header Rows: What WorksNo. An Excel Table can have only one header row: the first row of the table range supplies…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.