GrapeCity.Documents.Excel.ISparkPoints.Negative

Negative Property

Negative

Gets the ISparkColor object that represents the color and visibility of markers for negative points of data on a sparkline.

Use this object to configure how negative data points are displayed in the sparkline group.

Declaration

ISparkColor Negative { get; }

ReadOnly Property Negative As ISparkColor

Examples

worksheet.Range["A1:A4"].Value = new object[,] {
    {10},
    {-5},
    {8},
    {-3}
};
ISparklineGroup group = worksheet.Range["B1"].SparklineGroups.Add(SparkType.Line, "A1:A4");
ISparkColor negative = group.Points.Negative;
negative.Color.RGB = Color.Red;
negative.Visible = true;