Spread.NET 17 Formula Reference
Formula Functions / Functions T to Z / VBARSPARKLINE
In This Topic
    VBARSPARKLINE
    In This Topic

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

    Syntax

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

    Arguments

    This function has these arguments:

    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.

    Example

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