xlDisplayBlanksAs

Specifies how blank cells are plotted on a chart.

xlInterpolatedValues are interpolated into the chart (3)
xlNotPlottedBlank cells are not plotted (1)
xlZeroBlanks are plotted as zero (2)

xlInterpolated
Values are interpolated into the chart (3)
xlNotPlotted
Blank cells are not plotted (1)
xlZero
Blanks are plotted as zero (2)


© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top