Can a chart series (row-based) occupy more than one row

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?

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

That was quick.

I will try your suggestion but I wonder if updating the series definitions
for fifteen series every time I add a new set of data may prove a bit
laborious (I am assuming that the series definitions will then be too
complicated to allow a simple change of the overall data range for the
chart). I suspect that the one-off effort of converting the workbook & the
imports may be more appealing. But you have given me an alternative and the
choice is now mine. Many thanks & regards.

"Andy Pope" wrote:

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