Applies To
Chart Object.
Description
Returns or sets how blank cells are plotted on a chart (one of xlNotPlotted, xlInterpolated, or xlZero). Read-write.
Example
This example causes Microsoft Excel not to plot blank cells in Chart1.
Charts("Chart1").DisplayBlanksAs = xlNotPlotted