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
--
---------------------------------------------------
Graham Wideman
Microsoft Visio MVP
---------------------------------------------------
Book/Tools:
Visio 2003 Developer's Survival Pack
Resources for programmable diagramming at:
http://www.diagramantics.com
"Jon Peltier" wrote in message
...
Graham -
I have only once ever seen a chart with 255 series that was the least bit
legible, and I fixed that one by helping the chart author combine many
series with few points each into fewer series with many points. Is that an
alternative for you? Since you mention a macro, perhaps you could format
points different differently (not all points in a series need be the
same).
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/