excel-feature-image

How To Create A 3D Map In Excel 365

3D? Really? You can do that in Excel??? Why yes, you certainly can. It is a three-dimensional map that allows you to view your information in newer, more modern ways.

So why would you want to use this? Well, there is more than one answer to this question.  See some of them below:

  • Map data  You can plot more than a million rows of data visually on Microsoft Bing maps in 3D format from an Excel table
  • Discover insights  You will have a better understanding by viewing your data in geographic space and seeing time-stamped data change
  • Share  You will be able to capture screenshots and build cinematic, guided video tours you can share, wowing your audience. You can also  export tours to video and share them

Follow the steps below to learn how:

  1. First, you will find the 3D Map button in your Tours group, on the Insert tab of your Ribbon.
  2. In Excel, open a workbook that has the table or Data Model data you want to explore in 3D Maps.
  3. If you do not have data to use for this experiment, you can download sample data sets provided by Microsoft here, here, and here.
  4. Next,  click any cell in your table.
  5. Click Insert |  3D Map.
  6. When you initially click 3D Map, it will automatically enable 3D Maps.
  7. 3D Maps uses Bing to geocode your data based on its geographic properties in a minute or so, a globe will appear next to the first screen of the Layer pane.
  8. Now that you are in the Layer Pane, verify that your fields are correctly mapped, and then click the drop-down arrow of any incorrectly mapped fields to match them to the correct geographic properties.
  9. Once 3D Maps has plotted your data, dots will appear on the globe.

So, is this cool or what?

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top

WHY NOT SUBSCRIBE TO OUR NEWSLETTER?

Get great content like this delivered to your inbox!

It's free, convenient, and delivered right to your inbox! We do not spam and we will not share your address. Period!