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
Excel - IF Function using AND and OR
One of my favorite functions is the IF function. The IF function allows you to use true and false conditions. For example, if the value in cell B2 is over $5,000, give them a 2% discount.
Microsoft Teams - Create and Customize Avatars
Microsoft Teams is rolling out mesh (3D) Avatars. You can customize your avatar. Avatars are not static. When testing, my avatar reacted to audio and moved from time to time to provide some visual interest.
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 Certified Trainer (MCT) and is employed full-time as a Trainer for BakerHostetler, one of the nation’s largest law firms. Menard has a YouTube channel with over 900 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 16 million viewers have appreciated. Menard also does public speaking at conferences for CPAs and Administrative Professionals. Connect with Chris on LinkedIn at chrismenardtraining.com/linked or on YouTube at chrismenardtraining.com/youtube
Categories