Equivalent to the X Values tab in the Format Data Series dialog box. Specifies the category labels (x values) for a data series. This function is for compatibility with Microsoft Excel versions earlier than Microsoft Excel 97.
Syntax
SERIES.X(x_ref)
X-ref is an external reference in the form of text specifying the range containing the category labels (or x values for a scatter (xy) chart) you want to use.
Related Function
SERIES.Y Specifies the name and values for a data series
Return to index