Share via


Chart.DisplayBlanksAs Property (Word)

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

Version Information

Version Added: Word 2007

Syntax

expression .DisplayBlanksAs

expression A variable that represents a Chart object.

Example

The following example sets Microsoft Word to not plot blank cells for the first chart in the active document.

With ActiveDocument.InlineShapes(1) 
 If .HasChart Then 
 .Chart.DisplayBlanksAs = xlNotPlotted 
 End If 
End With

See Also

Concepts

Chart Object

Chart Object Members