Graham -

You can leave a blank row between subseries in a series' data range, and
the connecting line will not be drawn. This must be a real blank, not a
formula returning "" or NA() or anything else, because even "" in a cell
means it isn't blank, it contains a short text string.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Graham Wideman wrote:

Well -- that was interesting! I finally blundered into this NG, only to
discover that I had already posted here... inadvertantly as a result of
logging a suggested improvement to Excel Chart... as noted by JE. Talk about
an unclear UI on *that* process!

Jon:

Nice to hear from you... I have gained much from your very informative
pages. And yes, after stewing about this for some days it did occur to me to
use fewer Chart Series and use subgroups of points to form the many "actual"
series that I need.

FWIW, as a proportion of all charts drawn, these may not be the most
numerous, however there *is* a need for many many series to plot raw data in
experiments where one has a respectable number of subjects (ie: over 255 :-)
and repeated measures (each subject has multi points).

The natural fit is to have one subject = one Chart Series. This way
attributes of the Series can represent attributes of the subject, such as
Series name = subject Id, Series formatting used for subject attributes etc.

Doing as you suggest is not *too* bad, but requires a bunch more programming
to set formatting on Points, and other housekeeping to turn off connecting
lines between last point of subject N and first point of subject N+1.

Anyhow, you'll likely be hearing more from me on this subject, but right now
I have to post another question on Chart trendline formatting...

Thanks again,

Graham