Displaying Missing Data Values in a Graph

How to:

Reference:

You can display missing data values (in a bar graph, line graph, area graph, or any variation of these graph types) in one of the following formats:

Dotted line to zero. In line graphs, a dotted line connects the missing value with the succeeding value. In 3D bar graphs, solid lines outline the flat bar corresponding to the missing value. In 2D bar graphs, a gap appears in the graph. In area graphs, a transparent area extends down to the zero line and then up to the succeeding value.


Top of page

x
Procedure: How to Display Missing Values in a Graph
  1. Click the Chart editor tab.
  2. Scroll to the bottom of the Chart objects area.
  3. In the Advanced folder, click the Data handling form.

    The Data handling form appears below the graph preview area.

  4. Click the Value column area to the right of Fill missing data in the Property column.

    A drop-down arrow appears at the far right edge of the row in the Value column.

  5. Click the down-arrow to open the drop-down list.
  6. Select one of the following methods of displaying missing values:
    • Skip (leave gaps)
    • Display At Zero
    • Interpolate

    The selected method to display missing values is now applied to your graph. If any missing values exist in the graph you are creating, your selection is reflected in the graph preview area.


Top of page

x
Reference: Displaying Missing Values as Zero in a Graph

The following image illustrates how missing values are represented in a line chart when designated to appear as zero. The unit sales for Cappuccino are missing.

missing values displayed as zero in a line chart


Top of page

x
Reference: Displaying Missing Values as a Gap

The following image illustrates how missing values are represented in a bar graph when designated to appear as a gap. The unit sales for Cappuccino are missing.

missing value displayed a a gap in a bar graph


WebFOCUS