DisplayBlanksAs Property
Returns or sets the way that blank cells are plotted on a chart. Read/write XlDisplayBlanksAs.
| XlDisplayBlanksAs can be one of these XlDisplayBlanksAs constants. |
| xlInterpolated |
| xlNotPlotted |
| xlZero |
expression.DisplayBlanksAs
expression Required. An expression that returns one of the objects in the Applies To list.
Example
This example sets Microsoft Graph to not plot blank cells.
myChart.DisplayBlanksAs = xlNotPlotted