GrapeCity.Documents.Excel.ISparkHorizontalAxis.IsDateAxis

IsDateAxis Property

IsDateAxis

Gets whether the horizontal axis of the sparkline is based on date values.

Returns true when the sparkline group uses a date range for its horizontal axis.

Declaration

bool IsDateAxis { get; }

ReadOnly Property IsDateAxis As Boolean

Examples

worksheet.Range["A1:A4"].Value = new object[,] {{2}, {5}, {3}, {6}};
worksheet.Range["C1:C4"].Value = new object[,] {{"2024/1/1"}, {"2024/1/3"}, {"2024/1/6"}, {"2024/1/10"}};
ISparklineGroup group = worksheet.Range["B1"].SparklineGroups.Add(SparkType.Line, "A1:A4");
group.DateRange = "C1:C4";
ISparkHorizontalAxis horizontalAxis = group.Axes.Horizontal;
bool isDateAxis = horizontalAxis.IsDateAxis;