Chart.DisplayBlanksAs Property

Excel Developer Reference

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

Syntax

expression.DisplayBlanksAs

expression   A variable that represents a Chart object.

Example

This example sets Microsoft Excel to not plot blank cells in Chart1.

Visual Basic for Applications
  Charts("Chart1").DisplayBlanksAs = xlNotPlotted

See Also