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.
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.
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.
How to insert a chart map in Excel
-
Click the Insert tab
-
Click Maps and then click Chart map
Recent Articles
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