Chart.DisplayBlanksAs Property

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`

Chart blank cells as zero on graph? Display display blanks as Display Blanks As Property displayblanks DisplayBlanksAs DisplayBlanksAs Property Ignore blank cells for plotting? Interpolate missing values when plotting data?

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

See also: