GrapeCity.Documents.Excel.ICascadeSparkLine.PointIndex

PointIndex Property

PointIndex

Returns the point index of the cascade sparkline.

Represents the points index. The point index is greater than or equal to 1.

Declaration

double PointIndex { get; }

ReadOnly Property PointIndex As Double

Examples

worksheet.Range["A2:A4"].Value = new object[] {"Start", "Increase", "End"};
worksheet.Range["B2:B4"].Value = new object[] {100, 50, 150};
worksheet.Range["C2"].Formula = "=CASCADESPARKLINE(B2:B4,1,A2:A4,,,\"#8CBF64\",\"#D6604D\",FALSE)";
ICascadeSparkLine sparkLine = (ICascadeSparkLine) worksheet.Range["C2"].Value;
double pointIndex = sparkLine.PointIndex;