GrapeCity.Xaml.SpreadSheet.Data
MinAxisType Property (SparklineSetting)
Example 


GrapeCity.Xaml.SpreadSheet.Data Namespace > SparklineSetting Class : MinAxisType Property
Gets or sets a value that specifies how the vertical axis minimum is calculated for the sparklines in this sparkline group.
Syntax
'Declaration
 
<DefaultValueAttribute()>
Public Property MinAxisType As SparklineAxisMinMax
'Usage
 
Dim instance As SparklineSetting
Dim value As SparklineAxisMinMax
 
instance.MinAxisType = value
 
value = instance.MinAxisType
[DefaultValue()]
public SparklineAxisMinMax MinAxisType {get; set;}
Example
This example uses the MinAxisType property.
GrapeCity.Xaml.SpreadSheet.Data.CellRange cellr = new GrapeCity.Xaml.SpreadSheet.Data.CellRange(1, 0, 1, 3);
GrapeCity.Xaml.SpreadSheet.Data.SparklineSetting ex = new GrapeCity.Xaml.SpreadSheet.Data.SparklineSetting();
ex.MaxAxisType = GrapeCity.Xaml.SpreadSheet.Data.SparklineAxisMinMax.Custom;
ex.ManualMax = 12;
ex.MinAxisType = GrapeCity.Xaml.SpreadSheet.Data.SparklineAxisMinMax.Custom;
ex.ManualMin = 0;
gcSpreadSheet1.Sheets[0].Cells[1, 0].Value = 5;
gcSpreadSheet1.Sheets[0].Cells[1, 1].Value = 17;
gcSpreadSheet1.Sheets[0].Cells[1, 2].Value = 4;
gcSpreadSheet1.Sheets[0].SetSparkline(1, 3, cellr, GrapeCity.Xaml.SpreadSheet.Data.DataOrientation.Horizontal, GrapeCity.Xaml.SpreadSheet.Data.SparklineType.Column,ex);
Dim cellr As New GrapeCity.Xaml.SpreadSheet.Data.CellRange(1, 0, 1, 3)
Dim ex As New GrapeCity.Xaml.SpreadSheet.Data.SparklineSetting()
ex.MaxAxisType = GrapeCity.Xaml.SpreadSheet.Data.SparklineAxisMinMax.Custom
ex.ManualMax = 12
ex.MinAxisType = GrapeCity.Xaml.SpreadSheet.Data.SparklineAxisMinMax.Custom
ex.ManualMin = 0
GcSpreadSheet1.Sheets(0).Cells(1, 0).Value = 5
GcSpreadSheet1.Sheets(0).Cells(1, 1).Value = 17
GcSpreadSheet1.Sheets(0).Cells(1, 2).Value = 4
GcSpreadSheet1.Sheets(0).SetSparkline(1, 3, cellr, GrapeCity.Xaml.SpreadSheet.Data.DataOrientation.Horizontal, GrapeCity.Xaml.SpreadSheet.Data.SparklineType.Column,ex)
See Also

Reference

SparklineSetting Class
SparklineSetting Members