GrapeCity.Documents.Excel.ICascadeSparkLine.ColorNegative

ColorNegative Property

ColorNegative

Returns the color of the first or last negative sparkline box.

This color is used for a box whose point value is negative. The default value is "#D6604D".

Declaration

string ColorNegative { get; }

ReadOnly Property ColorNegative As String

Examples

worksheet.Range["A2:B4"].Value = new object[,] {
    {"Salary", 3500},
    {"Expense", -800},
    {"Bonus", 1200}
};
worksheet.Range["C2"].Formula = "=CASCADESPARKLINE(B2:B4,2,A2:A4,,,\"#8CBF64\",\"#D6604D\",FALSE)";
ICascadeSparkLine sparkLine = (ICascadeSparkLine) worksheet.Range["C2"].Value;
string color = sparkLine.ColorNegative;