SpreadJS Documentation
maxAxisType Field
Indicates how the vertical axis maximum is calculated for the sparklines in this sparkline group.
Syntax
var instance = new GcSpread.Sheets.SparklineSetting(setting);
var value; // Type: SparklineAxisMinMax
value = instance.maxAxisType;
var maxAxisType : SparklineAxisMinMax;
Example
This example sets the maxAxisType property.
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]);
See Also

Reference

SparklineSetting class

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.