Other Options tab

The Options tab is a tab of the Chart Options dialog.

See Chart options.

You can specify these options on the Options tab:

  • How values which are missing from the chart data are represented.
  • Whether to display all chart categories automatically.
  • Whether the chart should be animated.
Empty Values

These options specify how empty values are displayed:

  • Not plotted: This is the default. Missing values are not estimated and not plotted on the chart.
  • Interpolated: Values for the missing data are estimated from the previous and subsequent values in the data series.
  • Zero: The missing values are plotted as if they had a value of Zero.
Categories
By default, charts display a data series for each chart category. In a chart without axes - a pie chart for example - you can specify the number of categories and so determine the number of data series to display. To display fewer data series than there are categories, select User-defined and specify a number of categories. For charts with axes, you can specify both the number and sequence of categories to display.
See Scaling tab.

Interactive and animated charts

Some charts types can be interactive. For example, chart shapes are highlighted and tooltips are displayed in response to movement of the mouse.

Interactive charts can also be animated. For example, when a column chart loads, the columns rise from zero to their correct heights.

You can enable interactivity and animation for individual data series or for an entire chart.

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.

To enable interactivity and animation options for a data series, select the Interactive and Animated options on the Options tab of the Format Data Series dialog.

Whether interactivity and animation are supported depends on the chart type and on which fill is selected in the Pattern tab. With the exception of line and profile charts, at least one of the data series must have a fill selected from the Gradients and other options dialog.

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. After loading, the segments expand while 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. After loading, the segments of the rings expand while the cursor is over them.
Portfolio On loading, the bubbles of the chart expand from single pixels to their full size.

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.
Parent topic: Chart options