From the course: Excel Statistics Essential Training: 2 (2019)

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Using 3D maps

Using 3D maps

From the course: Excel Statistics Essential Training: 2 (2019)

Start my 1-month free trial

Using 3D maps

- [Instructor] Now I'll show you another cool graphics feature. It's called 3D Maps, and you use it when you want to visualize data that has a geographic component. You can visualize your data on a three-dimensional globe that you can spin on-screen, and it's a real showstopper. Here's what I mean. I threw together a fun little data set for you. The data are real. In column A, I put the number for each row, more about that later. What we're about to do only works if you have a live internet connection. That's because the Bing search engine is part of the map-making process. Column B holds the names of the 50 United States. Column C has each state's proportion of high school graduates. Column D has the proportion of bachelor's degrees among people in that state. Column E holds the proportion with advanced degrees. Column F has the number of UFOs, unidentified flying objects, reported in each state. Columns G through J hold the ranks for all the data points in columns C through F, and…

Contents