Hi,
The series formula has a limit of ~1024 characters. When using non
contiguous cells as data source it is easy to exceed this limit.
The following demonstrates how the length of the series formula can
rapid expand.
10 contiguous cells,
=SERIES(,,Sheet1!$A$1:$A$10,1)
10 non-contiguous cells,
=SERIES(,,(Sheet1!$A$1,Sheet1!$A$3,Sheet1!$A$5,Sheet1!$A$7,Sheet1!$A$9,Sheet1!$A$11,Sheet1!$A$13,Sheet1!$A$15,Sheet1!$A$17,Sheet1!$A$19),1)
You need to create a contiguous block, using formula, for the data to be
charted.
Cheers
Andy
> I have a simple chart set up that references data points which are
> vertically ten spaces apart. The chart has worked fine for months.
[quoted text clipped - 9 lines]
>
> Thanks.

Signature
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info