Work Around For Excel Chart Max Series Collection Limit of 255

[Rasm]

Does anybody know - how you can work around the limit of maximum 255 (might be 254 actually-think the error comes up when I try .addnewseries and have 254 collections already) SeriesCollections on a single chart.

Maybe I am just SOL

[Excel Fox]

Rasm,

MS doesn't support more than 255 (Yes, it is 255, not 254) series collection in a chart.

By a work around, I assume you are looking for an alternative to display your data on the chart. Now that, since MS has the series collection limited to 255, depends on what kind of chart you are using. For charts like Bar, Line etc, one way to have a graphical representation would be to layout multiple charts in series based on the orientation that you require. Have a look at the attachment, and see if you can configure something like this, if at all it suffices your need.

[Jon_Peltier]

Why do you need so many series in your chart? Most useful charts have at most a dozen or so series. More than that would make a chart too cluttered.

[Rasm]

I am charting absorbance spectra - each spectrum having anywhere from 100-1000 points per series. These are preprocessed - i.e. derivatized or some sort of scatter correction - so they all cluster together very much - if they are part of the population. But I am actually looking for the ones that dont follow the pattern or region of the spectrum where I have more signal variation - the differences are amplified up very much by using various pre-processing of the data. I agree - it is a bit of a mess - but seeing it visually is very useful. Thanks for the reply - not what I wanted to hear - but suspected that.

[Rasm]

Jon - btw - check out how I chart Histograms (see upload section) - I think you have to change the .ChartType in the code - but it is all there - just remmed out - I call them curve histograms - these are very cool when you evaluate process data - it essentially allow you to have a bunch of histograms overlayed - without clutter - the number of bins in effect determines how much smoothing goes into the Histogram. I think you are right into displaying process data - anyway take a look.