SheetXL - v1.0.2
    Preparing search index...

    Interface Series

    c:ser. The fields a series may state depend on its group's type.

    interface Series {
        bubble3D?: boolean;
        bubbleSize?: DataSource;
        cat?: DataSource;
        color?: DataSource;
        cumulativeLine?: DerivedLine;
        dLbls?: DataLabels;
        entityId?: DataSource;
        errBars?: ErrorBars[];
        explosion?: number;
        extLst?: ExtensionList;
        hidden?: boolean;
        idx?: number;
        invertIfNegative?: boolean;
        layoutPr?: LayoutProperties;
        marker?: ChartModel.Marker;
        order?: number;
        points?: DataPoint[];
        shape?: BarShape;
        smooth?: boolean;
        spPr?: ShapeProperties;
        trendlines?: Trendline[];
        tx?: SeriesText;
        uniqueId?: string;
        unknown?: ChartModel.Unknown;
        val?: DataSource;
        xVal?: DataSource;
        yVal?: DataSource;
    }

    Hierarchy (View Summary)

    Index
    bubble3D? bubbleSize? cat? color? cumulativeLine? dLbls? entityId? errBars? explosion? extLst? hidden? idx? invertIfNegative? layoutPr? marker? order? points? shape? smooth? spPr? trendlines? tx? uniqueId? unknown? val? xVal? yVal?
    bubble3D?: boolean
    bubbleSize?: DataSource

    Sizes: a bubble's, or a treemap's or sunburst's tile.

    cat?: DataSource

    Categories: the labels of the points, in as many levels as the range has.

    color?: DataSource

    What a region map colors each region by: values (numRef) or text (strRef).

    cumulativeLine?: DerivedLine

    A line of the series' running total, as a percentage of its sum, over its points in the order drawn, against axes of its own (axIds): the line of a pareto chart.

    dLbls?: DataLabels
    entityId?: DataSource

    The ids that name a region map's regions.

    errBars?: ErrorBars[]

    How uncertain the series' values are, as a bar about each point: one, or a scatter's x and y.

    explosion?: number
    extLst?: ExtensionList
    hidden?: boolean

    A series of a 2016 chart that is not drawn.

    idx?: number

    Picks the series' automatic color and marker. Numbered across the whole chart; a classic chart's series always state it.

    invertIfNegative?: boolean
    layoutPr?: LayoutProperties

    How a 2016 chart's series turns its values into what is drawn: binning, totals, statistics…

    marker?: ChartModel.Marker
    order?: number

    The order the series is plotted, listed and stacked in. Numbered across the whole chart; a classic chart's series always state it, and a 2016 chart's are in the order listed.

    points?: DataPoint[]
    shape?: BarShape
    smooth?: boolean
    spPr?: ShapeProperties
    trendlines?: Trendline[]

    Lines fitted to the series' points, or their moving average.

    tx?: SeriesText
    uniqueId?: string

    What identifies the series to the application that wrote it.

    unknown?: ChartModel.Unknown
    val?: DataSource
    xVal?: DataSource
    yVal?: DataSource

    Settings
    Member Visibility

    On This Page
    Properties