Results 1 to 5 of 5

Thread: Work Around For Excel Chart Max Series Collection Limit of 255

  1. #1
    Senior Member
    Join Date
    Apr 2011
    Posts
    190
    Rep Power
    14

    Work Around For Excel Chart Max Series Collection Limit of 255

    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

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10

    Work Around For Excel Chart Max Series Collection Limit of 255

    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.
    Attached Files Attached Files

  3. #3
    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.

  4. #4
    Senior Member
    Join Date
    Apr 2011
    Posts
    190
    Rep Power
    14
    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.
    xl2007 - Windows 7
    xl hates the 255 number

  5. #5
    Senior Member
    Join Date
    Apr 2011
    Posts
    190
    Rep Power
    14
    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.
    xl2007 - Windows 7
    xl hates the 255 number

Similar Threads

  1. Replies: 4
    Last Post: 06-10-2013, 01:27 PM
  2. Replies: 4
    Last Post: 08-14-2012, 03:17 AM
  3. Replies: 10
    Last Post: 04-07-2012, 05:33 AM
  4. Graphing a bell curve from an Excel data series
    By larryt1940 in forum Excel Help
    Replies: 2
    Last Post: 01-24-2012, 06:08 AM
  5. Color Chart Series VBA
    By Admin in forum Download Center
    Replies: 0
    Last Post: 04-29-2011, 11:26 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •