GrapeCity.Documents.Excel.ICascadeSparkLine.ColorTotal

ColorTotal Property

ColorTotal

Returns the color of the total sparkline box.

This color represents the color of the last sparkline box when itemTypeRange does not exist, or the color of the resulting sparkline box when itemTypeRange exists. The default value is null.

Declaration

string ColorTotal { get; }

ReadOnly Property ColorTotal As String

Examples

worksheet.Range["A2:B4"].Value = new object[,] {
    {"Income", 500},
    {"Expense", -200},
    {"Balance", 300}
};
worksheet.Range["D2:D4"].Value = new object[,] { { "+" }, { "-" }, { "=" } };
worksheet.Range["C2"].Formula = "=CASCADESPARKLINE(B2:B4,3,A2:A4,,,\"#8CBF64\",\"#D6604D\",FALSE,D2:D4,\"#4F81BD\")";
ICascadeSparkLine sparkLine = (ICascadeSparkLine) worksheet.Range["C2"].Value;
string color = sparkLine.ColorTotal;