SparklineGroup.DateRange Property
Gets or sets the date range for the sparkline group.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v18.2.Core.dll
Declaration
Property Value
| Type | Description |
|---|---|
| Range | A Range 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®).
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.