From the course: Excel: Charts and Graphs 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 - Microsoft Excel Tutorial

From the course: Excel: Charts and Graphs In Depth

Start my 1-month free trial Buy for my team

Map charts based on geographic data

“

- [Instructor] So, let's say you have some geographic data and you want to present it visually on a map. Excel does have maps built in like the one right here, so let's go ahead and rebuild this map ourselves. I'm going to highlight A1 through A11, D1 through D11. I'm going to go to Insert, I'm going to click on this Maps dropdown into a filled map like that. So, what you'll find is that these maps are fairly limited. They do work in a pinch, but there's also another tool that you can use that actually lets you look at the entire globe, and that's called the 3D map, so let's go ahead and take a look at that one. What I'm going to do is I'm going to highlight A1 through D11, so I want to bring all of this source data into our 3D map, even if we don't use it. I'm going to click on the 3D map icon right here that's inside the Insert ribbon tab. Now, if it's your first time using a 3D map, you may get a popup that says, "Would…

Contents