View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DataGeek DataGeek is offline
external usenet poster
 
Posts: 1
Default XY Scatter-problems with large data records

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!