Gets or sets a value that specifies the maximum for the vertical axis that is shared across all sparklines in this sparkline group. The axis is zero if maxAxisType does not equal custom.
This example uses the ManualMax 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();
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()
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)