The first time I needed to present regional sales data to a leadership team, I didn’t want another boring table of country names and numbers. I wanted them to see, at a glance, where the business was strong and where it was struggling. That’s exactly what pushed me to try Excel’s built-in Map Chart feature, and honestly, it’s one of the most underused tools in Excel. In this guide, I’ll show you exactly how I build one, from raw data to a finished, presentation-ready map.
What Is a Map Chart?
A map chart is a geographic visualization that shades regions — countries, states, provinces, or counties — based on a numeric value. Instead of listing “USA: 500,000, Canada: 200,000, Mexico: 150,000” in a table, a map chart colors each country in shades of a single color, darker for higher values and lighter for lower ones. It turns geographic data into something instantly readable.
Excel uses Bing Maps services behind the scenes to recognize location names, so it requires an internet connection to generate and render properly.
When Should You Use a Map Chart?
I use map charts when:
- My data is naturally tied to geography — countries, states, regions, postal codes
- I want to show regional trends, like sales performance or population density
- The audience is non-technical and benefits from a visual rather than a table
- I’m comparing a metric across many locations at once
If your data only involves two or three locations, a simple bar chart usually communicates the comparison more precisely than a map.
Required Data Structure
You need two columns: one with recognizable geographic names, and one with the numeric value you want to visualize. Here’s an example:
| Country | Sales |
|---|---|
| United States | 520000 |
| Canada | 210000 |
| Mexico | 180000 |
| Germany | 340000 |
| France | 295000 |
A few tips from experience: use full, standard location names rather than abbreviations (write “United States,” not “US” or “USA,” and Excel will usually still recognize it, but full names are safer). If you’re mapping U.S. states, list them by name or standard two-letter abbreviation, and Excel will handle the recognition.
Step-by-Step Instructions
Here’s my process every time:
- Enter your geographic data in one column and your numeric values in the adjacent column.
- Select both columns, including headers.
- Go to the Insert tab.
- In the Charts group, click Maps, then choose Filled Map.
- Excel connects to its geographic data service and generates the map, shading each region according to your values.
- Click the chart to access the Chart Design and Format tabs for further customization.
Formatting and Settings I Adjust
Once the base map appears, here’s what I typically fine-tune:
- Color scheme: Right-click the map and choose Format Data Series > Series Color to switch between a two-color or three-color gradient scale.
- Map labels: Under Format Data Series > Map Labels, you can choose to show region names directly on the map.
- Map projection and area: Excel sometimes zooms to a default region — under Format Data Series > Map Area, you can set it to zoom only to the data region, or expand to show the whole world for context.
- Legend: I always keep the legend visible so viewers understand what the color gradient represents; you can reposition it under Chart Design > Add Chart Element > Legend.
A Practical Example
Say I’m reporting quarterly sales across ten European countries. Once plotted, Germany and France appear in a deep shade because they have the highest sales, while smaller markets like Slovakia or Estonia appear much lighter. A leadership team scanning this map can instantly identify which markets to invest more in, without reading a single number — the color does the storytelling.
Common Mistakes to Avoid
Lessons I’ve learned the hard way:
- Ambiguous location names: A city name like “Georgia” can be interpreted as either the U.S. state or the country. Be specific, or add a country column for disambiguation.
- Mixing geography levels: Don’t combine countries and states in the same data column — Excel needs a consistent geographic level to map correctly.
- No internet connection: Since map charts pull from an online service, they won’t generate (or will fail to refresh) without connectivity.
- Overly granular data: Mapping every single city in a dataset can produce a cluttered, unreadable chart. Aggregate to state or country level when possible.
Troubleshooting Tips
If your map chart isn’t behaving:
- “Maps” option is greyed out: You need Excel 2016 or later with an active internet connection, and Bing Maps services must not be blocked by your organization’s firewall.
- Some regions aren’t recognized: Excel will flag unrecognized locations — check spelling, remove abbreviations, or add a Region/Country column to help it disambiguate.
- Map not updating after data changes: Right-click the chart and select Refresh Data, or try closing and reopening the workbook if the map seems stuck.
- Colors too similar to distinguish: Increase contrast by switching to a diverging three-color scale instead of a single-color gradient.
Real-World Use Cases
I’ve personally used map charts for:
- Visualizing regional election or survey results
- Presenting global sales performance by country to an executive team
- Showing state-by-state customer distribution for a US-based retailer
- Mapping disease case counts by region for a public health report
Each time, the map chart did the heavy lifting of communicating “where” in a way a spreadsheet full of location names simply couldn’t.
Best Practices
Before finalizing a map chart, I always double-check:
- Location names are spelled correctly and consistently
- The color scale actually reflects meaningful differences (avoid using a gradient so subtle it hides variation)
- The legend is visible and clearly labeled with units (dollars, percentages, counts)
- The map is zoomed appropriately to the data’s geographic scope — don’t show the whole world if your data only covers five U.S. states
- Consider pairing the map with a small supporting table for viewers who want exact figures
Map charts are one of the fastest ways to turn location-based data into an intuitive, visual story. Once you’ve got clean geographic names and a numeric value to plot, Excel does the rest — and the result looks far more polished than most people expect from a native Excel feature.
