Excel

Map Charts in Excel: When to Use Them, Data Prep, and Common Mistakes

Q: Is Power Map / 3D Maps the same as a map chart?

No — they are separate features. Map charts (Insert > Charts > Maps) are 2D filled maps for quick overview reports. 3D Maps (Insert > 3D Map) is a separate tour/animation tool for time-series geographic data with 3D columns and geocoding. Power Map was the old name for 3D Maps and has been retired from the menu since Excel 2019.

By Sagnik Bhattacharya 6 Mar 2026 10 min read

Coding Liquids blog cover featuring Sagnik Bhattacharya for map charts in Excel, with geographic chart visuals.

Map charts are appealing because they turn location data into something immediately visual. But they are also easy to misuse. A map can look sophisticated while still being unclear, over-general, or built on inconsistent geography labels that Bing silently misplaces.

Coming Soon

Complete Excel Guide with AI Integration

Master formulas, pivot tables, data analysis, and charts — with AI integration.

Learn more

This tutorial covers the decision — when a map chart earns its place versus when a sorted bar chart beats it — and then the practical workflow: data preparation using the Geography data type, the exact Insert path, handling ambiguous names like "Georgia" (country vs US state) or "Washington" (state vs DC), and the troubleshooting list for the "We can't plot this data" error. For the cluster index of every Excel chart we cover, see the Excel formulas hub and the professional charts guide.

Map charts work in Excel 365, Excel 2019, Excel 2021, and Excel for the web. They use Bing Maps to resolve place names, so the feature needs an internet connection the first time each workbook loads. Excel for Mac supports map charts from version 16.24 onwards. Excel 2016 and earlier do not include this feature — their closest equivalent is 3D Maps (formerly Power Map), a separate add-in.

Prerequisites

Excel 365, 2019, 2021, or Excel for the web. Map charts are not in Excel 2016 or earlier.
At least one column of geographic identifiers (country name, state/province, county, postal code, or ISO code) plus one numeric column to plot.
An internet connection on first render — Bing Maps resolves names in the cloud, then caches results per workbook.
A minimum of five data rows. Excel's map chart rejects smaller datasets with "We can't plot this data" because colour scales need enough values to bin meaningfully.

When a Map Chart Earns Its Place

Maps show where extremely well and how much poorly. Choose a map chart when:

Geographic pattern is the story. Regional concentration of sales, delivery coverage gaps, country-level penetration of a product launch.
The reader cares about spatial clustering. E.g. "all our customers are on the US East Coast" is easier to see on a map than in any table.
You have 10+ locations. For fewer than 10 regions, a sorted bar chart is nearly always clearer.
You will pair it with a ranked table or bar chart. The map answers "where"; the table answers "how much". Together they outperform either alone.

Avoid a map chart when:

The reader needs a precise ranking. A map cannot clearly show that Germany beats France by 3% — but a sorted bar chart can.
You only have 2–5 regions. Show the numbers, not a mostly-empty world map.
Your data is by city within a single country. Map charts handle country-level and state-level cleanly, but city-level coverage outside the US, UK, and a few other countries is patchy. Use 3D Maps or a dedicated tool.
The audience is the finance team and needs to reconcile the numbers. Maps hide exact values by design.

Step 1: Prepare the Location Data

Map charts live or die on the location column. Start with these rules:

One geographic level per column. Mixing "Germany", "Berlin", and "Bavaria" in one column will fail or silently misplace values. Split into Country / State / City columns.
Standardise spelling. "UK", "U.K.", "United Kingdom", and "Great Britain" all resolve — but inconsistent labels across rows make the chart group some UK values together and treat others as separate regions.
Disambiguate collisions. "Georgia" could be a US state or the country; "Washington" could be the state or DC; "Victoria" exists in Canada, Australia, and South America. Add a second column (Country, or Country/Region) so Bing Maps has context.
Use ISO codes for countries when possible. Two-letter (ISO 3166-1 alpha-2) or three-letter (alpha-3) country codes resolve faster and avoid spelling-variant issues. "DE" is less ambiguous than "Germany".

