manualMin Field

Indicates the minimum for the vertical axis that is shared across all sparklines in this sparkline group. The axis is zero if minAxisType does not equal custom.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.SparklineSetting(setting);
var value; // Type: number
value = instance.manualMin;

var manualMin : number;

Example

This example sets the manualMin property.

Javascript

activeSheet.setValue(0, 0, "Data Range is A2-A9");
activeSheet.setValue(1, 0, 1);
activeSheet.setValue(2, 0, -2);
activeSheet.setValue(3, 0, -1);
activeSheet.setValue(4, 0, 6);
activeSheet.setValue(5, 0, 4);
activeSheet.setValue(6, 0, -4);
activeSheet.setValue(7, 0, 3);
activeSheet.setValue(8, 0, 8);

var data = new GcSpread.Sheets.Range(1, 0, 8, 1);
var setting = new GcSpread.Sheets.SparklineSetting();
setting.minAxisType = GcSpread.Sheets.SparklineAxisMinMax.custom;
setting.manualMin = -2;
setting.maxAxisType = GcSpread.Sheets.SparklineAxisMinMax.custom;
setting.manualMax = 10;
var s1=  activeSheet.setSparkline(11, 0, data, GcSpread.Sheets.DataOrientation.Vertical, GcSpread.Sheets.SparklineType.line, setting);
var s2 =activeSheet.setSparkline(11, 3, data, GcSpread.Sheets.DataOrientation.Vertical, GcSpread.Sheets.SparklineType.column, setting);
var s3=  activeSheet.setSparkline(11, 6, data, GcSpread.Sheets.DataOrientation.Vertical, GcSpread.Sheets.SparklineType.winloss, setting);
var group = activeSheet.groupSparkline([s1,s2,s3]);

Reference

SparklineSetting class