SERIES.Y

Macro Sheets Only

Equivalent to the Name and Values tab in the Format Data Series dialog box. Specifies the name and values for a data series.

Syntax

SERIES.Y(name_ref, y_ref)

Name_ref is text or an external reference in the form of text specifying the name for the data series that appears in the legend for the chart.

Y_ref is an external reference in the form of text specifying the range containing the values for the data series.

Related Functions

SERIES.X Specifies the category labels (x values) for a data series