DisplayBlanksAs Property

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

XlDisplayBlanksAs can be one of these XlDisplayBlanksAs constants.

xlInterpolated

xlNotPlotted

xlZero

expression.DisplayBlanksAs

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

This example sets Microsoft Graph to not plot blank cells.

myChart.DisplayBlanksAs = xlNotPlotted
Show: