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


In This Topic
    AxisColor Property (ExcelSparklineSetting)
    In This Topic
    Gets or sets the color of the axis.
    Syntax
    'Declaration
     
    Public Property AxisColor As Color
    'Usage
     
    Dim instance As ExcelSparklineSetting
    Dim value As Color
     
    instance.AxisColor = value
     
    value = instance.AxisColor
    public Color AxisColor {get; set;}

    Property Value

    The color of the axis.
    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, 2, 2);
    FarPoint.Web.Spread.Chart.SheetCellRange data2 = new FarPoint.Web.Spread.Chart.SheetCellRange(sv, 5, 0, 2, 1);
    
    FarPoint.Web.Spread.ExcelSparklineSetting ex = new FarPoint.Web.Spread.ExcelSparklineSetting();
    ex.AxisColor = Color.SaddleBrown;
    ex.ShowMarkers = true;
    ex.DisplayEmptyCellsAs = FarPoint.Web.Spread.Chart.EmptyValueStyle.Zero;
    
    fpSpread1.Sheets[0] = sv;
    fpSpread1.Sheets[0].RowCount = 10;
    fpSpread1.Sheets[0].ColumnCount = 5;
    sv.Cells[0, 0].Value = 2;
    sv.Cells[0, 1].Value = 5;
    sv.Cells[1, 0].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, 2, 2)
    Dim data2 As New FarPoint.Web.Spread.Chart.SheetCellRange(sv, 5, 0, 2, 1)
    Dim ex As New FarPoint.Web.Spread.ExcelSparklineSetting()
    ex.AxisColor = System.Drawing.Color.SaddleBrown
    ex.ShowMarkers = True
    ex.DisplayEmptyCellsAs = FarPoint.Web.Spread.Chart.EmptyValueStyle.Zero
    
    FpSpread1.Sheets(0) = sv
    FpSpread1.Sheets(0).RowCount = 10
    FpSpread1.Sheets(0).ColumnCount = 5
    sv.Cells(0, 0).Value = 2
    sv.Cells(0, 1).Value = 5
    sv.Cells(1, 0).Value = 3
    FpSpread1.Sheets(0).AddSparkline(data, data2, FarPoint.Web.Spread.SparklineType.Line, ex)
    See Also