SERIES

Defines the data source settings for a chart series.

Syntax

=SERIES(SeriesTitle, CategoriesOrXValues, YValues, RadiusOrColorValues)

Arguments

Name

Description

SeriesTitle

Series title to name the series. This title will be used for the legend.

CategoriesOrXValues

Values to use for the chart categories or X- Values, if it is a Scatter or Bubble Chart.

YValues

Values to use for the display of bars, pies, lines etc.

RadiusOrColorValues

Values to use for the radius of bubble charts and for colors in state charts.

Return Value

TRUE.

Example

Function

Result

Comment

=SERIES(“DataRow”, A1:A5, B1:B5)

TRUE

Retrieves values for a chart series for the series for X-Values from cell range A1:A5 and for Y-Values from B1:B5.