SparklineGroup.DisplayBlanksAs (Excel)

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

ActiveCell.SparklineGroups(1).DisplayBlanksAs = xlInterpolated