Too much data
 

Hi, this is my first time posting. I need to create a graph of two variables,
but I have way to many data points (over 32,000) If I wanted to select say
every 5 data points and then use these to make a graph, how would I do this?

Too much data
 

If your data are in columns A and B, in C1 enter =mod(row(),5) and copy
this formula down.
then filter the colomns A B and C to keep only lines with 0 in column C
Only one data out of 5 will appear in your graph (which is still quite a
lot !)
Misange


Jaylynn a écrit :
Hi, this is my first time posting. I need to create a graph of two variables,
but I have way to many data points (over 32,000) If I wanted to select say
every 5 data points and then use these to make a graph, how would I do this?