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
 
<System.ComponentModel.DefaultValueAttribute()>
Public Property MaxAxisType As SparklineAxisMinMax

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

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

Example

This example uses the MaxAxisType property.

GrapeCity.Windows.SpreadSheet.Data.CellRange cellr = new GrapeCity.Windows.SpreadSheet.Data.CellRange(1, 0, 1, 3);
GrapeCity.Windows.SpreadSheet.Data.SparklineSetting ex = new GrapeCity.Windows.SpreadSheet.Data.SparklineSetting();
ex.MaxAxisType = GrapeCity.Windows.SpreadSheet.Data.SparklineAxisMinMax.Custom;
ex.ManualMax = 12;
ex.MinAxisType = GrapeCity.Windows.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.Windows.SpreadSheet.Data.DataOrientation.Horizontal, GrapeCity.Windows.SpreadSheet.Data.SparklineType.Column,ex);
gcSpreadSheet1.Invalidate();

VB.NET

Dim cellr As New GrapeCity.Windows.SpreadSheet.Data.CellRange(1, 0, 1, 3)
Dim ex As New GrapeCity.Windows.SpreadSheet.Data.SparklineSetting()
ex.MaxAxisType = GrapeCity.Windows.SpreadSheet.Data.SparklineAxisMinMax.Custom
ex.ManualMax = 12
ex.MinAxisType = GrapeCity.Windows.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.Windows.SpreadSheet.Data.DataOrientation.Horizontal, GrapeCity.Windows.SpreadSheet.Data.SparklineType.Column,ex)
GcSpreadSheet1.Invalidate()

Requirements

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

Reference

SparklineSetting Class
SparklineSetting Members