SheetXL - v1.0.2
    Preparing search index...

    Interface Group

    A chart group (c:barChart, c:lineChart…): series of one type that share one pair of axes and the options of the group.

    Which options a group may state depends on its type; the reader keeps whatever the file states. A group of a 2016 type states no options: its series' Series.layoutPr hold them.

    interface Group {
        axIds: number[];
        bandFmts?: BandFormat[];
        barDir?: "col" | "bar";
        bubble3D?: boolean;
        bubbleScale?: number;
        custom?: CustomGroup;
        custSplit?: number[];
        dLbls?: DataLabels;
        dropLines?: ChartLines;
        firstSliceAng?: number;
        gapDepth?: number;
        gapWidth?: number;
        grouping?: "stacked" | "clustered" | "percentStacked" | "standard";
        hiLowLines?: ChartLines;
        holeSize?: number;
        is3D?: boolean;
        marker?: boolean;
        ofPieType?: "pie" | "bar";
        overlap?: number;
        radarStyle?: "marker" | "filled" | "standard";
        scatterStyle?:
            | "none"
            | "line"
            | "marker"
            | "smooth"
            | "lineMarker"
            | "smoothMarker";
        secondPieSize?: number;
        series: Series[];
        serLines?: ChartLines[];
        shape?: BarShape;
        showNegBubbles?: boolean;
        sizeRepresents?: "w"
        | "area";
        smooth?: boolean;
        splitPos?: number;
        splitType?: "auto" | "val" | "percent" | "cust" | "pos";
        type: GroupType;
        unknown?: ChartModel.Unknown;
        upDownBars?: UpDownBars;
        varyColors?: boolean;
        wireframe?: boolean;
    }

    Hierarchy (View Summary)

    Index
    axIds bandFmts? barDir? bubble3D? bubbleScale? custom? custSplit? dLbls? dropLines? firstSliceAng? gapDepth? gapWidth? grouping? hiLowLines? holeSize? is3D? marker? ofPieType? overlap? radarStyle? scatterStyle? secondPieSize? series serLines? shape? showNegBubbles? sizeRepresents? smooth? splitPos? splitType? type unknown? upDownBars? varyColors? wireframe?
    axIds: number[]

    The axIds of the axes the group draws against: two, or three for a series axis. None for a pie, and none where a 2016 chart's series name none.

    bandFmts?: BandFormat[]

    A surface's formats of its value bands, by band (c:bandFmts).

    barDir?: "col" | "bar"
    bubble3D?: boolean
    bubbleScale?: number
    custom?: CustomGroup

    A custom group's kind and options; only on a custom group.

    custSplit?: number[]

    custSplit: the indexes of the points drawn in the second pie.

    dLbls?: DataLabels
    dropLines?: ChartLines
    firstSliceAng?: number
    gapDepth?: number
    gapWidth?: number
    grouping?: "stacked" | "clustered" | "percentStacked" | "standard"
    hiLowLines?: ChartLines
    holeSize?: number
    is3D?: boolean

    bar3DChart, line3DChart, area3DChart, pie3DChart, surface3DChart.

    marker?: boolean

    lineChart: whether the group's series show markers.

    ofPieType?: "pie" | "bar"
    overlap?: number
    radarStyle?: "marker" | "filled" | "standard"
    scatterStyle?:
        | "none"
        | "line"
        | "marker"
        | "smooth"
        | "lineMarker"
        | "smoothMarker"
    secondPieSize?: number
    series: Series[]
    serLines?: ChartLines[]
    shape?: BarShape
    showNegBubbles?: boolean
    sizeRepresents?: "w" | "area"
    smooth?: boolean
    splitPos?: number
    splitType?: "auto" | "val" | "percent" | "cust" | "pos"
    type: GroupType
    unknown?: ChartModel.Unknown
    upDownBars?: UpDownBars
    varyColors?: boolean
    wireframe?: boolean

    Settings
    Member Visibility

    On This Page
    Properties