Adds a trendline to the series, as Excel adds one: a dotted 1.5 pt line in the series' color, with no label. A polynomial is of order 2 and a moving average of period 2 until set.
Optionaltype: TrendlineType
The fit; linear by default.
Optionaloptions: ITransaction.OperationOptionsRemoves the series from the chart, and its group when it was the group's last.
Optionaloptions: ITransaction.OperationOptionsReturns the axes the series is plotted against; a pie's are 'primary'.
Returns the size of a bubble chart's largest bubble, 0 to 300 percent of Excel's default, or
null for a series that is not a bubble's.
Returns whether a bubble's size is its area's or its width's, or null for a series that is not
a bubble's.
Returns the formula for a bubble series' sizes, or null if the series states none.
Returns the formula for the categories the values are plotted against — the x values of a
scatter or bubble series — or null if the series states none.
Returns the cells getCategoriesFormula names, or null.
getValuesRange for when there are none to return.
Returns the chart the element is part of.
Returns the series' trendline at index, from 0, or null where it has none there.
Returns how the series is drawn, by the names of IChart.Type. The same as IChart.getChartType except in a combo, or where series of one group differ in markers.
Returns the series' data labels.
Returns one dimension of the series as drawn, each point as text (Office Scripts'
getDimensionValues): the categories, the values, a scatter's x or y values, or a bubble's
sizes.
Returns what the element is. A series' marker and a point's are both 'marker', and the
major and minor gridlines both 'gridlines'; their paths tell them apart.
Returns how far a pie's or doughnut's slices are pulled out, as a percentage of the radius; 0 for not at all.
Returns the series as Excel's SERIES formula: =SERIES(name, categories, values, order),
a bubble's with its sizes fifth. Each part is a reference, a literal ("Total", {1,2,3}),
or empty.
Returns the gap between clusters of bars, as a percentage of a bar's width; on a line or stock
series, the gap between its group's up/down bars; on a pie of pie or bar of pie, the gap between
its two plots, as a percentage of the second plot's size. null for another series, and for a
line or stock series whose group shows no up/down bars.
Returns whether a bar's or bubble's negative points are drawn in the inverse of its fill.
Returns the formula naming the series — Sales!$C$3 — or null when the name is written
into the chart, or there is none.
Returns the cells getNameFormula names, or null.
getValuesRange for when there are none to return.
Returns how far bars of one cluster overlap, -100 to 100 percent of a bar's width, or null
for a series that is not a bar.
Returns the element this one is part of: a point's series, a gridline's axis, a legend entry's legend. The parts at the top (the title, the legend, the plot area, an axis, a series, a group) are the chart area's; the chart area has none.
Returns where the element is in its chart, as IChart.getElement takes it.
A path is its parts' names joined by /, and does not change while the part is there:
chartArea, title, legend, legend/entries/<n>, plotArea, dataTable, and
dataLabels (every series' at once);axes/<primary|secondary>/<category|value|series>, and an axis's …/title,
…/majorGridlines and …/minorGridlines;series/<key>, and a series' …/marker, …/dataLabels, …/errorBars/<x|y>,
…/trendlines/<n>, …/trendlines/<n>/label, …/points/<n>, …/points/<n>/marker and
…/points/<n>/dataLabel;groups/<n>, and a group's …/upDownBars, …/hiLoLines, …/dropLines and …/seriesLines.A series' key is its index in the file (c:idx), which an edit does not change; its place in
the plot order can change. A point, a trendline, a legend entry and a group are named by their
place, from 0: when one before it is removed, the path names the one that took its place.
Returns the series' place in the plot order, from 0.
Returns the size of a pie of pie's or bar of pie's second plot, as a percentage of the first
pie's, or null for another series.
Returns whether a bubble chart draws a bubble for a negative size, as large as its magnitude, or
null for a series that is not a bubble's.
Returns whether a line or scatter series is drawn as a curve through its points.
Returns how a pie of pie or bar of pie chooses the points of its second plot, or null for
another series. Excel's automatic split, the last third of the points, reads as by position.
Returns what a pie of pie or bar of pie splits its points by: how many of the last go to the
second plot, or the value or percentage of the total below which they do. null for a split by
hand, and for another series.
Returns what the series is drawn with: the fill of its bars, areas or slices and its line.
Returns the series' trendlines, in the order the legend lists them.
Returns the up/down bars of the series' group: a line or stock chart's. Their setters throw
ExpectedError on another series.
Returns the cells getValuesFormula names.
null when the formula is not one plain reference into this workbook: an array
literal, a defined name, several areas, another workbook, or #REF!.
Returns whether the series' group colors each point differently, as a pie does.
Returns the error bars of the series' x values: a scatter's or bubble's only. Their setters
throw ExpectedError on another series.
Returns the error bars of the series' values: along the value axis.
Returns true if the series is plotted against the secondary axes.
Moves the series to the primary or secondary axes, keeping how it is drawn. The secondary axes are made when the first series moves to them, and removed with the last.
Optionaloptions: ITransaction.OperationOptionsSets the size of a bubble chart's largest bubble, 0 to 300 percent of Excel's default, for the series' whole group. The bubbles pad the axes in proportion.
Optionaloptions: ITransaction.OperationOptionsSets whether a bubble's size is its area's or its width's, for the series' whole group.
Optionaloptions: ITransaction.OperationOptionsSets a bubble series' sizes, as cells, a formula naming them, or an array.
Optionaloptions: ITransaction.OperationOptionsDraws the series as another type, moving it to the group of that type, as Excel does: on its own axes where the type can share them, else on the other pair or new secondary axes. The series is drawn in its own color as a new series of the type is.
Optionaloptions: ITransaction.OperationOptionsBubble and 3-D types turn every series of the chart into that type. A stock chart's series given another type leaves the stock group, on the other axes.
ExpectedError for a stock type, which Excel gives no series, and for a 3-D form, a surface or a 2016 type, which take the whole chart (IChart.setChartType).
Pulls a pie's or doughnut's slices out by a percentage of the radius; 0 puts them back.
Optionaloptions: ITransaction.OperationOptionsSets the series from a SERIES formula (VBA's Series.Formula): its name, categories,
values, place in the plot order (from 1) and, for a bubble, its sizes.
Optionaloptions: ITransaction.OperationOptionsSets the gap between clusters of bars, 0 to 500, for the series' whole group; on a line or stock series, the gap between its group's up/down bars; on a pie of pie or bar of pie, the gap between its plots.
Optionaloptions: ITransaction.OperationOptionsExpectedError on a series that is not a bar or an of-pie, and on a line or stock series whose group shows no up/down bars (see IChart.IUpDownBars.setGapWidth).
Sets whether a bar's or bubble's negative points are drawn in the inverse of its fill.
Optionaloptions: ITransaction.OperationOptionsSets the series' name: text, a cell, or a formula naming one (=Sales!$C$3); null for none,
which shows as Series1.
Optionaloptions: ITransaction.OperationOptionsSets how far bars of one cluster overlap, for the series' whole group.
Optionaloptions: ITransaction.OperationOptionsMoves the series to a place in the plot order, from 0: the order it is listed, stacked and drawn in. Its group's series are relisted in that order.
Optionaloptions: ITransaction.OperationOptionsPuts these points, by index, in a pie of pie's or bar of pie's second plot and the others in the first: a split by hand.
Optionaloptions: ITransaction.OperationOptionsSets the size of a pie of pie's or bar of pie's second plot, 5 to 200 percent of the first pie's.
Optionaloptions: ITransaction.OperationOptionsSets whether a bubble chart draws a bubble for a negative size, for the series' whole group.
Optionaloptions: ITransaction.OperationOptionsSets whether a line or scatter series is drawn as a curve.
Optionaloptions: ITransaction.OperationOptionsSets how a pie of pie or bar of pie chooses the points of its second plot. As in Excel, a split by value starts from a value of 1, and one by position or by hand from the points the second plot has now.
Optionaloptions: ITransaction.OperationOptionsSets what a pie of pie or bar of pie splits its points by; on Excel's automatic split, it becomes a split by position.
Optionaloptions: ITransaction.OperationOptionsSets the values the series plots: cells, a formula naming them, or an array ({1,2,3}).
Optionaloptions: ITransaction.OperationOptionsSets whether the series' group colors each point differently. A single series given it takes a point per value in the chart's colors, as Excel does; a pie denied it is drawn in one color.
Optionaloptions: ITransaction.OperationOptionsSets the categories the values are plotted against — a scatter or bubble series' x values —
as cells, a formula naming them, or an array; null for none, which plots against 1, 2, 3…
Optionaloptions: ITransaction.OperationOptionsSets several properties of the series at once, as one step to undo.
Optionaloptions: ITransaction.OperationOptions
One series of a chart: what it is called and the cells it plots.
Remarks
Each part of a series is stated as a formula —
Sales!$C$4:$C$15— the way the file and a chart's own dialog state it. The formula is the contract: it is what can say#REF!, name a defined name, or point at another workbook. Theget…Rangeforms resolve the plain case.