Spread Silverlight Documentation
GrapeCity.Windows.SpreadSheet.Data Namespace / SparklineSetting Class / HighMarkerColor Property
Example


In This Topic
    HighMarkerColor Property
    In This Topic
    Gets or sets the color of the highest data point for each sparkline in this sparkline group.
    Syntax
    'Declaration
     
    <DefaultValueAttribute(System.Windows.Media.Color, "BlueViolet")>
    Public Property HighMarkerColor As Color
    'Usage
     
    Dim instance As SparklineSetting
    Dim value As Color
     
    instance.HighMarkerColor = value
     
    value = instance.HighMarkerColor
    [DefaultValue(System.Windows.Media.Color, "BlueViolet")]
    public Color HighMarkerColor {get; set;}
    Example
    This example uses the HighMarkerColor property.
    GrapeCity.Windows.SpreadSheet.Data.CellRange cellr = new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 1, 5);
    GrapeCity.Windows.SpreadSheet.Data.CellRange cellr2 = new GrapeCity.Windows.SpreadSheet.Data.CellRange(1, 0, 1, 5);
    GrapeCity.Windows.SpreadSheet.Data.SparklineSetting ex = new GrapeCity.Windows.SpreadSheet.Data.SparklineSetting();
    ex.AxisColor = System.Windows.SystemColors.ActiveBorderColor;
    ex.LineWeight = 1;
    ex.ShowMarkers = true;
    ex.MarkersColor = Color.FromArgb(255, 255, 0, 128);
    ex.ShowFirst = true;
    ex.ShowHigh = true;
    //ex.ShowLow = true;
    ex.ShowLast = true;
    ex.ShowNegative = true;
    ex.FirstMarkerColor = Color.FromArgb(255, 163, 73, 164);
    ex.HighMarkerColor = Color.FromArgb(255, 49, 78, 111);
    ex.LastMarkerColor = Color.FromArgb(255, 0, 255, 255);
    //ex.LowMarkerColor = Color.FromArgb(255, 255, 255, 0);
    ex.NegativeColor = Color.FromArgb(255, 255, 255, 0);
    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].Cells[1, 0].Value = new DateTime(2011, 1, 11);
    gcSpreadSheet1.Sheets[0].Cells[1, 1].Value = new DateTime(2011, 1, 08);
    gcSpreadSheet1.Sheets[0].Cells[1, 2].Value = new DateTime(2011, 1, 09);
    gcSpreadSheet1.Sheets[0].Cells[1, 3].Value = new DateTime(2011, 1, 14);
    gcSpreadSheet1.Sheets[0].Cells[1, 4].Value = new DateTime(2011, 1, 20);
    gcSpreadSheet1.Sheets[0].SetSparkline(0, 5, cellr, GrapeCity.Windows.SpreadSheet.Data.DataOrientation.Horizontal, GrapeCity.Windows.SpreadSheet.Data.SparklineType.Line, ex);
    //gcSpreadSheet1.Sheets[0].SetSparkline(0, 5, cellr, GrapeCity.Windows.SpreadSheet.Data.DataOrientation.Horizontal, GrapeCity.Windows.SpreadSheet.Data.SparklineType.Column, cellr2, GrapeCity.Windows.SpreadSheet.Data.DataOrientation.Horizontal, ex);
    gcSpreadSheet1.Invalidate();
    Dim cellr As New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 1, 5)
    Dim cellr2 As New GrapeCity.Windows.SpreadSheet.Data.CellRange(1, 0, 1, 5)
    Dim ex As New GrapeCity.Windows.SpreadSheet.Data.SparklineSetting()
    ex.AxisColor = System.Windows.SystemColors.ActiveBorderColor
    ex.LineWeight = 1
    ex.ShowMarkers = True
    ex.MarkersColor = Color.FromArgb(255, 255, 0, 128)
    ex.ShowFirst = True
    ex.ShowHigh = True
    'ex.ShowLow = True
    ex.ShowLast = True
    ex.ShowNegative = True
    ex.FirstMarkerColor = Color.FromArgb(255, 163, 73, 164)
    ex.HighMarkerColor = Color.FromArgb(255, 49, 78, 111)
    ex.LastMarkerColor = Color.FromArgb(255, 0, 255, 255)
    'ex.LowMarkerColor = Color.FromArgb(255, 255, 255, 0)
    ex.NegativeColor = Color.FromArgb(255, 255, 255, 0)
    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).Cells(1, 0).Value = new DateTime(2011, 1, 11)
    GcSpreadSheet1.Sheets(0).Cells(1, 1).Value = new DateTime(2011, 1, 08)
    GcSpreadSheet1.Sheets(0).Cells(1, 2).Value = new DateTime(2011, 1, 09)
    GcSpreadSheet1.Sheets(0).Cells(1, 3).Value = new DateTime(2011, 1, 14)
    GcSpreadSheet1.Sheets(0).Cells(1, 4).Value = new DateTime(2011, 1, 20)
    GcSpreadSheet1.Sheets(0).SetSparkline(0, 5, cellr, GrapeCity.Windows.SpreadSheet.Data.DataOrientation.Horizontal, GrapeCity.Windows.SpreadSheet.Data.SparklineType.Line, ex)
    'GcSpreadSheet1.Sheets(0).SetSparkline(0, 5, cellr, GrapeCity.Windows.SpreadSheet.Data.DataOrientation.Horizontal, GrapeCity.Windows.SpreadSheet.Data.SparklineType.Column, cellr2, GrapeCity.Windows.SpreadSheet.Data.DataOrientation.Horizontal, ex)
    GcSpreadSheet1.Invalidate()
    See Also