XlDisplayBlanksAs Enumeration (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Specifies how blank cells are plotted on a chart.

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.

Show: