From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Create map-type charts based on geographical locations

Create map-type charts based on geographical locations - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Create map-type charts based on geographical locations

“

- [Instructor] On this worksheet, 2 we're seeing various clusters of state abbreviations, 3 state names, city names, country names, continent names, 4 accompanied by some numbers. 5 We can depict this information in a somewhat limited way 6 with a new feature available 7 on the Insert tab in the ribbon. 8 It's in the charts group. 9 It's separated from the others. 10 It's called Maps. 11 "Use this chart type to compare values 12 and show categories across geographical regions." 13 Let's highlight the data for the states here 14 over in column B and C. 15 Our 10 largest states with population in millions, rounded. 16 Maps. 17 And here's the icon. We'll simply click it. 18 We've got a map. 19 I'm going to slide this over next to the data. 20 What you'll probably notice almost immediately 21 is California is darker than the others. 22 That's because it has more people. 23 And the lightness and the darkness of the…

Contents