In Excel for Microsoft 365 on Windows, select a table containing geographic areas and numeric values, then choose Insert > Maps > Filled Map to shade each area according to its value. If you need to plot individual addresses or latitude-and-longitude points, use 3D Maps instead: a filled map shows regions, not location pins.
What a geographical location chart shows
In Excel, a geographical location chart usually means a map chart. Its most familiar form is a filled map, which colors countries, states, provinces, counties, or other recognized regions to represent data. For example, a sales table might shade each state according to total revenue. A darker color can represent a higher value, while a lighter color represents a lower one.
A map can make spatial patterns easier to spot than a long list of place names. It can reveal that results cluster in one part of a country, or that a few regions differ from their neighbors. But it is still a chart of the values you provide: it does not establish why a location has a high or low result, and it does not automatically calculate totals for you.
Excel has more than one mapping feature, and the distinction matters. A filled map colors geographic areas; 3D Maps places data points on a globe or map. Neither is the same as Excel’s Geography linked data type, which can attach geographic facts to place names in cells.
Prepare the data before inserting a map
Start with a simple, rectangular table: one row per geographic area, a column identifying the place, and a column containing the value to visualize. Include column headings and avoid blank rows within the data. A useful example is a list of states and sales totals. Make sure the values are numeric, rather than numbers stored as text, so Excel can use them to set the map’s shading.
Give Excel enough information to identify each place. A name such as Springfield or Victoria can refer to multiple locations. If names may be ambiguous, add a country, state, or province column. For instance, pair a city with its state and country rather than expecting Excel to infer which city you mean. Use consistent spellings and avoid adding extra notes to the same location cell.
- For a country-level map: use one row per country and a column for the measure, such as population or orders.
- For a state-level map: include the state or province and its country, especially if the data could be interpreted in more than one country.
- For point locations: keep addresses or latitude and longitude in separate columns; these are better suited to 3D Maps than to a filled map.
If your source has many rows for the same region—for example, one row per store—summarize it so each region has one value before making the filled map. Otherwise, Excel may not present the regional totals you intended. A PivotTable can help group records by region and calculate a sum or other summary; check the result before charting it.
Create a filled map chart
Once the table is ready, create the chart in Excel for Microsoft 365 on Windows with these steps:
- Select the location names and the numeric values, including their headings. Include a country or state column too if it helps identify places.
- Choose Insert > Maps > Filled Map. Excel inserts a map chart and attempts to match the place names to geographic regions.
- Check that the shaded areas correspond to the intended places. If Excel reports that it could not map some data, improve the location labels or add geographic context, then try again.
- Select the chart to use the chart design and formatting controls. Add a descriptive title and, if useful, data labels or a legend.
The map’s colors represent values, so make the meaning understandable without relying on color alone. A clear title might say Revenue by State rather than simply Sales. A legend helps readers interpret the color range, while data labels can identify selected values. If the chart contains many small regions, labels everywhere may overlap; in that case, a readable legend and a companion table may be more useful.
Format and interpret the map responsibly
Filled maps commonly use a color scale: Excel assigns colors to ranges of values. The visual result depends on the range and distribution of the data. If one region has a much larger value than all the others, most of the remaining areas may look similar because they occupy a narrow part of the scale. Consider whether a different scale or a second chart would make the pattern easier to understand, and explain any important choices in the chart title or notes.
Be careful when comparing totals across regions of different sizes. A state with more residents may naturally have more sales simply because it has a larger population. If the question is about performance per person, per store, or per square mile, calculate that measure in the source data and map it instead. A map does not normalize values automatically, and color intensity alone does not reveal the underlying reason for a difference.
Remember that a filled map emphasizes area. Large regions can draw the eye even when their values are modest, while small regions may be hard to see. For precise comparisons, include a table or a bar chart alongside the map. A map is strongest when location itself is part of the story, not when the only goal is to rank a long list of values.
Use 3D Maps for points and addresses
Choose 3D Maps when the data describes individual places rather than totals for named regions. Examples include store locations, customer sites, delivery stops, and measurements recorded at latitude-and-longitude coordinates. On supported Excel desktop versions for Windows, select the data and choose Insert > 3D Map to open the 3D Maps experience. You can build a map tour and display geographic data as points or other visual layers.
For the clearest positioning, provide separate latitude and longitude columns as numeric values. An address may also be geocoded, but it needs enough detail to identify the correct place, and a matched address can be less precise than reliable coordinates. Check the plotted results against known locations before sharing the visualization. 3D Maps is a different feature from a filled map and is not available in Excel for Mac or Excel for the web in the same way as the Windows desktop feature.
If you need a simple map of one value per country or state, 3D Maps is usually unnecessary. It adds a geographic point or tour workflow, whereas a filled map is designed for comparing values across regions. Conversely, a filled map cannot turn latitude and longitude into a set of pins.
Geography data type is not a map chart
Excel’s Geography linked data type is another feature people often mean when they ask for a geographical chart. It can recognize a place name in a cell and link it to geographic information, such as a country or city record. After converting a place name to the Geography data type from the Data tab, you can insert supported fields from the linked record into your worksheet. The exact fields depend on the place and the available data.
This data type is useful for enriching a table, but converting a cell to Geography does not itself create a map. To draw a filled map, you still need a location column and values, then insert a map chart. You can use the linked data type to make names more consistent or retrieve relevant fields, but verify the resolved place and any returned information before relying on it.
Common map problems and fixes
When a map looks wrong, the cause is often the source data or an ambiguous location name rather than the chart formatting. Check the following before rebuilding the chart:
- A place is missing: confirm its spelling and add a country, state, or province column to disambiguate it. Check whether the location is a geographic region the chart can recognize.
- The wrong place is shaded: add geographic context and inspect the match. A place name alone may refer to several locations.
- Values do not drive the colors as expected: check that the value column contains numbers and that repeated regions have been summarized appropriately.
- The map is too general: try a more specific supported region level, or use another approach if the chart cannot distinguish the boundaries you need.
- The Maps command is unavailable: check that you are using an Excel version and platform that support map charts, and that Office is up to date. Menu availability can differ by platform and release.
- The chart cannot resolve locations: check your internet connection and your organization’s connected-experience settings. Geographic matching can depend on online mapping services.
Map charts are intended for recognized geographic regions, not arbitrary custom boundaries. They also should not be treated as a detailed street map or as a substitute for a geographic information system. If the regions in your data are custom service areas, sales territories, or neighborhood boundaries that Excel does not recognize, a different mapping tool may be needed.
Sharing, privacy, and accessibility
Excel may use online services to interpret geographic labels or provide map information, so availability can depend on network access and your organization’s settings. If a workbook contains sensitive customer or employee locations, follow your organization’s data-handling rules and confirm which connected services are permitted before using them. Avoid assuming that an address is private simply because it appears in a worksheet.
Make the chart understandable to readers who cannot distinguish its colors easily. Choose a clear title, retain a legible legend, and do not communicate the result through color alone. A small table of key values or a written summary can provide an alternative way to compare regions. When sharing the workbook, include the source period and units—for example, orders in calendar year 2025—so readers know what the mapped values mean.
Frequently Asked Questions
How do I make a geographical map chart in Excel?
Select geographic names and numeric values, then choose Insert > Maps > Filled Map in a supported Excel version. Add country or state details when names might be ambiguous, and check the resulting matches.
Can Excel plot latitude and longitude on a map?
Use 3D Maps for data points with latitude and longitude, rather than a filled map. Filled maps shade recognized regions; they do not plot individual coordinate pairs as pins.
Why is my location not showing on the Excel map?
The name may be misspelled, ambiguous, or outside the regions the chart recognizes. Add a country or state column, verify the location match, and check that Excel can access the online services needed to resolve geographic data.
Can I map cities in Excel?
A filled map is primarily for geographic areas, not a pin for every city. For city locations or individual addresses, use 3D Maps where available, and include enough address detail or coordinates to identify each point correctly.
Is an Excel map chart the same as the Geography data type?
No. The Geography data type links a cell to information about a recognized place. A map chart visualizes data geographically; you must create the chart separately using location labels and values.
Choosing the right Excel map
For totals by country, state, or another supported area, use a filled map chart. For individual sites or coordinate-based data, use 3D Maps on a supported Windows desktop version. Use the Geography data type when you want to enrich place names in worksheet cells rather than draw a map. Whichever option you choose, prepare unambiguous locations, verify the matches, and pair the visualization with enough labels or supporting data for readers to interpret it correctly.
Related
- Find Duplicate Names in Excel: Methods That Work Well
- Find and Replace Tab Names in Excel: What Actually Works
- Excel Fill Down Shortcut: Use Ctrl+D to Copy a Column
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- How to Build a Thermometer Chart in Excel: Step by StepTo build a thermometer chart in Excel, put the completed amount and the amount remaining in a two-series…
- Pivot Table Stopped Working in Excel? Causes and FixesIf a PivotTable in Excel has stopped working, first select it and choose PivotTable Analyze > Refresh; if…
- Bubble Chart in Excel: Create, Format, and TroubleshootTo make a bubble chart in Excel for Microsoft 365 on Windows, arrange your data in three numeric…
- Google Sheets Chart Custom Font: What You Can ChangeYes, you can change a chart’s font in Google Sheets: select the chart, open the Chart editor, choose…
- Excel Pivot Chart Stacked Column: Show Grand TotalsExcel PivotCharts do not have a built-in option to place the sum above each stacked column. For reliable…
- Excel Waterfall Chart Connector Lines: How to FormatIn Excel for Microsoft 365 on Windows, select the waterfall chart’s data series, open Format Data Series, expand…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.