Microsoft Excel 2019 Pivot Table Data Crunching

Chapter 11Analyzing geographic data with 3D Map

In this chapter, you will:

• Prepare data for 3D Map

• Build a column chart in 3D Map

• Explore 3D Map settings

• Animate data over time

Analyzing geographic data with 3D Map

3D Map allows you to build a pivot table on a three-dimensional globe of the Earth. Provided that your data has any geographic field such as Street, City, State, or Zip Code, you can plot the data on a map.

Once the data is on the map, you can fly through the data, zooming in to study a city or zooming back out to a 50,000-foot view. You can either use 3D Map to interactively study the data or build a tour from various scenes and render that tour as a video for distribution to people who do not have 3D Map.

Note

The 3D Map feature ...