SparklineAxisMinMax Enumeration

An enumeration that specifies information about how the vertical axis minimum or maximum is computed for this sparkline group.

Syntax

Visual Basic
C#

'Declaration
 
Public Enum SparklineAxisMinMax 
   Inherits System.Enum

'Usage
 
Dim instance As SparklineAxisMinMax

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.

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()

Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         GrapeCity.Windows.SpreadSheet.Data.SparklineAxisMinMax

Reference

GrapeCity.Windows.SpreadSheet.Data Namespace