SheetXL - v1.0.2
    Preparing search index...

    Interface DataBar

    An in-cell bar whose length is the value's position between minPoint and maxPoint.

    interface DataBar {
        axisColor?: string;
        axisPosition?: "none" | "middle";
        borderColor?: string;
        color?: string;
        direction?: "leftToRight" | "rightToLeft";
        maxLength?: number;
        maxPoint?: Stop;
        minLength?: number;
        minPoint?: Stop;
        negativeBorderColor?: string;
        negativeFillColor?: string;
        showValue?: boolean;
        solidFill?: boolean;
        type: "dataBar";
    }
    Index
    axisColor? axisPosition? borderColor? color? direction? maxLength? maxPoint? minLength? minPoint? negativeBorderColor? negativeFillColor? showValue? solidFill? type
    axisColor?: string

    The color of the axis drawn between positive and negative bars.

    axisPosition?: "none" | "middle"

    Where the axis sits when the range mixes signs. Absent is automatic (proportional to the values); middle fixes it at the cell midpoint; none draws no axis and bars grow from the value's own side.

    borderColor?: string

    The bar's border color. Absent means no border.

    color?: string

    The bar's color, for a solid or a gradient bar alike; a gradient fades from it.

    '#638EC6'
    direction?: "leftToRight" | "rightToLeft"

    The direction bars grow in. Absent follows the cell's text direction.

    maxLength?: number

    The longest bar, as a whole percent of the cell's width.

    100
    maxPoint?: Stop

    The value at which the bar is longest.

    { type: 'max' }

    minLength?: number

    The shortest bar, as a whole percent of the cell's width.

    0
    minPoint?: Stop

    The value at which the bar is shortest.

    { type: 'min' }

    negativeBorderColor?: string

    The border for bars of negative values. Absent means negative bars use

    borderColor.

    negativeFillColor?: string

    The fill for bars of negative values. Absent means negative bars use color.

    showValue?: boolean

    If true, the value will be shown in the cell.

    solidFill?: boolean

    If true, the bar is painted in color edge to edge. Otherwise it is a gradient, solid at its base and fading toward its tip.

    false
    type: "dataBar"

    Indicates the type of the scale, which for a data bar is always DataBar.

    Settings
    Member Visibility

    On This Page
    Properties