Equivalent to the Name and Values tab in the Format Data Series dialog box. Specifies the name and values for a data series. This function is for compatibility with Microsoft Excel versions earlier than Microsoft Excel 97.
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 Function
SERIES.X Specifies the category labels (x values) for a data series
Return to index