Excel Chart Maps used with the Geography Data Type
Posted on: 11/13/2022
Combine the Geography Data type with a Chart Map. The Geography Data type is located on the Data tab, and Chart Map is on the Insert tab with the other chart types.

Geography Data Type in Excel
You can use the Geography data type with countries, states, and cities. There are 45 fields available, including unemployment rate, population, birth rate, area, GDP, time zone(s), and largest city.
How to use the Geography data type in Excel
-
Type a range of Countries, States, or Cities.
-
Select the range and convert it to a table using CTRL + T or click the Insert tab, and then click Table. This step isn't required but is recommended.
-
Select the range but not the header row.
-
Click the Data tab.
-
Click Geography in the data type group.
-
Use the Insert data icon to add fields to the worksheet.

Geography Data Type in Excel - Insert icon for fields
YouTube video
Video Chapters
-
0:00 Intro
-
0:14 Create a Table
-
0:40 Geography data type for Countries
-
1:22 Chart Map
-
2:15 Geography data type for States
Geography Data Types - full list
-
Abbreviation
-
Agricultural land (%)
-
Area
-
Armed forces size
-
Birth rate
-
Calling code
-
Capital/Major City
-
Carbon dioxide emissions CPI
-
CPI Change (%)
-
Currency code
-
Electric power consumption
-
Fertility rate
-
Forested area (%)
-
Fossil fuel energy consumption
-
Gasoline price
-
GDP
-
Gross primary education enrollment (%)
-
Gross tertiary education enrollment (%)
-
Image
-
Infant mortality
-
Largest city
-
Leader(s)
-
Life expectancy
-
Market cap of listed companies
-
Maternal mortality ratio
-
Minimum wage
-
Name
-
National anthem
-
Official language
-
Official name
-
Out of pocket health expenditure (%)
-
Physicians per thousand
-
Population
-
Population: Income share fourth 20%
-
Population: Income share highest 10%
-
Population: Income share highest 20%
-
Population: Income share lowest 10%
-
Population: Income share lowest 20%
-
Population: Income share second 20%
-
Subdivisions
-
Tax revenue (%)
-
Time zone(s)
-
Total tax rate
-
Unemployment rate
-
Urban population
Chris Menard's Online Teams Training Course
Over 2.5 hours of Teams training. Click here to sign up for the course.

Teams online training with Chris Menard
How to insert a chart map in Excel
-
Click the Insert tab
-
Click Maps and then click Chart map

Insert a Chart Map in Excel

Map Chart in Excel of Countries

Map Chart in Excel of States
Recent Articles
Speed Up Data Entry and Accuracy with Excel Data Validation Lists
In today's fast-paced work environment, efficiency and accuracy in data entry can significantly impact productivity. One of the best tools to achieve this in Excel is the Data Validation List feature. This guide will walk you through the process of setting up and using Data Validation Lists to streamline your data entry tasks in Microsoft Excel.
How to Remove Duplicates Running Left to Right in Excel Using Power Query
Removing duplicates in Excel is a common task, but it can be challenging when the duplicates are running horizontally (left to right) instead of vertically. In this blog post, we'll explore an advanced Excel technique using Power Query to efficiently remove duplicates across rows. This method is particularly useful when dealing with complex data structures where traditional duplicate removal methods fall short.
4 Great NEW Microsoft Teams Features: November & December 2024
Microsoft has been extremely busy with new Teams features in November and December 2024. Here is a quick overview of What's New - Name Pronunciation, New Chat and Channels Experience, Improved People Search, and the Refreshed View for Teams and Channels.
Microsoft Word to Adobe Acrobat with Bookmarks
We don't usually want to email, or share are Word files. Frequently, we make our Word documents PDF files. If you lay out your Word document correctly, it is easy to make bookmarks in the PDF.
Chris Menard
Chris Menard is a Microsoft Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. Chris runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Copilot, Google Calendar, and Outlook. To date, the channel has helped over 20 million viewers.
Menard also does 2 to 3 public speaking events yearly, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the University of Georgia, and CPA conferences. You can connect with him on LinkedIn at https://chrismenardtraining.com/linkedin or watch his videos on YouTube at https://chrismenardtraining.com/youtube.
Categories