Skip to main content
Row

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

SparklineGroup.DateRange Property

Gets or sets the date range for the sparkline group.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

#Declaration

CellRange DateRange { get; set; }

#Property Value

Type Description
CellRange

A CellRange object that contains the date values for the sparkline data.

#Remarks

If the underlying data for the sparkline charts occurs in irregular periods of time, you can reflect these time intervals on a sparkline by spacing data markers out in proportion to the date (the longer the interval between dates, the longer the distance between the corresponding data markers on a sparkline). To do this, assign the cell range containing date values for the sparkline group to the DateRange property. This will automatically convert the horizontal axis to the date axis (you can use the SparklineHorizontalAxis.IsDateAxis property to determine the axis type) and change the space between data markers, as shown in the image below (the workbook is opened in Microsoft® Excel®).

SpreadsheetControl_Sparkline_DateAxisType

Note

The date range must include date values located in a single row or column. If the cell range is insufficient for the date axis, an exception will be thrown.

See Also