more than 255 lines in chart

[michael]

Is there a work-around the 255-line limit in Excel ??

Transpose won't do the trick, as I need 22 columns of data.

Excel 2000 SP3, on Win XP Pro SP2.

Michael

 

[Jon Peltier]

Hi Michael -

That's a lot of series for a chart. Is it going to be legible with so many lines?
I've only ever seen one chart that really needed so many series; an experimental
meteorologist needed custom curves on a chart (non-cartesian lines, like isobars). I
was able to help him combine around a thousand of these curves into a few dozen.

If you describe why you need all the series, someone might think of a similar way to
reduce them.

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

 

[michael]

Hi Jon,

It's a golf-program, that has worked very well untill I exceeded the number
of data-rows allowed in Excel. In reality I only need maybe 15 rows of data.
But as my original intentions worked, I haven't thought of it, before now.

All my data are loaded to a sheet where I use AutoFilters via VB-script. So,
if I ask for a certain golf-course or player the filter responds "live" to
the request and updates graphs as well.

I can't get the source data to accept a variable - or I'm not clever enough,
and it has worked well, but now I may need data from row 1 and row 345, which
is impossible, because of the limitations in Excel.

Michael

 

[Jon Peltier]

Michael -

Could you instead use a series of checkboxes or dropdowns to select the plotted
data? Here are some examples:

http://peltiertech.com/Excel/Charts/ChartByControl.html

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

 

[michael]

Hi Jon,

Looks as if it's the right track !!

I have been deep in to your homepage - great stuff !! and found som links
to, amongst others "J-walk", who had a work-around/dynamic chart solution
using "offset" and I think that it might be possible to use the existing
combo/drop-down boxes I use now. Combined with extensive use of the
offset-command - I might even expand the data I/O to my graphs.

Thanks for helping!!

Michael

 

[SM1333]

I am hoping that someone can extend this help to me. The site did not help me
very much but maybe I am missing something. I have approximately 300 series
that I need to put onto a chart. The reason I need this is that I have 300
separate sets of data that work out on a line graph to 300 distinct lines,
and yes this is indeed visible and we can pull out the specific data lines we
want to highlight. The problem is, I can't graph this as a single series
because we have to use a range of columns for both the x and the y so I
cannot graph more than one row at a time. Any help on how I might get more
than 255 series?

Thanks

 

[Andy Pope]

Hi,

The 255 is a fixed limit.
You either use 2 charts overlayed with the top one having transparent
chart/plot area. Obviously alignment will be an issue.

Or you use 1 series with data from 2 rows and then if required change
the colouration of points in the series. This would probably require a
vba solution if you need any this that is suppose to be automatic.

Cheers
Andy