DisplayBlanksAs Property Example
This example sets Microsoft Excel to not plot blank cells in Chart1.
Charts("Chart1").DisplayBlanksAs = xlNotPlotted