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 are 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 understandings 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:
- First, you will find the 3D Map button in your Tours group, on the Insert tab of your Ribbon.
- In Excel, open a workbook that has the table or Data Model data you want to explore in 3D Maps.
- If you do not have data to use for this experiment, you can download a sample data sets provided by Microsoft here, here, or here.
- Next, click any cell in your table.
- Click Insert | 3D Map.
- When you click 3D Map initially, it will automatically enable 3D Maps.)
- 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.
- 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 right geographic properties.
- Once 3D Maps has plotted your data, dots will appear on the globe.
So, is this cool or what?