ManualMax Property

Gets or sets a value that specifies the maximum for the vertical axis that is shared across all sparklines in this sparkline group. The value must be zero if maxAxisType does not equal custom.

Syntax

Visual Basic
C#

'Declaration
 
Public Property ManualMax As Double

'Usage
 
Dim instance As ExcelSparklineSetting
Dim value As Double
 
instance.ManualMax = value
 
value = instance.ManualMax

public double ManualMax {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);

Visual Basic

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)

Reference

ExcelSparklineSetting Class
ExcelSparklineSetting Members