XY scatter chart

[Guest]

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.

 

[Jon Peltier]

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

 

[Del Cotter]

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.