SpreadJS 15
Formula Reference / Formula Functions / Sparkline Functions / VBARSPARKLINE
In This Topic
    In This Topic

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


    VBARSPARKLINE(value, [colorScheme, axisVisible, barWidth])


    Argument Description
    value A number or reference that represents the length of the bar. The value should be between 100% and -100%.
    colorScheme (Optional) A string that represents the color of the bar. The default value is "grey".
    axisVisible (Optional) A Boolean value that indicates whether or not to show the axis. The default value is true.
    barWidth (Optional) A number greater than 0 and less than or equal to 1, which indicates the percentage of bar width according to the cell width.

    Data Types

    Returns sparkline.


    activeSheet.setFormula(0, 1, '=VBARSPARKLINE(A1,"red", FALSE, 0.8)');