Chart.DisplayBlanksAs procedure builder

Chart.DisplayBlanksAs (Excel)

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

Possible Values are xlInterpolated - Values are interpolated into the chart, xlNotPlotted - Blank cells are not plotted, xlZero - Blanks are plotted as zero.
ActiveChart.DisplayBlanksAs = xlInterpolated