Hi,

Yes you can use non contiguous range references.

This will plot the 6 points spread over rows 3 and 4. With category
labels in rows 1 and 2.

=SERIES(Sheet1!$A$3,(Sheet1!$B$1:$D$1,Sheet1!$B$2: $D$2),(Sheet1!$B$3:$D$3,Sheet1!$B$4:$D$4),1)

You will need to use the Source Data dialog, Series tab in order to
select and set the ranges.

Cheers
Andy


Rick wrote:
I have a chart containing several data series held in rows in a worksheet.
Before long the data will exceed the the full width of the worksheet.
Transposing the worksheet to be column based and, more particularly,
modifying the routines to import external data will be difficult. Is it
possible to put new data into another set of equivalent rows below the first
set in the worksheet and then to define each matching pair of rows as a
single continuous series in the worksheet?

--

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