Empty points are data points that do not have Y values or have been
marked as empty. They are visually displayed in the chart area. Empty points are
not the same as missing data points, which refer to data points that are
missing in a data set.
The following example shows that there is no data for Wednesday.
|
|
If the X values of the plotted series are indexed, then it is possible that the missing data is can be overlooked by the chart reader (see the figure below).
In this case, use an empty point to clarify that a data point is missing. For example:
Use empty points to:
Empty data points can be added to a series using:
Empty points can be displayed as a marker or a line that connect the nearest two points. It can be displayed as an average of the adjacent points or as having a value of zero (see the figure below).