SeriesColor Property (SparklineSetting)

Gets or sets a value that specifies the color for each sparkline in this sparkline group.

Syntax

Visual Basic
C#

'Declaration
 
<System.ComponentModel.DefaultValueAttribute()>
Public Property SeriesColor As System.Windows.Media.Color

'Usage
 
Dim instance As SparklineSetting
Dim value As System.Windows.Media.Color
 
instance.SeriesColor = value
 
value = instance.SeriesColor

[System.ComponentModel.DefaultValue()]
public System.Windows.Media.Color SeriesColor {get; set;}

Example

This example sets the SeriesColor property.

GrapeCity.Windows.SpreadSheet.Data.CellRange cellr = new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 1, 5);
GrapeCity.Windows.SpreadSheet.Data.SparklineSetting ex = new GrapeCity.Windows.SpreadSheet.Data.SparklineSetting();
ex.SeriesColor  = System.Windows.Media.Colors.Aquamarine; 
gcSpreadSheet1.Sheets[0].Cells[0, 0].Value = 2;
gcSpreadSheet1.Sheets[0].Cells[0, 1].Value = 5;
gcSpreadSheet1.Sheets[0].Cells[0, 2].Value = 4;
gcSpreadSheet1.Sheets[0].Cells[0, 3].Value = -1;
gcSpreadSheet1.Sheets[0].Cells[0, 4].Value = 3;
gcSpreadSheet1.Sheets[0].SetSparkline(0, 5, cellr, GrapeCity.Windows.SpreadSheet.Data.DataOrientation.Horizontal, GrapeCity.Windows.SpreadSheet.Data.SparklineType.Column, ex);
gcSpreadSheet1.Invalidate();           

        private void button1_Click(object sender, RoutedEventArgs e)
        {
            listBox1.Items.Add(gcSpreadSheet1.Sheets[0].GetSparkline(0, 5).ToString());
            gcSpreadSheet1.Sheets[0].RemoveSparkline(0, 5);
            gcSpreadSheet1.Invalidate();
        }

VB.NET

Dim cellr As New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 1, 5)
Dim ex As New GrapeCity.Windows.SpreadSheet.Data.SparklineSetting()
ex.SeriesColor = System.Windows.Media.Colors.Aquamarine
GcSpreadSheet1.Sheets(0).Cells(0, 0).Value = 2
GcSpreadSheet1.Sheets(0).Cells(0, 1).Value = 5
GcSpreadSheet1.Sheets(0).Cells(0, 2).Value = 4
GcSpreadSheet1.Sheets(0).Cells(0, 3).Value = -1
GcSpreadSheet1.Sheets(0).Cells(0, 4).Value = 3
GcSpreadSheet1.Sheets(0).SetSparkline(0, 5, cellr, GrapeCity.Windows.SpreadSheet.Data.DataOrientation.Horizontal, GrapeCity.Windows.SpreadSheet.Data.SparklineType.Column, ex)
GcSpreadSheet1.Invalidate()

    Private Sub Button1_Click(sender As System.Object, e As System.Windows.RoutedEventArgs) Handles Button1.Click
        ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).GetSparkline(0, 5).ToString())
        GcSpreadSheet1.Sheets(0).RemoveSparkline(0, 5)
        GcSpreadSheet1.Invalidate()
    End Sub

Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

SparklineSetting Class
SparklineSetting Members