Get 32000 point limit error when only plotting 1700 points

[thetraderman]

Hi,

I am hoping someone will help me as I've been working on this issue for a few days and still can't figure it out. The problem is I have two arrays that cycle through a spreadsheet that had 117000 rows and 3 columns. I'm reading those rows and taking certain pieces of data which turns out to be around 1700 data points. These are decimal numbers which can be up to 4 decimal places. When I go to plot the data I get an error that I'm excedding the 32K limit eventhough I verified that the final arrays I'm plotting has only 1700 points. The weird thing is if I delete the worksheet that contains the data, the plot shows the up properly.

Below is the function call. Any help would be appreciated!

Please Login or Register  to view this content.

[thetraderman]

Well, I figured a way around it but it is kind of a kluge so perhaps this is a hint as to what is going on. Right before I call the Charts.Add code I added the following:

Please Login or Register  to view this content.

I created a "temp" worksheet and put a zero in the first cell. This took focus away from the working sheet where I was collecting data. It seems even though the series is using the new array it somehow gets attached to the working worksheet which has the 117K cells. That throws everything off. Very weird!