Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Enum SparklineAxisMinMax Inherits System.Enum | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As SparklineAxisMinMax | |
| C# | |
|---|---|
public enum SparklineAxisMinMax : System.Enum | |
Members
| Member | Description |
|---|---|
| Custom | Specifies that the vertical axis minimum or maximum for each sparkline in this sparkline group is specified by the manualMin attribute or the manualMax attribute of the sparkline group. |
| Group | Specifies that the vertical axis minimum or maximum is shared across all sparklines in this sparkline group and is calculated automatically such that the data point with the minimum or maximum value can be displayed in the plot area. |
| Individual | Specifies that the vertical axis minimum or maximum for each sparkline in this sparkline group is calculated automatically such that the data point with the minimum or maximum value can be displayed in the plot area. |
Example
This example uses the SparklineAxisMinMax enumeration.
| C# | Copy Code |
|---|---|
FarPoint.Win.Spread.ExcelSparklineSetting ex = new FarPoint.Win.Spread.ExcelSparklineSetting(); ex.MaxAxisType = FarPoint.Win.Spread.SparklineAxisMinMax.Custom; ex.ManualMax = 12; ex.MinAxisType = FarPoint.Win.Spread.SparklineAxisMinMax.Custom; ex.ManualMin = 0; 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.Win.Spread.SparklineType.Column, ex); | |
| Visual Basic | Copy Code |
|---|---|
Dim ex As New FarPoint.Win.Spread.ExcelSparklineSetting() ex.MaxAxisType = FarPoint.Win.Spread.SparklineAxisMinMax.Custom ex.ManualMax = 12 ex.MinAxisType = FarPoint.Win.Spread.SparklineAxisMinMax.Custom ex.ManualMin = 0 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.Win.Spread.SparklineType.Column, ex) | |
Inheritance Hierarchy
System.Object
System.ValueType
System.Enum
FarPoint.Win.Spread.SparklineAxisMinMax
Requirements
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2