Spread Windows Forms 7.0 Product Documentation
MaxAxisType Property
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > ExcelSparklineSetting Class : MaxAxisType Property


Glossary Item Box

Gets or sets a value that specifies how the vertical axis maximums for the sparklines in this sparkline group are calculated.

Syntax

Visual Basic (Declaration) 
Public Property MaxAxisType As SparklineAxisMinMax
Visual Basic (Usage)Copy Code
Dim instance As ExcelSparklineSetting
Dim value As SparklineAxisMinMax
 
instance.MaxAxisType = value
 
value = instance.MaxAxisType
C# 
public SparklineAxisMinMax MaxAxisType {get; set;}

Example

This example sets the MaxAxisType property.
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 BasicCopy 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)

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.