dateAxisOrientation Method

Gets or sets the date axis orientation.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.Sparkline(row, column, dataReference, dataOrientation, type, setting);
var returnValue; // Type: DataOrientation
returnValue = instance.dateAxisOrientation(value);

function dateAxisOrientation( 
   value : DataOrientation
) : DataOrientation;

Parameters

value: The sparkline date axis orientation.

Return Value

The sparkline date axis orientation.

Example

This example uses vertical data with horizontal dates to create a sparkline.

Javascript

var setting = new GcSpread.Sheets.SparklineSetting();
setting.showMarkers(true);
setting.displayXAxis = true;

activeSheet.isPaintSuspended(true);
activeSheet.setValue(1, 0, 10);
activeSheet.setValue(2, 0, 0);
activeSheet.setValue(3, 0, -3);
activeSheet.setValue(4, 0, -5);
activeSheet.setValue(0, 0, 1);
activeSheet.setValue(0, 1, 2);
activeSheet.setValue(0, 2, 4);
activeSheet.setValue(0, 3, 8);
activeSheet.setValue(0, 4, 6);
activeSheet.setValue(0, 5, new Date(2014, 1, 1));
activeSheet.setValue(1, 5, new Date(2014, 9, 1));
activeSheet.setValue(2, 5, new Date(2014, 7, 1));
activeSheet.setValue(3, 5, new Date(2014, 5, 1));
activeSheet.setValue(4, 5, new Date(2014, 3, 1));

activeSheet.setValue(11, 0, new Date(2014, 1, 1));
activeSheet.setValue(11, 1, new Date(2014, 9, 1));
activeSheet.setValue(11, 2, new Date(2014, 7, 1));
activeSheet.setValue(11, 3, new Date(2014, 5, 1));
activeSheet.setValue(11, 4, new Date(2014, 3, 1));
var sparkline = activeSheet.setSparkline(5, 0, new GcSpread.Sheets.Range(0, 0, 5, 5), GcSpread.Sheets.DataOrientation.Vertical, GcSpread.Sheets.SparklineType.line, setting, new GcSpread.Sheets.Range(11, 0, 1, 5), GcSpread.Sheets.DataOrientation.Horizontal);
sparkline.dataOrientation(GcSpread.Sheets.DataOrientation.Vertical);
sparkline.dateAxisOrientation(GcSpread.Sheets.DataOrientation.Horizontal);
sparkline.displayDateAxis(true); 
activeSheet.isPaintSuspended(false);

activeSheet.addSpan(5, 0, 4, 3, null);

Reference

Sparkline class