I have 64,000 data points I'm trying to plot in an XY scatter plot. Column X
has a ranking number (1-64,000) and Column Y has a number. I've noticed that
you can only map 32,000 data points in a 2D chart. When I've tried to map
this it maps records 1-32,000. I've tried to add in records 32,001-64,000
and it maps it on top of records 1-32,000, even though it already has number
in Column X. And any time I try to modify the scatter plot the file crashes.
Any suggestions on how to map this? Oh, by the way, I'm using an old version
of Excel-2002.

Thanks!

If you don't add the X values as well as the Y values, Excel will use the
numbers 1, 2, 3, etc. as X values.

Copy the X and Y ranges together for the second batch of points, select the
chart, and use paste special to add the points as a new series.

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


"DataGeek" wrote in message
...
I have 64,000 data points I'm trying to plot in an XY scatter plot. Column
X
has a ranking number (1-64,000) and Column Y has a number. I've noticed
that
you can only map 32,000 data points in a 2D chart. When I've tried to map
this it maps records 1-32,000. I've tried to add in records 32,001-64,000
and it maps it on top of records 1-32,000, even though it already has
number
in Column X. And any time I try to modify the scatter plot the file
crashes.
Any suggestions on how to map this? Oh, by the way, I'm using an old
version
of Excel-2002.

Thanks!