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


In This Topic
    MaxAxisType Property
    In This Topic
    Gets or sets a value that specifies how the vertical axis maximums for the sparklines in this sparkline group are calculated.
    Syntax
    'Declaration
     
    Public Property MaxAxisType As SparklineAxisMinMax
    'Usage
     
    Dim instance As ExcelSparklineSetting
    Dim value As SparklineAxisMinMax
     
    instance.MaxAxisType = value
     
    value = instance.MaxAxisType
    public SparklineAxisMinMax MaxAxisType {get; set;}
    Example
    This example creates a sparkline in a cell.
    FarPoint.Web.Spread.ExcelSparklineSetting ex = new FarPoint.Web.Spread.ExcelSparklineSetting();
    ex.MaxAxisType = FarPoint.Web.Spread.SparklineAxisMinMax.Custom;
    ex.ManualMax = 12;
    ex.MinAxisType = FarPoint.Web.Spread.SparklineAxisMinMax.Custom;
    ex.ManualMin = 0;
    fpSpread1.Sheets[0].RowCount = 10;
    fpSpread1.Sheets[0].ColumnCount = 10;
    fpSpread1.Sheets[0].Cells[1, 0].Value = 2;
    fpSpread1.Sheets[0].Cells[1, 1].Value = 11;
    fpSpread1.Sheets[0].Cells[1, 2].Value = 4;
    fpSpread1.Sheets[0].AddSparkline("Sheet1!$A$2:$C$2", "Sheet1!$D$2:$D$2", FarPoint.Web.Spread.SparklineType.Column, ex);
    Dim ex As New FarPoint.Web.Spread.ExcelSparklineSetting()
    ex.MaxAxisType = FarPoint.Web.Spread.SparklineAxisMinMax.Custom
    ex.ManualMax = 12
    ex.MinAxisType = FarPoint.Web.Spread.SparklineAxisMinMax.Custom
    ex.ManualMin = 0
    FpSpread1.Sheets(0).RowCount = 10
    FpSpread1.Sheets(0).ColumnCount = 10
    FpSpread1.Sheets(0).Cells(1, 0).Value = 2
    FpSpread1.Sheets(0).Cells(1, 1).Value = 11
    FpSpread1.Sheets(0).Cells(1, 2).Value = 4
    FpSpread1.Sheets(0).AddSparkline("Sheet1!$A$2:$C$2", "Sheet1!$D$2:$D$2", FarPoint.Web.Spread.SparklineType.Column, ex)
    See Also