SheetXL - v1.0.2
    Preparing search index...

    Interface Trendline

    c:trendline: a line fitted to its series' points, or their moving average, with the fit's equation and R² as a label.

    interface Trendline {
        backward?: number;
        dispEq?: boolean;
        dispRSqr?: boolean;
        forward?: number;
        intercept?: number;
        name?: string;
        order?: number;
        period?: number;
        spPr?: ShapeProperties;
        trendlineLbl?: TrendlineLabel;
        trendlineType: "linear" | "exp" | "log" | "movingAvg" | "poly" | "power";
        unknown?: ChartModel.Unknown;
    }

    Hierarchy (View Summary)

    Index
    backward? dispEq? dispRSqr? forward? intercept? name? order? period? spPr? trendlineLbl? trendlineType unknown?
    backward?: number

    How far the line runs before the first point.

    dispEq?: boolean
    dispRSqr?: boolean
    forward?: number

    How far the line runs past the last point, in x: in categories on a category axis.

    intercept?: number

    The y the fit is held to at x = 0: a linear, exponential or polynomial fit.

    name?: string

    Its entry in the legend; when absent, the type and the series' name: Linear (Sales).

    order?: number

    A polynomial's order, 2 to 6.

    period?: number

    A moving average's period, in points.

    spPr?: ShapeProperties
    trendlineLbl?: TrendlineLabel
    trendlineType: "linear" | "exp" | "log" | "movingAvg" | "poly" | "power"
    unknown?: ChartModel.Unknown

    Settings
    Member Visibility

    On This Page
    Properties