ChartOptions.DisplayBlanksAs Property
Gets or sets a value that specifies how empty cells should be plotted on a chart.
Namespace: DevExpress.Spreadsheet.Charts
Assembly: DevExpress.Spreadsheet.v24.2.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
#Declaration
DisplayBlanksAs DisplayBlanksAs { get; set; }
#Property Value
Type | Description |
---|---|
Display |
A Display |
Available values:
Name | Description |
---|---|
Zero | Specifies that empty cells should be treated as zeros. |
Span | Specifies that empty cells should be spanned with a line. |
Gap | Specifies that empty cells should be displayed as gaps on a chart. |
#Property Paths
You can access this nested property as listed below:
Object Type | Path to Display |
---|---|
Chart |
|
#Remarks
Use the DisplayBlanksAs property to determine the way how empty cells are plotted on a line, area, scatter or radar chart.
The image below shows the possible ways to display blank values on a chart.
Note
The Spreadsheet control supports only the Display
To specify whether or not to show data in hidden rows and columns on a chart, use the ChartOptions.PlotVisibleOnly property.