XY scatter chart
 

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.

XY scatter chart
 

An XY series can handle 32000 points, and an XY chart can handle 256000
total points. If you have 120k data points, you need to split your four
columns into eight (four plotted series), not combine them into two.

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


"Jan Eisensoe" <Jan wrote in message
...
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.

XY scatter chart
 

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.