GrapeCity.Documents.Excel.ICascadeSparkLine.ItemTypes

ItemTypes Property

ItemTypes

Returns all item types.

The returned item types identify the marker used for each item in the cascade sparkline. The values should be "-", "+", or "=". The default value is null.

Declaration

string[] ItemTypes { get; }

ReadOnly Property ItemTypes 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[] itemTypes = sparkLine.ItemTypes;