WebFOCUS
Online Help > Managed Reporting Developer > Creating Graphs With Advanced Graph Assistant > Displaying Missing Data Values in a Graph
Displaying Missing Data Values in a Graph
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:
-
Skip (leave gaps). In
all graph types (bar, line, or area), missing values appear as a
gap in the graph.
-
Display At Zero. In
bar graphs, a bar appears on the zero line. In line graphs, a solid
line connects the missing value with the succeeding value. In area graphs,
the area appears on the zero line.
-
Interpolate. In
a line graph, missing values appear as an interpolated dotted line
that connects the plot points immediately preceding and succeeding
the missing value. In bar and area graphs, missing values display
as an interpolated (transparent) bar or area.
Procedure: How to Display Missing Values in a Graph
-
Click
the Chart editor tab.
-
Scroll
to the bottom of the Chart objects area.
-
In the
Advanced folder, click the Data handling form.
The Data handling form appears below the graph preview area.
-
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.
-
Click
the down-arrow to open the drop-down list.
-
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.
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.
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.