Statistical Analysis with Excel For Dummies, 5th Edition
Book image
Explore Book Buy On Amazon
Added as Power View to Excel 2013, 3D Maps is the current incarnation in Excel 2016. As its name implies, 3D Maps adds three-dimensional visualization. Here, you learn how to use 3D Maps to create a globe with data on numerous countries.

The image below shows part of a spreadsheet with data on life expectancy at birth, expected years of schooling, and mean years of schooling for 188 countries.

life expectancy
Life expectancy, expected years of schooling, and mean years of schooling for 188 countries.

As shown, 3D Maps has been used to create a three-dimensional globe that shows these countries and their associated statistics. The globe comes courtesy of Microsoft’s Bing search engine, so an active Internet connection is necessary.

To create the globe, follow these steps:

  1. Enter the data into a worksheet.
  2. Select the data, including the column headers.
  3. Click Insert | 3D Maps | Open 3D Maps. After a few seconds (be patient!), this page opens.

    9781119271154-fg0344

  4. Drag fields (column header names) to the Layer pane. Life Expectancy at Birth, Expected Years of Schooling, and Mean Years of Schooling was dragged into the Height box. You can see the data added to the globe, as stacked columns in the center of each country.

    9781119271154-fg0345

  5. Reveal the globe. Close the pane on the left and the pane on the right, leaving the globe pane open.
A stationary 3D globe wouldn’t be very useful, as many of the countries would be hidden from view. The onscreen controls (and judicious clicking) enable you to rotate the globe and expand or contract it. You can also change colors of the columns and reorient them.

globe
The finished globe.

3D Maps is not just for international mapping — you can create maps on a much smaller scale.

About This Article

This article is from the book:

About the book author:

Joseph Schmuller, PhD, is a research scholar at the University of North Florida. He is a former member of the American Statistical Association and has taught statistics at the undergraduate, honors undergraduate, and graduate levels.

This article can be found in the category: