Change Power Map time options

Note: This article has done its job, and will be retiring soon. To prevent "Page not found" woes, we're removing links we know about. If you've created links to this page, please remove them, and together we'll keep the web connected.

If your rows of data have a date or time element, you can watch your values change over time in Power Map. You can also set custom start and end dates to focus on the exact time period you want.

Date or time fields in the Time box

After Power Map has initially plotted your geographic data, you can choose values to highlight (such as demographics, sales, or wind speed) and, if you have a time-based field, you drag it to the Time box.

Important: Date and time columns need to be formatted as the Date/Time type in your source data. Values in Excel might look like a date or time, but it's possible they could be formatted as text. If date values aren't working as you expect in Power Map, go back to the source data and check the data type. Then, hit Refresh in Power Map.

  1. In the Layer Pane, drag your date or time field to the Time box.

If you don't see the Layer Pane, on the Home tab, click Layer Pane.

Dragging date field to Time box in Layer Pane

  1. Click the arrow next to the clock icon (as shown below) to choose whether to show data for an instant, as it accumulates, or let values stay until they're replaced by new values.

Choose how to plot time

  1. To use a time aggregation type, such as Day, Month, Quarter, or Year, in the Time box, click the arrow on the right (as shown below) to select a time period. This will group your data for the selected time period.

For example, if your data is time stamped with a date, and you choose to aggregate by month, you'll see the sum of values for each month while the map animates month by month.

Time box in Layer pane

Change the length of a scene

By default, a scene is only 6 seconds long. But if you have a lot of data to show over time, you may want make the scene run a bit longer. For example, if you want to show several hundred thousands of ticket sales for a movie theater over several months, you'd want to slow the animation so that you can see the sales develop over time.

You can add several scenes to a tour, and use each scene to show a different month. Or, you could have a single scene that shows all months. The total length of the tour is approximately the sum of the length of all scenes and the sum of the length of transitions between each scene. You can edit the length of each scene and their transitions by setting scene properties.

  1. Click the Options icon on the timeline.

Options icon on the Power Map timeline

If you don't see the timeline, on the Home tab, click Time Line.

Power Map Time Line button

Tip: If the Time Line button is dimmed, make sure you've added a date field to the Time box.

  1. Under Scene, set a duration for the scene. If you haven't added any additional scenes to the tour, this scene represents the entire tour.

Setting the duration of a scene or tour

  1. To have the scene show only a specific range of dates, under Time, set a start date, an end date, or both.

Start date and End date boxes

Tip: You can change the duration of the tour or a scene by using the Speed slider, under Time. This changes the duration value in the Scene duration (sec) box as you move the slider.

Speed slider

  1. Use the Transition duration (sec) box to set the length of time between scenes. Changing the transition time between scenes will change the overall length of the tour.

Setting a transition duration

Use the Date & Time box to show elapsed time

Showing the Date & Time box lets people see the date and time as the animation of the data progresses.

  1. On the Home tab, click Date & Time to show the Date & Time box during playback or preview.

Date and Time button

  1. Right-click the Date & Time box, and click Edit.

  2. Pick a format in the Time Format box.

Date and Time box options

  1. In addition to picking a time format, you can change the text's font, size, color, and add bolding or italics.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.