SheetXL - v0.8.0-beta.9+sites.210.e2d420901
    Preparing search index...

    Interface DataBar

    An in-cell bar whose length is the value's position between the two stops.

    interface DataBar {
        axisColor?: string;
        axisPosition?: "none" | "middle";
        borderColor?: string;
        color?: string;
        direction?: "leftToRight" | "rightToLeft";
        gradient?: boolean;
        maxLength?: number;
        minLength?: number;
        negativeBorderColor?: string;
        negativeFillColor?: string;
        showValue?: boolean;
        stops: Stop[];
        type: "dataBar";
    }
    Index
    axisColor? axisPosition? borderColor? color? direction? gradient? maxLength? minLength? negativeBorderColor? negativeFillColor? showValue? stops 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 fill color.

    direction?: "leftToRight" | "rightToLeft"

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

    gradient?: boolean

    A gradient fill fading from color; absent is a solid bar.

    maxLength?: number
    minLength?: number
    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.

    stops: Stop[]

    The lower and upper bound of the bar. Always two.

    type: "dataBar"

    Settings
    Member Visibility

    On This Page
    Properties