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.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); | |
| VB.NET | Copy Code |
|---|---|
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) | |
Inheritance Hierarchy
System.Object
System.ValueType
System.Enum
FarPoint.Web.Spread.SparklineAxisMinMax
Requirements
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6