How to Build a Map Chart in PowerPoint for Geographic Data

You need to show sales by state or customer locations on a slide. PowerPoint includes a built-in Map Chart feature that turns geographic data into a visual map. This article explains how to insert a map chart, enter your data, and customize the appearance. You will learn the exact steps to build a map chart that updates automatically when your source data changes.

What the PowerPoint Map Chart Feature Does and What You Need First

The Map Chart in PowerPoint converts a table of geographic names and numeric values into a color-coded map. Each region such as a country, state, or county appears filled with a shade that represents its data value. The feature uses Bing Maps to resolve location names, so an active internet connection is required when you first insert or refresh the chart.

Before you start, prepare your data in a simple two-column format. The first column must contain geographic names that Bing Maps can recognize. Use standard English names like “United States”, “California”, or “Ontario”. The second column must contain numeric values. PowerPoint supports up to six map chart types: Filled Map, Bubble Map, and several 3D variants. This guide covers the most common type, Filled Map, which shades each region based on value.

Steps to Insert and Configure a Map Chart in PowerPoint

1. Open a blank slide and go to Insert > Chart
   Click the slide where you want the map. On the ribbon, select Insert then Chart. The Insert Chart dialog opens.
2. Choose Map from the chart category list
   In the left pane of the Insert Chart dialog, click Map. The right pane shows two previews: Filled Map and Bubble Map. Select Filled Map and click OK. PowerPoint inserts a placeholder map and opens an Excel data sheet window.
3. Replace the sample data with your geographic names and values
   The data sheet contains sample rows for country names and values. Click cell A1 and type your first location name. Press Tab to move to cell B1 and type the numeric value. Continue filling rows. For example:
   Column A: “United States”, “Canada”, “Mexico”
   Column B: 100, 75, 50
   Close the data sheet window when finished. The map updates automatically.
4. Adjust the map projection and region if needed
   Right-click the map and select Format Plot Area. In the Format Plot Area pane, expand the Map Area section. Choose a projection like Mercator or Miller. Under Map Labels, select Show All to display region names on the map. Under Map Region, choose World or a specific continent to limit the visible area.
5. Change the color scheme for the data series
   Right-click any shaded region on the map and select Format Data Series. In the Series Options pane, expand the Series Color section. Choose a single color with a gradient from light to dark, or select a two-color gradient. For example, use light blue for low values and dark blue for high values. The map repaints instantly.
6. Add data labels to show values on each region
   Click the chart to select it. On the ribbon, click Chart Design then Add Chart Element. Point to Data Labels and choose More Data Label Options. In the Format Data Labels pane, check Value to display the number on each region. Check Series Name or Category Name if you want region names shown as well.

Using the Bubble Map Alternative

If your data has three dimensions such as location, value, and a second metric, use a Bubble Map instead. Repeat steps 1 and 2 but select Bubble Map. The data sheet requires three columns: location name, horizontal value, and bubble size value. Each region appears as a circle sized by the third column. This works well for population versus area data.

Common Mistakes and Limitations When Using Map Charts

PowerPoint does not recognize my location names

The most frequent problem is an unrecognized location. PowerPoint uses Bing Maps geocoding. If a name is misspelled, abbreviated, or in a foreign language, the map may show a blank region or an error. Use official English names from the United Nations or the U.S. Census Bureau. Avoid abbreviations like “CA” for California; write “California” instead. If the region still does not appear, open the data sheet, right-click the cell, and select Refresh to re-geocode.

The map chart does not update when I change data

The map chart links to an internal data sheet that is separate from any external Excel file. If you edit the data sheet after closing it, right-click the chart and select Edit Data. Make your changes in the data sheet that reopens. The chart updates immediately. If you linked the chart to an external Excel workbook, the chart refreshes only when you open the workbook and click Refresh Data on the Chart Design tab.

Only one country appears on the map

This happens when all your location names belong to a single country and the map region is set to World. To show only that country, right-click the chart, select Format Plot Area, expand Map Area, and change Map Region to the specific country name. For example, if all data points are U.S. states, set Map Region to United States. The map zooms in to show only states.

The map colors are not visible or regions look gray

Gray regions indicate missing or zero values. Verify that every location in column A has a corresponding number in column B. If a region intentionally has a zero value, format the data series color to include a distinct color for zero by adjusting the gradient stops. Also ensure the chart type is Filled Map, not Bubble Map, which uses circles instead of shaded areas.

Item	Filled Map	Bubble Map
Data columns required	Two: location name and numeric value	Three: location name, horizontal value, and bubble size
Visual representation	Each region shaded by value	Each region shown as a circle sized by value
Best for	Comparing values across regions with a single metric	Showing two metrics per region, such as revenue and profit
Region labeling	Data labels show value per region	Data labels show bubble size value

You can now build a map chart in PowerPoint that displays geographic data clearly. Start by preparing a two-column list of location names and values. Use the Filled Map type for standard region shading or Bubble Map for dual-metric data. After inserting the chart, refine the color range and projection in the Format Plot Area pane. To keep your map current, edit the internal data sheet directly instead of relinking to an external file. For presentations with many locations, consider sorting your data alphabetically by region name before inserting the chart to avoid missing regions.