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
SM1333 wrote:
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
" wrote:
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
"Jon Peltier" wrote:
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/
_______
wrote:
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" wrote:
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/
_______
wrote:
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
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info