Spread for ASP.NET 13 Product Documentation
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / ExcelSparklineSetting Class / LastMarkerColor Property
Example


In This Topic
    LastMarkerColor Property
    In This Topic
    Gets or sets the color of the last data point for each sparkline in this sparkline group.
    Syntax
    'Declaration
     
    Public Property LastMarkerColor As Color
    'Usage
     
    Dim instance As ExcelSparklineSetting
    Dim value As Color
     
    instance.LastMarkerColor = value
     
    value = instance.LastMarkerColor
    public Color LastMarkerColor {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