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 and 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
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