Spread.NET 17 Formula Reference
Formula Functions / Functions H to L / LINESPARKLINE
In This Topic
    LINESPARKLINE
    In This Topic

    This function returns a data set used for representing a line sparkline.

    Syntax

    LINESPARKLINE(data, dataOrientation, [dateAxisData, dateAxisOrientation, setting])

    Arguments

    This function has the following arguments:

    Argument Description
    Data

    A range reference that represents sparkline data. For example: A1:C3.

    DataOrientation

    A number that represents the sparkline data orientation, 0 is vertical, 1 is horizontal.

    DateAxisData

    (Optional) A range reference that represents sparkline date axis data. For example: D1:F3.

    DateAxisOrientation

    (Optional) A number that represents the sparkline date axis orientation, 0 is vertical, 1 is horizontal.

    Setting

    (Optional) A string with JSON format.

    For example:

    {axisColor:rgb(255,255,0),firstMarkerColor:brown,highMarkerColor:red,lastMarkerColor:blue,lowMarkerColor:green,markersColor:purple,negativeColor:yellowgreen,

    seriesColor:pink,displayXAxis:true,showFirst:true,showHigh:true,showLast:true,showLow:true,showNegative:true,showMarkers:true,lineWeight:3,displayHidden:false,

    displayEmptyCellsAs:1,rightToLeft:false,minAxisType:1,maxAxisType:1,manualMax:5,manualMin:-3}

    Data Types

    Returns sparkline.

    Example

    activeSheet.setFormula(2, 2, '=LINESPARKLINE(B3:B14,0,A3:A14,0,"{axisColor:rgb(255,255,0),firstMarkerColor:brown,highMarkerColor:red,lastMarkerColor:blue,lowMarkerColor:green,markersColor:purple,negativeColor:yellowgreen,seriesColor:pink,displayXAxis:true,showFirst:true,showHigh:true,showLast:true,showLow:true,showNegative:true,showMarkers:true,lineWeight:3,displayHidden:false,displayEmptyCellsAs:1,rightToLeft:false,minAxisType:1,maxAxisType:1,manualMax:5,manualMin:-3}")');