Spread.NET 17 Formula Reference
Formula Functions / Functions H to L / HBARSPARKLINE
In This Topic
    HBARSPARKLINE
    In This Topic

    This function returns a data set used for representing an Hbar sparkline.

    Syntax

    HBARSPARKLINE(value, [colorScheme, axisVisible, barHeight])

    Arguments

    This function has the following 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 to show the axis. The default value is true.
    barHeight

    (Optional) A number greater than 0 and less than or equal to 1, which indicates the percentage of bar height according to the cell height.

    Data Types

    Returns sparkline.

    Example

    activeSheet.setFormula(0, 1, '=HBARSPARKLINE(A1,"red", FALSE, 0.5)');