Missing Data in a Chart

How to:

When working with charts, you can use the options for missing data to control the display of values that are missing in a chart.

Note: This option is disabled for reports.

Procedure: How to Specify an Option for Missing Data

  1. Create a chart with at least one measure and one dimension.
  2. On the Data tab, in the Display group, click Missing Data.
  3. On the menu that displays, select one of the following options:
    • Gap. Displays missing values as a gap in bar, line, and area charts.
    • Zero. Displays a bar on the zero line in a bar chart. Displays a solid line that connects the missing value with the succeeding value in a line chart. Displays an area on the zero line in an area chart.
    • Interpolated Line. Displays missing values as an interpolated dotted line that connects the plot points preceding and succeeding the missing value in a line chart. Displays missing values as an interpolated bar in a bar chart. Displays missing values as an area in an area chart.

    Your chart displays based on the option you selected.