An object that represents a specific series in a chart

Constructors

Section titled "Constructors"

Series

new Series(a: IChartObject): Series

Returns Series

Properties

Section titled "Properties"

$t

Section titled "$t" 
$t: Type

applyPicToEnd

Section titled "applyPicToEnd" 
applyPicToEnd: boolean

applyPicToFront

Section titled "applyPicToFront" 
applyPicToFront: boolean

applyPicToSides

Section titled "applyPicToSides" 
applyPicToSides: boolean

axisBinning

Section titled "axisBinning" 
axisBinning: CategoryAxisBinning

axisGroup

Section titled "axisGroup" 
axisGroup: AxisGroup

barShape

Section titled "barShape" 
barShape: BarShape

border

Section titled "border" 
border: ChartBorder

boxAndWhiskerSettings

Section titled "boxAndWhiskerSettings" 
boxAndWhiskerSettings: BoxAndWhiskerSettings

bubbleSizes

Section titled "bubbleSizes" 
bubbleSizes: SeriesValues

chartType

Section titled "chartType" 
chartType: ChartType

errorBars

Section titled "errorBars" 
errorBars: ErrorBars

explosion

Section titled "explosion" 
explosion: number

fill

Section titled "fill" 
fill: ChartFillBase

geographicMapSettings

Section titled "geographicMapSettings" 
geographicMapSettings: GeographicMapSettings

invertIfNegative

Section titled "invertIfNegative" 
invertIfNegative: boolean

leaderLines

Section titled "leaderLines" 
leaderLines: LeaderLines

line

Section titled "line" 
line: ChartLine

markerBorder

Section titled "markerBorder" 
markerBorder: ChartBorder

markerFill

Section titled "markerFill" 
markerFill: ChartFillBase

markerSize

Section titled "markerSize" 
markerSize: number

markerStyle

Section titled "markerStyle" 
markerStyle: MarkerStyle

name

Section titled "name" 
name: SeriesName

owningSeries

Section titled "owningSeries" 
owningSeries: Series

pictureType

Section titled "pictureType" 
pictureType: PictureType

pictureUnit

Section titled "pictureUnit" 
pictureUnit: number

plotOrder

Section titled "plotOrder" 
plotOrder: number

showDataLabels

Section titled "showDataLabels" 
showDataLabels: boolean

showWaterfallConnectorLines

Section titled "showWaterfallConnectorLines" 
showWaterfallConnectorLines: boolean

smooth

Section titled "smooth" 
smooth: boolean

type

Section titled "type" 
type: SeriesType

values

Section titled "values" 
values: SeriesValues

xValues

Section titled "xValues" 
xValues: XValues

Accessors

Section titled "Accessors"

barShapeResolved

Section titled "barShapeResolved"

Returns the resolved value of the [[barShape]] property.

get barShapeResolved(): BarShape

Returns BarShape

chart

Section titled "chart"

Inherited from: ChartObject

Returns the owning chart (read-only)

get chart(): WorksheetChart

Returns WorksheetChart

dataLabels

Section titled "dataLabels"

Returns a [[SeriesDataLabels]] instance which applies to all [[DataLabel]] instances which do not have a specific setting for a given property.

get dataLabels(): SeriesDataLabels

Returns SeriesDataLabels

owner

Section titled "owner"

Inherited from: ChartObject

returns this object's owner. (read-only) The owner or null if this object is owned directly by the Chart

get owner(): ChartObject

Returns ChartObject

sheet

Section titled "sheet"

Inherited from: ChartObject

The owning sheet (read-only)

get sheet(): Sheet

Returns Sheet

workbook

Section titled "workbook"

Inherited from: ChartObject

The owning workbook (read-only)

get workbook(): Workbook

Returns Workbook

worksheet

Section titled "worksheet"

Inherited from: ChartObject

The owning worksheet (read-only)

get worksheet(): Worksheet

Returns Worksheet

Methods

Section titled "Methods"

dataPointCollection

Section titled "dataPointCollection"

Returns the [[DataPoint]] instance at the specified ordinal position within this collection.

dataPointCollection(index: number): DataPoint

Parameters

  • index: number

    A zero based index

Returns DataPoint

trendlineCollection

Section titled "trendlineCollection"

Returns the [[Trendline]] instance at the specified ordinal position within the collection.

trendlineCollection(index: number): Trendline

Parameters

  • index: number

    A zero based index

Returns Trendline