DisplayBlanksAs Property

Microsoft Excel Visual Basic

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 Excel to not plot blank cells in Chart1.

Charts("Chart1").DisplayBlanksAs = xlNotPlotted