On Sat, 23 Jun 2007, in microsoft.public.excel.charting,
Jan Eisensoe said:

Have to represent large amount of data in XY scatter. The data consist of
120.000 data lines (x) with one corresponding Y value. Therefore the data is
represented in two lots of two columns. Now I have two problems. 1. How do I
combine one set of columns with the other and 2. the XY chart does not appear
to be able to handle this much data.

"Combine" them by formatting all series to look the same. As Jon says,
you need four series, as the XY chart can only handle 32,000 points per
series.

Hope you're printing that on a big sheet of paper, so the result is real
information, and not just a waste of ink. I recommend a light colour.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.