Real-world scenario. A SaaS company maps subscriber count by country for a board pack. The raw export had 47 countries but the first map chart only rendered 41, because "USA", "U.S.", and "United States" were treated as three separate regions. A 30-second Find & Replace on the country column fixed it. The beginner pitfall here is assuming Excel normalises common variants — it does not.

Using the Geography Data Type (Optional but Useful)

In Excel 365 and 2021, you can explicitly convert a location column to the Geography data type:

Select the location column (headers and data).
Go to Data → Data Types → Geography.
When a name is ambiguous, Excel shows a question-mark icon. Click it and pick the right entity (e.g. "Georgia (United States)" vs "Georgia (country)").
Once converted, each cell becomes a rich object — you can extract capital, population, area, or abbreviation with =A2.Population syntax.

The Geography data type is not required for a map chart to work. But it is worth using when names are ambiguous, because it lets you pick the right entity once instead of hand-fixing mismatches after the chart fails to render.

Step 2: Insert the Map Chart

Select the location column and the value column together (use Ctrl+click if they are not adjacent).
Go to Insert → Charts → Maps → Filled Map.
Excel renders a world or country view depending on the geographic scope of your data. Countries get a world view by default; states of one country get that country's map.
Right-click the map → Format Chart Area → Series Options to adjust: map area (only regions with data / only countries covered / world), map projection, and map labels (none / best fit / show all).

If the chart does not render and you see "We can't plot this data", jump to the Troubleshooting section — this error has five common causes.

Step 3: Make the Metric Readable

Default colour scales use two to three shades — fine for gradient values, bad for categorical values. Format choices that matter:

Colour scale direction. Right-click the series → Format Data Series → Series Colour. Use Sequential (2-colour) when higher = better; Diverging (3-colour) when there is a meaningful midpoint like 0 or a target.
Data labels. Right-click the map → Add Data Labels → pick Value or Category. Showing the numeric value on top of each region is what converts a pretty map into a readable one.
Legend position. Bottom or right works best. Corner legends often get clipped on smaller dashboard layouts.
Title. Replace the default "Chart Title" with something that states the insight, not the variable: "Revenue concentrated in North America — 68% of 2026 Q1 total" beats "Revenue by Country".

Worked Example: Regional Revenue Dashboard

A UK wholesaler ships to 23 countries. The Q1 revenue review pack needs to show where the revenue came from. Source data:

Country     Revenue (£)
United Kingdom       412,800
Germany              198,400
France               167,200
Netherlands           89,100
... 19 more rows ...

Workflow:

Convert to a Table (Ctrl+T) named tblCountryRevenue so future additions extend the chart automatically.
Select both columns → Insert → Maps → Filled Map.
Excel auto-renders a world view. Right-click → Format Chart Area → Series Options → Map area: Only regions with data — the Europe focus is now obvious instead of a tiny cluster on a full world map.
Add data labels showing Value, formatted as £#,##0.
Pair with a sorted bar chart on the same sheet showing the top 10 countries by revenue with exact numbers. The map answers "where"; the bar chart answers "how much".
Replace the chart title with the insight: "£412,800 (42%) of Q1 revenue from UK — Germany and France together add a further 37%."

This is the pattern that makes map charts earn their place: a map for the spatial story, a sorted bar chart for the numbers, and a title that states what the reader should take away.

3D Maps vs Map Chart vs Power Map

Three features with overlapping names, different purposes:

Feature	Insert path	Best for	Limitations
Map chart (filled map)	Insert → Charts → Maps	Static 2D map inside a worksheet for reports and dashboards. Country, state, postal-code level.	No time series, no city-level reliability, no custom regions.
3D Maps	Insert → 3D Map (or Tour)	Time-series geographic animation with 3D columns, heatmaps, and flight-path playback. Supports city/street level with coordinates.	Opens in a separate window; output is a video or tour, not an embedded chart. Only on Excel 365 Windows.
Power Map	(Retired)	Predecessor to 3D Maps.	Removed from Excel 2019+ menus. If a tutorial tells you to use Power Map, check the date — it is out of date.

