3D Maps in Excel 2016

In this HowTech tutorial, we’re going to show you how to create 3D maps in Excel 2016.

To get started, go under the Insert tab and click the 3D Map button.

Since this is a template, there is already a 3D map available. Click New Tour to create a new 3D Map.

3D Maps in Excel 2016

A field list will pop up, drag the corresponding data columns into the fields to the right. For example, I drag the Capacity (Megawatts) to the Height field. The blue rectangular prisms plotted on the globe differ in height based on their capacity now.

3D Maps in Excel 2016

The globe should update as you add fields.

3D Maps in Excel 2016

Here is how the example looks completed.

3D Maps in Excel 2016

Play around with the options and explore to get the 3D map you’re looking for.

3D Maps in Excel 2016

There are also animations and other options under Scene Options.

3D Maps in Excel 2016

To play the animation, hit the Play button under the corresponding scene.

3D Maps in Excel 2016

Since the example I use has a timeline of different dates, you can scroll through them using the interface highlighted at the bottom.

3D Maps in Excel 2016

To change many of the specifics of the plotted “points”, see the controls under Layer Options.

3D Maps in Excel 2016

To create a new scene in the Tour, click New Scene or the drop-down. You can even create a custom map.

3D Maps in Excel 2016

With the custom map, you can use your own custom background image.

3D Maps in Excel 2016

This was a HowTech tutorial.

3D Maps in Excel 2016