Interactive and animated charts

You can enable interactivity and animation for individual data series or for an entire chart. These options are on the Other Options tab of the Chart Options dialog box, and on the Options tab of the Format Data Series dialog box.

To enable interactivity and animation options for a chart, select the Interactive and Animated options on the Other Options tab of the Chart Options dialog.

Whether interactivity and animation are supported depends on the chart type and on which fill is selected in the Pattern tab.

This table shows the chart types that support interactivity and animation:


Chart type	Animation	Unsupported chart variants
Column	Columns rise from zero to correct height.	3D
Bar	Bars extend from zero to correct length.	3D
Pie	On loading, the segments fan out. Segments are highlighted when the cursor is over them.	Pie of Pie, Bar of Pie, Tiled Pie, 3D
Line and Profile	The lines begin as straight lines then warp into shape.	Smooth lines, 3D
Doughnut	On loading, the data series expand to form the rings of the chart. Segments are highlighted when the cursor is over them.
Portfolio	On loading, the bubbles of the chart expand from single pixels to their full size.

Charts display tooltips or data labels, but not both. To display tooltips, disable data labels.

When you move the cursor over a chart legend, the related shape in the chart is highlighted.

These fill types are supported:

Automatic
Solid fill
Images
Linear gradients
Radial gradients (if Internet Explorer is used, it must be version 9+)

These elements and options are always displayed statically:

Plot area, grid, chart axes and their labels, chart title
Drop lines, high-low lines, up-down bars, deviation areas, and steps for line charts
Error indicators
Chart legend
Value ranges
Vary colors by point is only supported by Line charts.
Cutting
Rounded gradient borders
Shadow
Invert if negative

These options are not supported:

Scaling of gradients
Vertical labels
Gradient borders