Resampling to reduce data size(how?)

[ScanMan]

My first post-- I recieve 1-d plots and import them to excel from an ascii format. The data is 64000 points for both x and y(two columns). Excel cannot plot this. Is there a way to resample the data to a much smaller data set, say 1/10th the size? Sorry if this is a common question, but i couldn't find help with the keywords, "resample, averaging, data resizing, etc..." on this site or from excel's help. Thanks a lot! I know this is postponing my attempt at Matlab, but i really like the graphing ability of excel better.
ScanMan

 

[Mark W.]

You could sample the data using an Advanced AutoFilter with a computed Critiera using the expression....

=RAND()<=0.1

Or, since there's a 32,000 point limitation on data series for 2-D charts you could plot the 1st half of your data as one series and the remainder as another on the same chart (XY, I presume), and then set the data marker attributes so that it appears to be 1 set.

 

[ScanMan]

Resampling data set

Thanks so much,

Although splitting the 64000 point set into two separate sets would allow me to see the entire plot, I am dealing with 20 such plots on the same graph, so simply waiting for it to render took time. What I did was a ten point averaging to an adjacent column, then used filtering to get rid of the blanks. I copied the 6400 point set to another sheet and graphed from there. This did the job nicely. Thanks for the advice!

ScanMan