Formula Reference
Contacting Us
Getting Technical Support
Formula Overview
Formula Functions
- Functions A to C
- Functions D to G
- Functions H to L
  - HARMEAN
  - HBARSPARKLINE
  - HEX2BIN
  - HEX2DEC
  - HEX2OCT
  - HISTOGRAMSPARKLINE
  - HLOOKUP
  - HOUR
  - HSTACK
  - HYPERLINK
  - HYPGEOM.DIST
  - HYPGEOMDIST
  - IF
  - IFERROR
  - IFNA
  - IFS
  - IMABS
  - IMAGE
  - IMAGINARY
  - IMARGUMENT
  - IMCONJUGATE
  - IMCOS
  - IMCOSH
  - IMCOT
  - IMCSC
  - IMCSCH
  - IMDIV
  - IMEXP
  - IMLN
  - IMLOG10
  - IMLOG2
  - IMPOWER
  - IMPRODUCT
  - IMREAL
  - IMSEC
  - IMSECH
  - IMSIN
  - IMSINH
  - IMSQRT
  - IMSUB
  - IMSUM
  - IMTAN
  - INDEX
  - INDIRECT
  - INFO
  - INT
  - INTERCEPT
  - INTRATE
  - IPMT
  - IRR
  - ISBLANK
  - ISERR
  - ISERROR
  - ISEVEN
  - ISFORMULA
  - ISLOGICAL
  - ISNA
  - ISNONTEXT
  - ISNUMBER
  - ISO.CEILING
  - ISODD
  - ISOMITTED
  - ISOWEEKNUM
  - ISPMT
  - ISREF
  - ISTEXT
  - JIS
  - KURT
  - LAMBDA
  - LARGE
  - LCM
  - LEFT
  - LEFTB
  - LEN
  - LENB
  - LET
  - LINEST
  - LINESPARKLINE
  - LN
  - LOG
  - LOG10
  - LOGEST
  - LOGINV
  - LOGNORM.DIST
  - LOGNORM.INV
  - LOGNORMDIST
  - LOOKUP
  - LOWER
- Functions M to Q
- Functions R to S
- Functions T to Z

LINESPARKLINE

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}")');