DisplayBlanksAs Property

Applies To

Chart object.

Description

Returns or sets the way that blank cells are plotted on a chart. Can be one of the following XlDisplayBlanksAs constants: xlNotPlotted, xlInterpolated, or xlZero. Read/write Long.

Example

This example sets Microsoft Graph to not plot blank cells.

myChart.DisplayBlanksAs = xlNotPlotted