dataLabels | ChartDataLabels | read-only |
format | ChartSeriesFormat | read-only |
index | number | read-only |
points | ChartPointsCollection | read-only |
trendlines | ChartTrendlineCollection | read-only |
xErrorBars | ChartErrorBars | read-only |
yErrorBars | ChartErrorBars | read-only |
axisGroup | ”Primary” | “Secondary” | |
bubbleScale | number | Bubble plots: bubble size as a percent of the default (0–300); plot-wide. |
bubbleSizes | (number | null)[] | undefined | Extension: a bubble series’ sizes, one per point; undefined for other families. Excel sets them from a range (setBubbleSizes). |
categories | (string | null)[] | Category labels from the cache; null is a blank cell. |
chartType | string | Excel.ChartType name this series paints as: “ColumnStacked”, “LineMarkers”, … |
color | string | undefined | The color the series PAINTS as, canonical #RRGGBB: an area kind’s fill or a stroke kind’s line color — explicit c:spPr when present, else the theme accent the automatic cycle gives this series’ position. Writing pins an explicit color (a line’s separately-styled markers keep theirs). Pie-family charts color per slice and refuse this property. |
doughnutHoleSize | number | Doughnut plots: hole diameter, percent (10–90). |
explosion | number | Pie and doughnut series: how far slices pull out, percent of the radius. |
firstSliceAngle | number | Pie and doughnut plots: angle of the first slice, degrees clockwise from 12 o’clock. |
gapWidth | number | Bar plots: space between clusters, percent of a bar width; pie of pie: space between the two plots (0–500). |
hasDataLabels | boolean | On shows values; off hides this series’ labels even when the plot shows them. |
invertColor | string | The fill of a negative point when invertIfNegative is on; "" when none is set. |
invertIfNegative | boolean | Bar series: negative bars paint inverted. |
markerBackgroundColor | string | undefined | Marker fill, #RRGGBB; undefined is automatic. |
markerForegroundColor | string | undefined | Marker outline, #RRGGBB; undefined is automatic. |
markerSize | number | undefined | Marker size in points (2–72); undefined is automatic. |
markerStyle | ChartMarkerStyle | |
name | string | undefined | A typed name replaces a reference to a cell, as in Excel. |
onSecondaryAxis | boolean | True when this series’ plot is wired to a secondary value axis (a combo chart’s % line, typically). addSeries clones the plot’s wiring, so a series added to such a plot scales against that axis, not the primary. |
overlap | number | Bar plots: overlap of bars in a cluster, percent (-100–100). |
plotKind | string | read-only c:*Chart family this series is plotted as: bar, line, pie, … |
plotOrder | number | The position the series plots at in its chart group. |
secondPlotSize | number | Pie of pie and bar of pie: second plot size, percent of the primary pie (5–200). |
showConnectorLines | boolean | Only a waterfall series has connector lines. |
showLeaderLines | boolean | The series’ data labels’ showLeaderLines. |
showShadow | boolean | Whether the series casts an outer shadow. |
smooth | boolean | Line and scatter series: a smoothed curve. |
splitType | ”SplitByPosition” | “SplitByValue” | “SplitByPercentValue” | “SplitByCustomSplit” | undefined | Pie of pie and bar of pie: how points move to the second plot; undefined while Word picks the split. |
splitValue | number | undefined | Pie of pie and bar of pie: the split threshold (a point count, value or percent, by splitType). |
values | (number | null)[] | Cached numeric values; null is a blank cell (not a zero). Scatter/bubble y values. |
varyByCategories | boolean | One colour per point (c:varyColors); plot-wide. |
xValues | (number | null)[] | undefined | A scatter/bubble series’ numeric x values; undefined for category families (and for text-cached x values, plotted 1..N like categories). Category families refuse writes by name. |