Maximum number of data series

[Sonya]

Maximum number of data series is 255 in Excel. I am using
Excel 97.
Is there a way to go around that? I have more than 255
series and I want them to be on one graph?
Thanks,
Sonya

 

[Andy Pope]

Hi Sonya,

It maybe possible to work round it but it would require more information
about your data and what you are trying to graph.

Maximum number of data series is 255 in Excel. I am using
Excel 97.
Is there a way to go around that? I have more than 255
series and I want them to be on one graph?
Thanks,
Sonya

--

Cheers
Andy

http://www.andypope.info

 

[Sonya]

Andy,
I have 1400 series (item numbers). Each series contains data for past three years.
Item_no J-01 F-01 M-01.... O-03
XX1 1 o 5 o
XX2 5 3 9 4
XX..
XX1400 5 6 3 1
This is the layout. I hope this will help you to undersatand my situation.
So, you are saying that it's possible to have more than 255 series on the chart. How??
Thanks,
Sonya

 

[Andy Pope]

Hi Sonya,

No it's not possible to change the limit. I said 'possible to work
around it'.

What type of chart is this?
How do you see the user identifying the data series XX1 in your chart?

Andy,
I have 1400 series (item numbers). Each series contains data for past three years.
Item_no J-01 F-01 M-01.... O-03
XX1 1 o 5 o
XX2 5 3 9 4
XX..
XX1400 5 6 3 1
This is the layout. I hope this will help you to undersatand my situation.
So, you are saying that it's possible to have more than 255 series on the chart. How??
Thanks,
Sonya

--

Cheers
Andy

http://www.andypope.info

 

[Bernard V Liengme]

Sonya,
Have you thought what a chart with 255 plus data series would look like?
I think I would rather eye-ball the raw data!
Bernard

 

[Jon Peltier]

Bernard -

Good point. I was going to say, 255 series is about 20 times too many!
The most series I've had in an effective chart is around 15, maybe
more if you include all my dummy series.

- Jon