Excel Chart Maps used with the Geography Data Type

Показать описание

I love the Geography Data Type in Excel. You can use it for countries, states, and cities. There are 45 fields available, including unemployment rate, population, birth rate, area, GDP, time zone(s), and largest city. I put the full list down below. One great trick is to 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.

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 Type in Excel - Full list of available Fields
---
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

#msexcel #chrismenardtraining #microsoftexcel

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!