Creating animated visualizations

Animated visualizations are useful for spotting a measure in seasonal trends or simply observing measures over a period of time.

Getting ready

Let's use the sample file Sample – Coffee Chain (Access). Open a new worksheet and select Sample – Coffee Chain (Access) as the data source.

How to do it...

Once the data is loaded on the worksheet, perform the following steps to create an animated visualization:

  1. Click on the Show Me button to bring the Show Me toolbar on the screen.
  2. While holding the Ctrl key, click on Product from Dimensions and Sales from Measures.
  3. Click on the horizontal bars icon on the Show Me toolbar.
  4. Drag-and-drop Date from Dimensions into the Pages shelf as shown in the following screenshot:
    How to do it...
  5. To show the graphs by quarters, drag-and-drop Date from Dimensions into the Pages shelf again.
  6. To play the animation, click on the play button from the Pages shelf as shown in the following screenshot:
    How to do it...
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset