Any limit on X-Y scatter plots

[sparanj]

I wanted to make an X-Y plot. I have 4242 pairs of points in two columns. If I only plot 2100 points, the X-Y scatter plot works correctly in excel. If I choose any more than 2100 points, scatter plot seems to revert to a line plot and plots the Y column against a point pair number instead of an X-Y plot. Is there a limit on # of points one can have for an X-Y plot ? How do I get around it to plot all 4242 points ?

 

[PaddyD]

Max number of points for a data series in a 2D chart is 32,000. i cannot replicate your problem.

 

[sparanj]

Thanks for your reply. I played around a bit more, knowing that I am nowhere close to 32000 points. I found out that some of the cells had bad data (text instead of numbers). When I deleted those with a global replace, the XY plot came back. When I was choosing 2100 points it was working as there was no bad data in the range selected. I did 2150 onwards and it did not work as that was where the text entries were.

 

[PaddyD]

glad you got it sorted.