Chart.DisplayBlanksAs Property

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.

  Charts("Chart1").DisplayBlanksAs = xlNotPlotted

See Also

• Chart Object
• Chart Object Members