Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

A Microsoft Power Map tour can show a time-based relationship between geographic locations and their associated data—such as population numbers, temperature highs or lows, or flight arrival delays.

When you start Power Map from a workbook that doesn’t already contain a tour, a new tour with a single scene is automatically created. Tours and scenes are the basic way to save the Power Map visualizations of your data.

You can create as many tours as you want in a workbook. You switch between tours and create new tours by using the Launch Power Map box. This example has three tours that show world population by continent.

Launch Power Map

Create a tour

  1. Select any cell in the Excel table or range of cells that has your data. Be sure to do this before you create the tour; it makes it easier for you to hook up the data to the new tour.

  2. Click Insert > Map > Open Power Map.

The Power Map window appears, showing your new tour.

Add another tour to your workbook

  1. Select any cell in the Excel table or range of cells that has your data. Be sure to do this before you create the tour; it makes it easier for you to hook up the data to the new tour.

  2. Click Insert > Map > Open Power Map. The Launch Power Map box appears.

  3. Click New Tour.

The new tour appears in the Power Map window. If another tour was already open, Power Map closes it.

Save your tours

There’s no Save button in Power Map; all tours and scenes are preserved in the state in which you close the window. When you save your workbook, any Power Map tours and scenes are saved with it.

All changes you make to a scene in Power Map while editing are saved automatically, but any changes you make to a scene in tour playback mode—such as resizing, removing a legend, or removing a timeline—aren’t saved. All tours open in edit mode by default, and all the scenes in a tour are shown in the Tour Editor pane.

Add a scene to a tour

A tour can have a single scene, or multiple scenes that play sequentially to show different views of your data, such as highlighting a section of a map, or showing other data related to the geographic locations. For example, the first scene in your tour could show population growth for cities over time, followed by a scene showing the number of public swimming pools in those cities over the same time period, followed by more scenes that show other information about those cities. This example shows a four-scene tour for a selection of cities in the U.S. Southwest region.

Tour Editor task pane

Play a tour

Power Map always plays a tour in full-screen mode. Playback buttons are available at the bottom of the screen.

Tour in fullscreen playback mode

  1. Open the tour from the Launch Power Map box.

  2. In the Power Map window, on the Home tab, click Play Tour.

You can pause, play, move to the previous or next scene, or go back to edit mode. When you pause the tour, you can explore the 3-D environment and interact with it. Any changes you make in play mode aren't saved as part of the scene. Once you resume playback or go back to edit mode, the changes you made in play mode are lost.

Note:  The Play Tour button always plays the tour beginning with the first scene. You can navigate to the scene you want with the Next and Previous buttons in Play mode.

Delete a tour

Note: The Undo command in Excel can't restore a tour you've just deleted.

  1. In the workbook, click Insert > Map > Open Power Map.

  2. Right-click the tour, and click Delete.

Copy a tour

In the Launch Power Map box, right-click a tour and click Duplicate. This creates a new tour that you can fine tune, while leaving the original tour untouched.

Learn more about working with Power Map

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×