Excel Chart Maps used with the Geography Data Type

Posted on:  11/13/2022
Excel Chart Maps used with the Geography Data Type

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

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

  1. Type a range of Countries, States, or Cities.
  2. 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.
  3. Select the range but not the header row.
  4. Click the Data tab.
  5. Click Geography in the data type group.
  6. Use the Insert data icon to add fields to the worksheet.
Geography Data Type in Excel - Insert icon for fields

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

  1. Abbreviation
  2. Agricultural land (%)
  3. Area
  4. Armed forces size
  5. Birth rate
  6. Calling code
  7. Capital/Major City
  8. Carbon dioxide emissions CPI
  9. CPI Change (%)
  10. Currency code
  11. Electric power consumption
  12. Fertility rate
  13. Forested area (%)
  14. Fossil fuel energy consumption
  15. Gasoline price
  16. GDP
  17. Gross primary education enrollment (%)
  18. Gross tertiary education enrollment (%)
  19. Image
  20. Infant mortality
  21. Largest city
  22. Leader(s)
  23. Life expectancy
  24. Market cap of listed companies
  25. Maternal mortality ratio
  26. Minimum wage
  27. Name
  28. National anthem
  29. Official language
  30. Official name
  31. Out of pocket health expenditure (%)
  32. Physicians per thousand
  33. Population
  34. Population: Income share fourth 20%
  35. Population: Income share highest 10%
  36. Population: Income share highest 20%
  37. Population: Income share lowest 10%
  38. Population: Income share lowest 20%
  39. Population: Income share second 20%
  40. Subdivisions
  41. Tax revenue (%)
  42. Time zone(s)
  43. Total tax rate
  44. Unemployment rate
  45. 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

Teams online training with Chris Menard

How to insert a chart map in Excel

  1. Click the Insert tab
  2. Click Maps and then click Chart map
Insert a Chart Map in Excel

Insert a Chart Map in Excel

Map Charts in Excel

Map Chart in Excel of Countries

Map Chart in Excel of States

Map Chart in Excel of States

Recent Articles

Removing Duplicates Using Power Query

Removing Duplicates Using Power Query

The 4 Percent Rule: Using Microsoft Excel to Plan for Retirement

The 4 Percent Rule: Using Microsoft Excel to Plan for Retirement

Teams Calls vs. Meetings: What is the Difference?

Teams Calls vs. Meetings: What is the Difference?

Teams Meetings - Move Presenter Toolbar When Sharing

Teams Meetings - Move Presenter Toolbar When Sharing

Microsoft Word to Adobe Acrobat with Bookmarks

Microsoft Word to Adobe Acrobat with Bookmarks

Dictate Feature Updates in Word, Outlook, PowerPoint, and OneNote

Dictate Feature Updates in Word, Outlook, PowerPoint, and OneNote

Chris Menard

Chris Menard is a certified Microsoft Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. He runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Google Calendar, and Outlook. To date, the channel has helped over 20 million viewers. Menard also does 2 to 3 public speaking events every year, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the Support Staff 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