How to Create a Map Chart in Excel: Data Prep and Fixes

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

A map chart in Excel is a filled map that colours countries, states, counties or postal codes by a value. To make one, prepare a column of consistent location names and a numeric column, select both, then choose Insert, Charts, Maps, Filled Map. Excel resolves names through Bing Maps, so ambiguous names such as Georgia need a Country column.

The Complete Excel Course with AI Integration

From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.

By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner

Buy now

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 a map chart that will not plot. For the cluster index of every Excel chart we cover, see the Excel formulas hub and the professional charts guide.

Map charts are a Microsoft 365 feature: Microsoft's support page (checked 21 November 2026) says they are available if you have a Microsoft 365 subscription, and lists Excel for Microsoft 365 on Windows and Mac plus the iPad, iPhone and Android apps. If you use a one-off purchase such as Excel 2019 or 2021, check for Insert > Charts > Maps in your copy before you plan a report around it. Map charts use Bing Maps to resolve place names, so creating a new map or adding data to an existing one needs an online connection; existing maps can be viewed offline. For detail a map chart cannot show, such as street addresses or latitude and longitude, Microsoft points to Excel's 3D Maps feature (formerly Power Map).

What do you need before making a map chart in Excel?

You need Excel for Microsoft 365, a column of place names, a numeric column and an internet connection while you create the map.

  • Excel for Microsoft 365. Microsoft's page says map charts need a Microsoft 365 subscription; on a one-off copy such as Excel 2019 or 2021, check for Insert > Charts > Maps first.
  • 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 while you create the map or add data to it, because Bing Maps resolves the names online. Existing maps can be viewed offline.
  • Locations above street level. Map charts plot only high-level geography, so latitude/longitude and street addresses are not supported; use 3D Maps for those.

When should you use a map chart in Excel?

Use a map chart when the geographic pattern is the story and you have ten or more locations. With fewer regions, or when readers need exact ranks, a sorted bar chart is usually clearer.

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: How do you prepare location data for a map chart?

Prepare location data by keeping one geographic level per column, standardising spellings and adding a Country column wherever a name could mean two different places.

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 for Microsoft 365, you can explicitly convert a location column to the Geography data type:

  1. Select the location column (headers and data).
  2. Go to Data → Data Types → Geography.
  3. 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)").
  4. 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: How do you insert a map chart in Excel?

To insert a map chart, select the location column and the value column together, then choose Insert, Charts, Maps, Filled Map.

  1. Select the location column and the value column together (use Ctrl+click if they are not adjacent).
  2. Go to Insert → Charts → Maps → Filled Map.
  3. 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.
  4. 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, or some locations stay blank, jump to the Troubleshooting section.

Step 3: How do you make a map chart readable?

Make a map chart readable by adding data labels, choosing a colour scale that fits your values and replacing the default title with the insight you want readers to take away.

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".

The Complete Excel Course with AI Integration

From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.

By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner

Buy now

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:

  1. Convert to a Table (Ctrl+T) named tblCountryRevenue so future additions extend the chart automatically.
  2. Select both columns → Insert → Maps → Filled Map.
  3. 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.
  4. Add data labels showing Value, formatted as £#,##0.
  5. 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".
  6. 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.

What is the difference between a map chart, 3D Maps and Power Map?

A map chart is a static 2D filled map, 3D Maps is a separate tour and animation tool, and Power Map is the retired earlier name for 3D Maps.

Three features with overlapping names, different purposes:

FeatureInsert pathBest forLimitations
Map chart (filled map)Insert → Charts → MapsStatic 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 MapsInsert → 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. Windows only: Excel for Microsoft 365 and Excel 2016 to 2024.
Power Map(Retired)Predecessor to 3D Maps.Renamed 3D Maps in Excel 2016. If a tutorial tells you to use Power Map, check the date — it is out of date.

If you want to build map charts and other Excel charts with an instructor, try The Complete Excel Course with AI Integration on Coding Liquids.

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

  1. The map chart will not plot your data. Common causes: (a) ambiguous location names — add a Country column next to State, or convert the column to Geography data type and pick the right entity; (b) mixed levels in one column, or several levels in one cell such as "Washington, United States" — put each level in its own column; (c) all values are text-typed numbers — select the value column → Data → Text to Columns → Finish to coerce to numbers; (d) no internet connection — creating a map chart needs Bing Maps to resolve the names.
  2. 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.
  3. 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.
  4. 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.
  5. 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).

The Complete Excel Course with AI Integration

From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.

By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner

Buy now

Frequently Asked Questions

Why won't Excel plot my data in a map chart?

A map chart fails when Excel cannot match your locations to map regions. The usual causes are ambiguous location names (Georgia country vs US state, Washington state vs DC), mixed geographic levels in one column or one cell, or no internet connection for Bing Maps. Fix it by adding a Country column, splitting levels into separate columns, or converting the column to the Geography data type first via Data > Geography.

What geographic levels work in Excel map charts?

Country and state or province work reliably everywhere. County and region work in most countries, and 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. The Geography data type is still worth using when names are ambiguous, because it lets you pick 'Georgia (United States)' or 'Georgia (country)' explicitly, 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?

A bar chart is better whenever the reader needs a 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 the 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 and animation tool for time-series geographic data with 3D columns and geocoding. Power Map was the old name for 3D Maps: Microsoft renamed it 3D Maps in Excel 2016.

How do I create a map chart in Excel?

Select a column of locations and a column of values, then choose Insert, Charts, Maps, Filled Map. Excel resolves the place names through Bing Maps and colours each region by its value. Keep one geographic level per column, standardise spellings, and add a Country column for ambiguous names such as Georgia or Washington before you insert the chart.

Related tutorials

Sources