From the course: Excel: Charts in Depth

Unlock the full course today

Join today to access over 24,200 courses taught by industry experts.

Map charts based on geographic data

Map charts based on geographic data

From the course: Excel: Charts in Depth

Start my 1-month free trial Buy for my team

Map charts based on geographic data

“

- [Instructor] On this worksheet called Geographic Map, we're seeing different clusters of data that include either states or cities or countries. From time to time, you might want to include this kind of data with an actual geographic map. So selecting the data over in columns A and B, for each of the states and the relative populations in millions, let's go to the Insert tab and although found in the Charts area, we see Maps just to the right of those other icons. Maps, there's the icon. Immediately we see the states here. Now, the numbers are reflective. Now, I might be making an adjustment over here, maybe Pennsylvania's really 13 million, so I double click. Temporarily here I'll mistype this, instead of 13, maybe I put in 31, and as I press Enter, keep an eye on Pennsylvania on the map. It'll be a darker blue. And you saw what happened. So the magnitude of the numbers is being reflected in the shading that we…

Contents