Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / ExcelSparklineSetting 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
     
    Public Property HighMarkerColor As Color
    'Usage
     
    Dim instance As ExcelSparklineSetting
    Dim value As Color
     
    instance.HighMarkerColor = value
     
    value = instance.HighMarkerColor
    public Color HighMarkerColor {get; set;}
    Example
    This example creates a sparkline in a cell.
    FarPoint.Web.Spread.SheetView sv = new FarPoint.Web.Spread.SheetView();
    FarPoint.Web.Spread.Chart.SheetCellRange data = new FarPoint.Web.Spread.Chart.SheetCellRange(sv, 0,0,1, 5);
    FarPoint.Web.Spread.Chart.SheetCellRange data2 = new FarPoint.Web.Spread.Chart.SheetCellRange(sv, 5,0,1,1);
    
    FarPoint.Web.Spread.ExcelSparklineSetting ex = new FarPoint.Web.Spread.ExcelSparklineSetting();
    ex.AxisColor = Color.SaddleBrown;
    ex.ShowFirst = true;
    ex.ShowHigh = true;
    ex.ShowLow = true;
    ex.ShowLast = true;
    
    ex.FirstMarkerColor = Color.Blue;
    ex.HighMarkerColor = Color.DarkGreen;
    ex.MarkersColor = Color.Aquamarine;
    ex.LowMarkerColor = Color.Red;
    ex.LastMarkerColor = Color.Orange;
    ex.ShowMarkers = true;
            
    fpSpread1.Sheets[0] = sv;
    fpSpread1.Sheets[0].RowCount = 10;
    fpSpread1.Sheets[0].ColumnCount = 10;
    sv.Cells[0, 0].Value = 2;
    sv.Cells[0, 1].Value = 5;
    sv.Cells[0, 2].Value = 4;
    sv.Cells[0, 3].Value = 1;
    sv.Cells[0, 4].Value = 3;
    fpSpread1.Sheets[0].AddSparkline(data, data2, FarPoint.Web.Spread.SparklineType.Line, ex);
    Dim sv As New FarPoint.Web.Spread.SheetView()
    Dim data As New FarPoint.Web.Spread.Chart.SheetCellRange(sv, 0, 0, 1, 5)
    Dim data2 As New FarPoint.Web.Spread.Chart.SheetCellRange(sv, 5, 0, 1, 1)
    
    Dim ex As New FarPoint.Web.Spread.ExcelSparklineSetting()
    ex.AxisColor = System.Drawing.Color.SaddleBrown
    ex.ShowFirst = True
    ex.ShowHigh = True
    ex.ShowLow = True
    ex.ShowLast = True
    
    ex.FirstMarkerColor = System.Drawing.Color.Blue
    ex.HighMarkerColor = System.Drawing.Color.DarkGreen
    ex.MarkersColor = System.Drawing.Color.Aquamarine
    ex.LowMarkerColor = System.Drawing.Color.Red
    ex.LastMarkerColor = System.Drawing.Color.Orange
    ex.ShowMarkers = True
    
    FpSpread1.Sheets(0) = sv
    FpSpread1.Sheets(0).RowCount = 10
    FpSpread1.Sheets(0).ColumnCount = 10
    sv.Cells(0, 0).Value = 2
    sv.Cells(0, 1).Value = 5
    sv.Cells(0, 2).Value = 4
    sv.Cells(0, 3).Value = 1
    sv.Cells(0, 4).Value = 3
    FpSpread1.Sheets(0).AddSparkline(data, data2, FarPoint.Web.Spread.SparklineType.Line, ex)
    See Also