• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Map Chart in Excel

August 24, 2021 by Andrew Childress
Add map charts in Excel

Often, spreadsheets will include geographic data. It might be useful to display this data in map form. Here's how to add a map chart in Microsoft Excel.

Often, spreadsheets will include geographic data. For example, you might find yourself working with a list of states and response rates for a survey. It might be useful to display this data in map form. Fortunately, Excel makes that easy. Let’s learn how to add a map chart in Microsoft Excel.

How to Add a Map Chart in Excel

Map charts are great ways to illustrate your data and how it fits into the global landscape. Excel has a newer feature to help you do exactly that.

To get started with map charts in Excel, begin by inputting your data into a pair of columns. Column A should list your states, while column B contains the response ratios, formatted as percentages. Once you have the data typed in, click and drag to select the range of cells that contain it. Here, that’s A1:B5.

Map chart in Excel

Then, go to the Insert tab on Excel’s ribbon. Near the middle, you’ll see the Charts section. Here, there are many options for visual graphics that you can add to your spreadsheet.

Since you’re looking for a geographic option, click on the Maps dropdown. It will open, and you’ll see a single selection: Filled Map, which displays as a globe thumbnail.

Map charts in Excel

Click on this, and you’ll see a map chart appear on your Excel sheet.

Based on the percentages, the individual states are shaded in different colors, represented by the legend on the right side. You can also add custom elements like a chart title and other designs, found on the Chart Design tab on Excel’s ribbon.

Add map charts in Excel

As you can see, map charts are easy to add in Excel. These sleek custom designs bring geographic data to life in new and unique ways. All you have to do is input map-related data in rows and columns, and let Excel’s chart features do the work.

Category: Excel FunctionsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Add hierarchy chart in ExcelHierarchy Chart in Excel
Next Post:Add Icons in ExcelAdd icons in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top