What email address or phone number would you like to use to sign in to Docs.com?
If you already have an account that you use with Office or other Microsoft services, enter it here.
Or sign in with:
Signing in allows you to download and like content, and it provides the authors analytical data about your interactions with their content.
Embed code for: Getting Started with 3D Maps for Excel
Select a size
This is a tutorial on Excel's 3D Maps.
Getting Started with 3D Maps for Excel
Creating your first tour using the Food Inspection sample 2
Geocoding your data 5
Changing the geography level using the Location well 6
Navigating the 3D space 7
Adding Data 7
Adding a category 10
Using Data Cards 12
Using scenes 16
Using different layers of data 20
3D Maps for Excel (formerly Power Map for Excel) is a feature or Excel which ships with Office 365 and Office 16. It is a visual tool which lets you visualize your data in a three dimensional (3D) interactive environment. You can visualize data on top of Bing maps or you can create a custom map by importing an image and defining your own coordinate system. 3D Maps will automatically geocode your data for you and will allow you to animate it over time. You may discover insights by visualizing your data this way which you might not see in traditional two-dimensional (2D) charts and maps.
With 3D Maps you can:
Map data – plot millions of rows of data on top of Bing maps or a custom map
Discover insights – gain new understanding about your time-stamped data in geographic space as it changes over time.
Share stories – create cinematic, guided and interactive tours of your data. You can share the file or you can export the tours as a video and then post them on the web.
You will find the 3D Maps button in the Tours group of the Insert tab of the Excel ribbon.
If you can’t find this button, make sure you have Office 2016 or a subscription to Office 365
To learn more about Office 365 go to
If you previously installed a preview version of Power Map, you should uninstall it.
Creating your first tour using the Food Inspection sample
When you visualize data in 3D Maps, it is organized in a collection of scenes called a ‘tour.’ A new tour and a single scene are automatically created when you create your first 3D Map. You can make many tours inside a single workbook which can tell different stories about your data. The tours are just saved as part of the workbook. Each tour can have multiple scenes and each scene tells a different part of the story. In each scene you can have multiple layers of data which you can visualize and customize in different ways and then animate them over time.
You can use 3D Maps if your data contains geographic properties – such as names of cities and states, names of countries or zip codes and so on.
You can also use 3D Maps if your data has a custom coordinate system which you can design or else obtain from using RFID. We will give more examples like this in a minute.
The more detailed the address or geographic info you have, the better the precision in plotting your data will be. For example, if you give just the names of cities not all data will be plotted since a lot of cities share the same name. Generally, it is best to add all of the geography fields to the Location well and then decide which one to use to visualize data.
In this first example we will use some Food Safety violation data that we have for the city of Seattle.
You can find this sample and many more sample files here
http://bit.ly/mspowermapsampleshttp://bit.ly/mspowermapsamples . This is public data so you can feel free to use this data and practice.
This is what the data in the file looks like:
The name of the business is the in the first column, there is a column for when the inspection happened and a column for the name of the city in which the business is in and also a column with the postal code for the business address that was inspected. There is also date for when the inspection happened and this makes this data perfect for exploring in 3D maps.
To start working with 3D Maps go to the Insert tab and click on the 3D Maps button which next to the Charts group.
When 3D Maps open, you will see your data already on the map and the rest of the UI in 3D Maps which will allow you to visualize and explore your data further.
The 3D Maps UI has three 5 main parts – the ribbon, the Scene task pane which is on the left in this picture and the layers task pane which is on the right, and the 3D space which is in the middle. The task panes and the Field List dialog can be displayed or hidden using the ribbon buttons in the View group.
You can read more on Scenes and Layers below.
In this case the data is geocoded, and 3D Maps automatically selects the most precise option to plot the data – Latitude and Longitude. You can see that in the location well
In the 3D space the locations for which there are data are indicated with a blue ziggurat.
Geocoding your data
If your data is not geocoded 3D Maps will do that for you. For example if you have just the addresses of the businesses and the names of the cities and states in which they are in, 3D Maps will send these off to Bing and then they will get geocoded which works automatically, there are no additional steps. If you have the data that looks like something like this:
@ The PEAK
1913 N 45TH ST
5TH AVENUE PRODUCER CLUB
1312 5TH AVE
663 S WELLER ST
3D Maps will geocode it automatically as soon as you click inside the range or table and click on 3D Map button, like so.
You can add multiple tables or ranges to 3D Maps, by simply clicking on the range and then click on the Add data to 3D Maps
Changing the geography level using the Location well
You can change the geography level at which your data is aggregated here. For example, if you click on city, you will see only a few ziggurats which indicate where you have data.
Navigating the 3D space
You can zoom using the wheel of your mouse and pan by clicking on the map and moving the mouse. If you press and hold the Alt key and then click and move your mouse you can change the tilt of the 3D environment and adjust the angle at which you are viewing the data.
Let’s go back to using the address of each business and then work on adding some data.
This will split and show data for each address which is in the data. You can see that in the 3D space.
You can add data to the visualization in two ways, by dragging from the Field list or by using the drop down control in the wells. To use the Field list, click on the field list button in the Power Map ribbon.
Then click on the field ‘Validation Points’ and drag it to the Height well.
In addition to dragging a field from the Field List to a well, you can use the drop down control + Add Field which is present in all wells.
These two different methods are available as a choice to you. They do the same thing – add fields to a well. You can do so by dragging any of the fields from the Field List to any of the wells or you can target a specific well with the + Add Field control which is hosted inside it.
Once you add the field Violation Points you will see the data in the 3D space and you can start exploring it.
Adding a category
Once you add a field to Height you can see further insights by adding a field to category. For example, to answer the question - what types of violations were encountered in the different addresses, then just add the field Violation Description to the Category well.
This visualization now allows you to explore the pattern in each location.
Using Data Cards
Hovering over a specific data point will display the data card which you can use to get more details about what is happening at this specific location. For example, you can customize the card by clicking on the little gear icon in the top which will display the Custom Cards dialog.
Here, you can add any field which you want to appear on the card, even if it is not used in the wells. Here is a customized version of the same Data Card where latitude and longitude have been removed and the business name and address have been added.
In many cases filtering the outliers out can give a more holistic and easier-to-understand view of the data. In this example there is lots of data in a couple of locations which happen to house many restaurants. When these two locations are filtered out the relative scale changes.
To add a filter, expand the Filters section
And click on the + Add Filters control
You can pick the desired filed here. In this case, because we customized the data card we can find out the name of the business which has the big number of inspections and filter that out.
Add the Inspection Business Name field
To remove a single location, first check the top box that says ‘All’
This will select all locations in the range. Then search for ‘Century Link’ by typing in the search box and then uncheck the box next to it.
This removes the location. You can do the same for other locations with a lot of data and you will get a more normalized view of the data.
While you are exploring your data using filters and data cards you will gather insights about it and then build a story with it that has logical parts. 3D Maps allow you to make a story with multiple parts in it which is called a ‘tour’. A tour is made of multiple scenes and the transitions between each one is handled automatically. At the very basic level you can make three scenes about the food safety data – one that shows all of the data that is in the sample, another one which shows just data in Seattle and a third one which shows data in another city, like Bellevue.
You can make multiple scenes by clicking the New Scene Button on the ribbon.
You can zoom out to make the first scene show all data is in Seattle and you want the second one to be in Bellevue, simply navigate to Bellevue in the second scene.
3D Maps will handle the movement of the camera from one scene to the next, even if you move all over the globe.
You can move a scene by dragging the thumbnails in the Tour task pane which is on the left.
You can add an effect in each scene. An effect is an automated motion which moves the camera within the scene. This is often desirable since changing the perspective and view angle will give the viewer a better understanding of what is happening in the data and will make your visual story feel more natural. Much like in the movies, when the camera moves, the film feels more natural. You just need to pick which effect you want to use and then you can preview it.
To choose an effect for the scene, click on scene settings icon which is displayed when you hover over the scene thumbnail.
Here you can specify a name for your scene so you can quickly refer to it and change its duration. Click on the dropdown to select the effect and then preview using the play button which is also displayed on the thumbnail.
Here is what the effects will do:
Circle will move in a circular motion around a center point in your data. This point is determined based on the angle at which you have positioned the scene.
Dolly will move in a straight line parallel to the point in the surface at which you have positioned the scene. Think of it as if you have a camera dolly and you are moving along the scene in parallel
Figure 8 will move in an ‘8’ pattern but stay roughly in the same spot
Fly over will move above and past the point in which you position the scene
Push in will move towards the point of scene positioning
Rotate globe will rotate the globe or move in a back and forth motion over a flat map.
Transitions is what happens between each scene. You can set the transition duration and this will determine the speed by which the camera moves from one position and to the other. If your scenes are close to each other geographically you likely do not need long times for transition. If you however are moving from Chicago to Tokyo then you may want to add more time to allow for adaptation. The transition duration can be accessed in Scene Options.
By using different themes you can change the look and feel of your tour. You can use ‘street maps’ style on your globe or you can use satellite images as well.
Above are two screenshots of the same data taken with different themes. You can change themes in each scene and you can do so by accessing the themes in the ribbon.
Using different layers of data and animating over time
It is sometimes very useful to use two or more layers of data and explore it visually. This is especially useful when practicing with the Dallas utilities demo file which is hosted here –
In this example we will create two layers of data. One will show the size and the decade in which different houses were built and the other layer of data will animate over time and show what the seasonal consumption of electricity. We will explore whether houses of similar size and which were built in the same decade use the same amount of electricity and whether newer houses use less electricity.
To create two layers follow these steps.
Open the Dallas Utilities sample dataset
Click anywhere on the sheet
Add SquareFeet to height
Add DecadeBuilt to Category
This is your first layer. It shows all buildings and the height of the columns shows how big each building is. The really tall ones are likely condos
To create the second layer click on the ‘Add Layer’ button.
Then add the kWh to Height. You will see something like this:
The two layers are on top of each other, so we will change the second layer to heat map. You can do so by clicking on the heat map button right under Data:
You will then see something like this
And here you can adjust the thickness of the columns in layer 1 so you can see better.
This setting is under Layer Options
And you can adjust the radius of influence of the heat map which is in Layer 2, and adjust that to be Average visual aggregation instead of sum.
You will now see something like this
You can already see that houses of similar size which were built in the 1960’s in red above use more electricity on average than houses built in the 1980’s which are the beige color in the middle. This gets even more interesting if you add time to the heat map layer 2 which shows the average kWh consumption.
Click on the Add Field in the Time well and then click on PeriodStart which will add it to the well.
Then make sure that the time aggregation is set to ‘Data stays until it is replaced’
You can now animate the second layer over time using the time playback control at the bottom of the screen.
You will see how the heat map changes color as the seasons change further illustrating how electricity changes.
You can animate data and show how it accumulates over time using the same steps and using the different aggregation options for time. If we temporarily hide Layer 1 by clicking on the eye icon
And then change the heat map aggregation of Layer 2 to sum
And same in the Layer 2 Options
And now playback over time it is again apparent that the consumption increased very rapidly where the houses were older.straight line parallel to the point in the surface at which you have positioned the scene. Think of it as if you have a camera dolly and you are moving along the scene in parallel
Above are two sc