SERIES

Defines the data source settings for a chart series.

Syntax

=SERIES(SeriesTitle, CategoriesOrXValues, YValues, RadiusOrColorValues)

Arguments

NameDescription
SeriesTitleSeries title to name the series. This title will be used for the legend.
CategoriesOrXValuesValues to use for the chart categories or X- Values, if it is a Scatter or Bubble Chart.
YValuesValues to use for the display of bars, pies, lines etc.
RadiusOrColorValuesValues to use for the radius of bubble charts and for colors in state charts.

Return Value

TRUE.

Example

FunctionResultComment
=SERIES("DataRow", A1:A5, B1:B5)TRUERetrieves values for a chart series for the series for X-Values from cell range A1:A5 and for Y-Values from B1:B5.