Charts with >254 data series 2

[Mccoy]

Hi all, my goal would be to paste numbers from a data table produced by another standalone software.
I'd like to plot a chart with at least 1000 columns (data series) and 128 rows. As far as I've seen and read, Excel can't do that, being limited to 254, or 255 data columns.
Is there a way around that? Data series are realizations of a random process, so I really need to see the Whole data cloud. Any specific plot type which serves the purpose would be all right, but I cannot find a way around this. I'm attaching an example. I'm using Excel 2013.
The example is the random process of an acceleration response spectrum (site dynamic response of a soil column). Each series (column) is a single realization, or statistically plausible representation, of the process (simply put: a single output of the Monte Carlo simulation). Here I pasted only 211 columns, I'd like to reach at lest 1000.

 

[IDS]

That's a very nice spreadsheet, but it's not really useful for the example in question because the X data needs to be in ascending order for the zoom and scroll to work, and also it doesn't provide any control on the Y range.

There is no built-in way to link XY chart axis limits to values on the spreadsheet, but the attached file provides a UDF that will do the job. For background on how it works, see:

http://newtonexcelbach.wordpress.com/2010/04/28/automating-chart-scale-limits/

and

http://newtonexcelbach.wordpress.com/2012/11/25/automating-chart-scale-limits-update/

Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/