Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

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
DisplayBlanksAs

A DisplayBlanksAs enumeration value that determines how blank values should be displayed on a chart.

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 DisplayBlanksAs
ChartObject
.Options .DisplayBlanksAs

#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.

ChartOptions_DisplayBlanksAs

Note

The Spreadsheet control supports only the DisplayBlanksAs.Gap and DisplayBlanksAs.Zero modes. If the DisplayBlanksAs.Span mode is specified, the Spreadsheet treats it as DisplayBlanksAs.Gap. However, this setting is saved to a document, so you can view the resulting chart in Microsoft® Excel® or another spreadsheet application.

To specify whether or not to show data in hidden rows and columns on a chart, use the ChartOptions.PlotVisibleOnly property.

See Also