Thread: Too much data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Misange Misange is offline
external usenet poster
 
Posts: 8
Default 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?