Microsoft KB Archive/62510

{| = Excel 1.00-1.50: Series Name Must Be Text String in SERIES =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q62510

SUMMARY
The Series Name argument in the SERIES formula of a chart cannot be represented as a reference or defined name in versions of Microsoft Excel earlier than 2.20.

The Series Name argument must be a text string represented as &quot;text&quot;.

For example, the following SERIES formula is not accepted by versions 1.50 and earlier of Excel (but is acceptable in Excel 2.20):

=SERIES(Worksheet1!$A$1,,Worksheet1!$A$2:$A$5,1) However, the text string &quot;Bob's Series&quot; is accepted in the following SERIES formula: =SERIES(&quot;Bob's Series&quot;,,Worksheet1!$A$1:$A$5,1) For more information on the SERIES formula, see Chapter 7, &quot;Creating a Chart,&quot; in the &quot;Microsoft Excel User's Guide&quot; versions 1.0 and 1.5 manual.
 * }