Animations can be useful in displaying a change over time or by groups of the data shown on a chart. When enabled, an animated chart will cycle through each of the unique data items in the selected column, and filter the chart data accordingly.

You can configure animation options by selecting the chart from the user interface designer, and clicking the blue Edit Animation button on the bottom of the right-hand menu.

The column to be used as the basis for the Animation Field property is where you can select the data column from your workbook to be used in filtering the chart data. The chart animation will consist of as many frames as there are unique items in this field. Please note that the data column to be used here must be included in the table named range selected for the chart.

You can select from Ascending or Descending options from the Order field to determine in which direction the Animation Field data is to be used in determining the order at which frames will be shown on the user interface. Note that the data order here is determined on an alphanumerical basis, meaning that items with numbers will come first, and then letters.

The Effect property allows selecting a special effect to be played when the animation begins playing.

The Duration field value sets the screen time for each frame. Note that this value is in milliseconds, so 2,000 means that each frame will be displayed for 2 seconds, and then switch to the next one.

You can customize the data that will be shown above the chart area from the Label field. You can enter any text around the keywords to better describe the animation data flow. Note that the keywords must be placed inside double curly braces.

Enabling Autoplay will automatically start the animation when the chart loads during runtime.

When the Loop property is disabled, users will need to press the Start button when the chart loads in the user interface to start the animation. If Loop is enabled, the animation will restart from the beginning whenever it ends.