Share via

XlDisplayBlanksAs Enumeration

  • Article

Specifies how blank cells are plotted on a chart.

Version Information

Version Added: Excel 2007

Name

Value

Description

xlInterpolated

3

Values are interpolated into the chart.

xlNotPlotted

1

Blank cells are not plotted.

xlZero

2

Blanks are plotted as zero.