Yes. In Excel for Microsoft 365 on Windows, use 3D Maps to place a heat map over a geographic map; for values summarized by states, countries, or other regions, use a Filled Map chart instead. The right choice depends on whether you want to show clusters of individual locations or compare totals across named areas.
What an Excel map heat map shows
A heat map over a map uses color intensity to make areas with more plotted records stand out. For example, a retailer could map thousands of store visits and see where visits cluster, or a city team could visualize the locations of service requests. The map provides geographic context that an ordinary Excel heat-map table, made with cell colors, does not.
The term can mean two different things in Excel. A 3D Maps heat map emphasizes the density of mapped records. A Filled Map chart colors geographic regions according to numerical values, such as sales by state. The second is often called a choropleth map. It looks like a heat map, but it answers a different question: how do the values compare among regions, rather than where are individual records concentrated?
Neither chart automatically explains what caused a hot spot. The color indicates a pattern in the data, not necessarily risk, performance, or importance. Readers need a clear title, legend, time period, and measure to interpret the display.
Choose between 3D Maps and a Filled Map
- Use 3D Maps with Heat Map when your source contains individual records with geographic locations and you want to show where those records are concentrated. It is suited to event locations, customer addresses, or GPS points.
- Use a Filled Map when your table already contains one value per area, such as revenue by country, cases by county, or population by state. Each recognized region receives a color based on its value.
- Use a regular Excel heat-map table when the comparison is between categories and periods, not places. Home > Conditional Formatting > Color Scales can color cells, but it does not put those values on a geographic map.
A common misconception is that a Filled Map is a point-density heat map. It is not: it fills recognized geographic boundaries. Conversely, a 3D Maps heat map is not automatically a reliable way to compare a numerical measure such as revenue. If the question is about weighted totals by state, aggregate the data by state and use a Filled Map or another chart designed to show those totals.
Prepare the location data
Map quality depends heavily on clean, unambiguous location fields. One row should represent one observation, such as one delivery, sale, or incident. Use separate columns for fields such as street address, city, state or province, postal code, country, latitude, and longitude. You do not need every field, but adding country or state information helps distinguish places with the same name.
For example, a table of store visits might contain Visit Date, Street, City, State, Postal Code, Country, and Visit ID. A table of regional sales might instead contain State and Sales Total. Use consistent spellings and avoid mixing abbreviations with full names unless the geographic data service recognizes them reliably. Check for blank locations, misspelled place names, and rows with extra spaces. If you have coordinates, keep latitude and longitude in separate numeric columns and verify that they have not been swapped.
Turn the source range into an Excel table before mapping. Select a cell in the data and choose Insert > Table, or press Ctrl+T on Windows (Command+T on Mac). Confirm that the table has headers. A table makes the source easier to manage when new observations are added, although you should still check whether the map includes newly appended rows after refreshing or reopening it.
Create a heat map in 3D Maps
These steps are for the desktop version of Excel for Microsoft 365 on Windows. 3D Maps is not available in Excel for the web or Excel for Mac, so Mac users should consider a Filled Map where regional data is appropriate, or use a mapping tool that supports point-density layers.
- Select a cell in the prepared table.
- Choose Insert > 3D Map > Open 3D Maps. If Excel asks whether to enable the feature or create a tour, follow the on-screen prompts.
- In the 3D Maps window, check that Excel has identified the location columns correctly. In the Layer Pane, assign the relevant fields to Location. For a street-level dataset, use the most complete address fields available; for coordinates, assign the latitude and longitude fields to their corresponding geographic roles.
- Choose the Heat Map visualization for the layer. The available visualization choices and field wells appear in the Layer Pane; assign the fields that Excel requests for the selected layer.
- Inspect the map and its legend. Adjust the map view and layer options so that the geographic pattern is visible without obscuring important context.
- Close or return to the workbook when finished. Save the file as an Excel workbook so the map tour remains part of the workbook.
3D Maps can also display other kinds of layers, including columns, bubbles, and regions. Those views can be more suitable than a heat map when you need to compare individual places or show a measure. The heat-map layer is most useful for visual density; do not assume its colors represent a business metric unless the selected setup and legend clearly show that measure.
Make a regional map with a Filled Map chart
For totals already grouped by geographic area, arrange a simple table with one area per row and a numeric value beside it. For example, list State and Sales Total, with exactly one state name per row. Select the table and choose Insert > Maps > Filled Map. Excel uses the geographic labels to identify the regions, then applies a color scale to the values.
Review the result rather than assuming every label was matched correctly. A state name such as Georgia could refer to a U.S. state or a country, so include a country column or make the region labels more specific where possible. Use Chart Design and Format options to add a meaningful title, adjust the color scale, and make the legend understandable. If Excel cannot identify a location, correct the source labels and recreate or update the chart.
Filled Maps are useful for comparisons at supported administrative levels, but they do not show street addresses or individual GPS points. Their geographic detail and supported regions depend on Excel’s map data. If a chart cannot resolve a county, district, or postal code in your dataset, try a more widely recognized level, add parent-region context, or use a mapping product with the needed boundary data.
Design choices that make the map useful
A map can look dramatic while communicating little. Match its design to the decision or question the reader needs to answer. Use a specific title such as Service requests by location, January–June 2026, rather than simply Heat Map. State what one record represents and identify the period covered. For a Filled Map, label the measure and units, such as sales in thousands of dollars.
- Choose a restrained color ramp with enough contrast to distinguish low and high values.
- Keep the legend visible and explain whether stronger color means more records or a larger numeric value.
- Check whether a few dense city clusters make less populated areas appear empty; a separate regional chart or table may provide useful context.
- Filter out test records and duplicate events if they do not belong in the analysis.
- Use a consistent time window. A map combining several years can hide a recent change or make old locations appear current.
Do not interpret a darker area as a higher rate without considering population or another relevant denominator. Ten incidents in a small town and ten in a large city are the same count, but not necessarily the same rate. A map of counts answers where the total is larger; a rate map requires the rate to be calculated appropriately before mapping.
Common problems and how to fix them
Locations appear in the wrong place: Add context such as state, province, or country, and confirm that latitude and longitude have not been reversed. A city name on its own may match a different place than intended.
Some locations are missing: Look for blank cells, inconsistent names, unsupported geographic levels, or values stored in an unexpected format. Try a more complete address or use coordinates where your data source provides them. Recheck the map after correcting the source table.
The map is too crowded: A large number of nearby points can merge visually. A heat map is often preferable to many separate markers for density, but it still cannot resolve every individual location. Filter to a useful period or category, or summarize the records to a geographic level that matches the question.
The color does not match the metric you care about: Confirm what the selected layer is encoding. A density layer should not be described as sales intensity just because sales records were used to create it. For a metric total by region, create a summarized table and use a Filled Map, or select another visualization whose legend represents the measure.
The map does not update as expected: Confirm that the source table includes the new rows, then refresh or reopen the map and check the selected data range. For a Filled Map, also make sure the added region is recognized and the chart’s source range includes it.
Alternatives and platform limits
If you use Excel for Mac or Excel for the web, 3D Maps is not the built-in route for a point-density map. A Filled Map may work when the data is aggregated by supported regions, depending on the Excel version and available map features. For address-level density on those platforms, consider a dedicated geographic information system or mapping service that accepts coordinates and offers a heat-map layer. Check your organization’s rules before uploading customer or sensitive location data to an external service.
Other Excel visuals can help when the map is not essential. A bar chart is often clearer for ranking states or countries, and a PivotTable can summarize counts by location and period. A map is most valuable when spatial relationships—nearby clusters, gaps, or regional patterns—are central to the question, not merely because the data contains place names.
Frequently Asked Questions
Can Excel make a heat map from addresses?
Yes, in 3D Maps on Windows, provided Excel can identify the address fields. Include as much location context as possible, such as city, state, and country, and review the plotted locations for mismatches.
Is a Filled Map the same as a heat map?
No. A Filled Map colors geographic regions according to values, while a 3D Maps heat map emphasizes the concentration of plotted records. They can look similar but represent different things.
Can I create a point-density heat map in Excel for Mac?
Excel for Mac does not include 3D Maps. You may be able to use a Filled Map for regional values, but address-level density generally calls for a separate mapping tool.
Why does Excel put a location in the wrong country?
Place names can be ambiguous. Add country, state, or province information, or use verified latitude and longitude coordinates, then inspect the map again.
Can a heat map show sales by location?
It can show where sales records are concentrated, but that is not necessarily the same as showing sales amounts. To compare sales totals by state or country, aggregate the amounts by region and use a Filled Map or another chart with a clear value scale.
Related
- Excel Data Table Greyed Out? Causes, Checks, and Fixes
- Excel Solver Add-In: How It Works and How to Use It
- Excel Remove Duplicates: Steps and Safer Options
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Hide Columns in Excel With a + SignTo hide columns and keep a plus sign you can click to show them again, group the columns:…
- Excel Auto Group Rows: How to Group and UngroupExcel can automatically group rows when it finds summary formulas linked to detail rows: select a cell in…
- Excel Slicer Font Size: What You Can and Can’t ChangeIn Excel for Microsoft 365 on Windows, a slicer has no ordinary Font Size box on the ribbon.…
- Can You Put a Page Break in Excel? Here’s HowYes. In Excel for Microsoft 365 on Windows, select the cell below and to the right of where…
- Open a ZIP File in Excel: Extract and Import DataYou can’t open a ZIP archive directly in Excel. First extract its contents with File Explorer, then open…
- Freeze Heading Row in Excel: Keep Column Labels VisibleTo keep your column labels visible as you scroll in Excel, select View > Freeze Panes > Freeze…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.