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