The LINESPARKLINE have the following options:

OptionDescription
DataA range reference that represents sparkline data. For example: A1:C3.
DataOrientationA number that represents the sparkline data orientation, 0 is vertical, 1 is horizontal.
DateAxisDataA range reference that represents sparkline date axis data. For example: D1:F3. This setting is optional.
DateAxisOrientationA number that represents the sparkline date axis orientation, 0 is vertical, 1 is horizontal. This setting is optional.
SettingA 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}". This setting is optional.

The following table lists the JSON format string and the equivalent sparkline setting method or property.

Json PropertySparklineSetting Method or Property
AXISCOLORaxisColor()
FIRSTMARKERCOLORfirstMarkerColor()
HIGHMARKERCOLORhighMarkerColor()
LASTMARKERCOLORlastMarkerColor()
LOWMARKERCOLORlowMarkerColor()
MARKERSCOLORmarkersColor()
NEGATIVECOLORnegativeColor()
SERIESCOLORseriesColor()
DISPLAYEMPTYCELLSASdisplayEmptyCellsAs
RIGHTTOLEFTrightToLeft
DISPLAYHIDDENdisplayHidden
DISPLAYXAXISdisplayXAxis
SHOWFIRSTshowFirst()
SHOWHIGHshowHigh()
SHOWLASTshowLast()
SHOWLOWshowLow()
SHOWNEGATIVEshowNegative()
SHOWMARKERSshowMarkers()
MANUALMAXmanualMax
MANUALMINmanualMin
MAXAXISTYPEmaxAxisType
MINAXISTYPEminAxisType
LINEWEIGHTlineWeight

Sample Usage


In order to use the LINESPARKLINE formula, start with your edited Excellentable:

Then type in the LINESPARKLINE formula in the area you would like to display the outcome:

By adding the values you would like to calculate the LINESPARKLINE formula for, Excellentable will generate the outcome:


Error.

User does not have sufficient privileges to access this Content
Learn More