Hari -

A chart series in Excel is limited to 32,000 points, and total points in a
chart is limited to 256,000. There's no sense in trying to combine ranges
for charting when each of these ranges is already more than twice the
allowable number of points in a series.

Does it make sense to decimate the data, that is, plot every Nth point? Or
plot some kind of average function?

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

"Hari" wrote in message
oups.com...
Hi,

I have Residual output for Regression from SAS in CSV format.

I have to make a scatter plot between Residual and the Predicted
variable. Problem is that my original data set in SAS has close to 0.2
million rows, so I have 0.2 million rows of residual information.

I can open this data in Textpad and paste to excel 65536 rows at a
time.

So, in first copy-paste my dependent variable and residual would be
lets say in Columns E and F. In next copy-paste I can paste these 2
columns in K and L and subsequently in Q, R and then fianlly in W and
X.

I am aware of named functions in excel which can be used within charts
etc. what I want o know is whether I can create a named formula which
will be union of the ranges given above. (Am aware of the union
function within VBA, but do we have equivalent Non-VBA formula based
solution for this?).

Please guide me.

regards,
Hari
India

PS : Please note am not using excel for data management and the above
requirement is just for one-time "appraisal" of a model.