SpreadJS 13
GC.Spread.Sheets Namespace / Sparklines type / SparklineAxisMinMax Field
In This Topic
    SparklineAxisMinMax Field
    In This Topic
    An enumeration that specifies information about how the vertical axis minimum or maximum is computed for this sparkline group.
    Syntax
    var value; // Type: SparklineAxisMinMax
    value = GC.Spread.Sheets.Sparklines.SparklineAxisMinMax;
    var SparklineAxisMinMax : SparklineAxisMinMax;
    Example
    //This example uses the SparklineAxisMinMax enumeration.
    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 GC.Spread.Sheets.Range(1, 0, 8, 1);
    var setting = new GC.Spread.Sheets.Sparklines.SparklineSetting();
    setting.options.minAxisType = GC.Spread.Sheets.Sparklines.SparklineAxisMinMax.custom;
    setting.options.manualMin = -2;
    setting.options.maxAxisType = GC.Spread.Sheets.Sparklines.SparklineAxisMinMax.custom;
    setting.options.manualMax = 10;
    var s1=  activeSheet.setSparkline(11, 0, data, GC.Spread.Sheets.Sparklines.DataOrientation.Vertical, GC.Spread.Sheets.Sparklines.SparklineType.line, setting);
    var s2 =activeSheet.setSparkline(11, 3, data, GC.Spread.Sheets.Sparklines.DataOrientation.Vertical, GC.Spread.Sheets.Sparklines.SparklineType.column, setting);
    var s3=  activeSheet.setSparkline(11, 6, data, GC.Spread.Sheets.Sparklines.DataOrientation.Vertical, GC.Spread.Sheets.Sparklines.SparklineType.winloss, setting);
    var group = activeSheet.groupSparkline([s1,s2,s3]);
    See Also

    Reference

    Sparklines type