How Missing Data Is Handled
By default, the following rules govern how missing data
points are handled:
- When a data
point is part of a cumulative total (stacked or percent bar, line, area,
pie slice), it is interpreted as 0.0.
- When a data
point is used with neighboring points to define a line segment or surface
(3D connected, 3D surface, 2D line, 2D area), it is interpreted
as 0.0.
- Otherwise (2D
side-by-side bar, 3D riser, 3D floating, 2D and 3D scatter, stock graphs,
spectral map, histogram), the (missing) point will not be plotted.
The FillMissingData and NumMissingDataSegments properties can
be used to override these rules and define how missing data points
are handled.