Common Mistakes

Mixing geographic levels in one column. "Germany", "Bavaria", and "Munich" together will fail or silently misplace values. Split into Country / State / City.
Relying on the map alone for precise numbers. Always pair with a sorted bar chart or a ranked table for the exact values.
Using a world view when all data is in one country. Format Chart Area → Series Options → Map area: Only regions with data.
Ignoring ambiguous names. Always disambiguate Georgia, Washington, Victoria, and similar with a Country column or the Geography data type.
Picking a map when a bar chart would be clearer. Maps look impressive but hide rankings. For fewer than 10 regions, a bar chart wins.

Troubleshooting

"We can't plot this data." Most common causes, in order: (a) fewer than five rows — add more data or switch to a bar chart; (b) ambiguous location names — add a Country column next to State, or convert the column to Geography data type and pick the right entity; (c) mixed levels in one column — split Country and City into separate columns; (d) all values are text-typed numbers — select the value column → Data → Text to Columns → Finish to coerce to numbers; (e) no internet on first render — Bing Maps needs to resolve names the first time.
Some regions render, others are greyed out. The greyed regions did not match any name Bing Maps recognises. Cause is almost always spelling variants: "U.S.A." vs "USA" vs "United States of America". Select the column, Find & Replace variants to a single canonical form, then right-click the chart → Refresh.
Map shows the wrong country. A name collision. "Georgia" defaulted to the US state instead of the country (or vice versa). Fix: add a Country column with an explicit value, or convert to Geography data type and click the question-mark icon to pick the correct entity per cell.
Data labels overlap or get clipped. Right-click the data labels → Format Data Labels → uncheck "Show Leader Lines" and switch to "Best Fit" positioning. For small countries bunched together (Benelux, East Asian islands), data labels will always be cramped — move the detail into a paired bar chart instead.
Colour scale looks flat / all regions similar shade. One or two extreme outliers are compressing the rest of the scale. Right-click the series → Format Data Series → Series Colour → switch to Diverging (3-colour) with a manual midpoint set to the median, or cap the max value with an IF formula in a helper column. Another fix: split the data into two charts (e.g. top 3 by value, and everyone else).

Frequently Asked Questions

Why does Excel show "We can't plot this data" when I try a map chart?

The most common causes are ambiguous location names (Georgia country vs US state, Washington state vs DC), mixed geographic levels in one column (cities and countries together), fewer than five rows of data, or using city-level data on a chart type that works best at country or state level. Fix it by adding a disambiguating column (Country next to State), splitting into one geographic level per column, or converting the column to the Geography data type first via Data → Geography.

What geographic levels work in Excel map charts?

Country and state/province work reliably everywhere. County and region work in most countries. Postal code works for the US, UK, Canada, and a few others. City-level coverage is patchy and often fails. If you need street-level mapping, Excel map charts are not the right tool — use Power BI, 3D Maps, or a dedicated tool like Maptive.

Do I need the Geography data type for map charts?

No — Excel resolves plain text names automatically when you insert a map chart. But the Geography data type is worth using when names are ambiguous (it lets you explicitly pick "Georgia (United States)" vs "Georgia (country)") or when you want to pull extra attributes like population or area into the workbook.

When is a bar chart better than a map chart?

Whenever the reader needs precise ranking or exact comparison. Maps communicate "where" well but make it hard to tell whether France is 3% or 30% bigger than Germany. Use a map chart for geographic pattern, and pair it with a sorted bar chart for the precise numbers.

Is Power Map / 3D Maps the same as a map chart?

No — they are separate features. Map charts (Insert → Charts → Maps) are 2D filled maps for quick overview reports. 3D Maps (Insert → 3D Map) is a separate tour/animation tool for time-series geographic data with 3D columns and geocoding. Power Map was the old name for 3D Maps and has been retired from the menu since Excel 2019.