MaxAxisType Property (SparklineSetting)

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

Syntax

Visual Basic
C#

'Declaration
 
<DefaultValueAttribute()>
Public Property MaxAxisType As SparklineAxisMinMax

'Usage
 
Dim instance As SparklineSetting
Dim value As SparklineAxisMinMax
 
instance.MaxAxisType = value
 
value = instance.MaxAxisType

[DefaultValue()]
public SparklineAxisMinMax MaxAxisType {get; set;}

Example

This example uses the MaxAxisType property.

C#
VB.NET

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)

Reference

SparklineSetting Class
SparklineSetting Members