Chart.DisplayBlanksAs Property (Excel)
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