Note: Power Map, our popular 3-D geospatial visualization add-in for Excel 2013, is now fully integrated into Excel. We’ve also given this feature a more descriptive name, “3D Maps'.
Aug 10, 2015 - Charts are a great way to visualize numbers. We show you how to create charts in Microsoft Excel and when to best use what kind. Microsoft 3D Maps for Excel is a three-dimensional (3-D) data visualization tool that lets you look at information in new ways. 3D Maps lets you discover insights you might not see in traditional two-dimensional (2-D) tables and charts.
![For For](/uploads/1/2/5/4/125447377/670837807.jpg)
![Excel Excel](/uploads/1/2/5/4/125447377/487386048.jpg)
You'll find this functionality alongside other visualization features on the Insert tab. Microsoft 3D Maps for Excel is a three-dimensional (3-D) data visualization tool that lets you look at information in new ways. 3D Maps lets you discover insights you might not see in traditional two-dimensional (2-D) tables and charts. With 3D Maps, you can plot geographic and temporal data on a 3-D globe or custom map, show it over time, and create visual tours you can share with other people.
You’ll want to use 3D Maps to:. Map data Plot more than a million rows of data visually on Bing maps in 3-D format from an Excel table or Data Model in Excel. Discover insights Gain new understandings by viewing your data in geographic space and seeing time-stamped data change over time. Share stories Capture screenshots and build cinematic, guided video tours you can share broadly, engaging audiences like never before. Or export tours to video and share them that way as well.
You’ll find the 3D Map button in the Tours group, on the Insert tab of the Excel ribbon, as shown in this picture. Create your first 3D Map When you have Excel data that has geographic properties in table format or in a —for example, rows and columns that have names of cities, states, counties, zip codes, countries/regions, or longitudes and latitudes—you’re ready to get started. Here’s how:. In Excel, open a workbook that has the table or Data Model data you want to explore in 3D Maps. For information about using your own data, see. If you don’t have data to explore yet, try downloading. Click any cell in the table.
Click Insert 3D Map. (Clicking 3D Map for the first time automatically enables 3D Maps.) 3D Maps uses Bing to geocode your data based on its geographic properties. After a few seconds, the globe will appear next to the first screen of the Layer Pane. In the Layer Pane, verify that fields are mapped correctly and click the drop-down arrow of any incorrectly mapped fields to match them to the right geographic properties. For example, make sure that Seattle is recognized as a City in the drop-down box.
When 3D Maps plots the data, dots appear on the globe. Explore sample datasets in 3D Maps Our sample datasets are a great way to try out 3D Maps. Just download one of the following workbooks that already have the necessary geo-spatial entries you need to get started:. Next steps for working with your data in 3D Maps.
Microsoft Excel charts include legends by default. You can delete the legend or change the settings so that it isn't inserted when the chart is created, but doing so can make the chart difficult for others to read, especially if it contains many data points. If you decide that you need a legend after all, you can manually add one to your Excel chart. The Mac version of Excel has the same options for creating and editing a legend as the Windows version does, but the process for adding the legend is different.