Returns or sets the way that blank cells are plotted on a chart. Read/write .

XlDisplayBlanksAs can be one of these XlDisplayBlanksAs constants.
xlInterpolated
xlNotPlotted
xlZero

expression.DisplayBlanksAsexpressionRequired. An expression that returns one of the objects in the Applies To list.

Example

This example sets Microsoft Graph to not plot blank cells.

myChart.DisplayBlanksAs = xlNotPlotted