Too much data

[Jaylynn]

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?

 

[teylyn]

Hi Jaylynn,

the easiest way to achieve this is probably to create a dedicated tabl
for just the data points you want to chart. So, in an area to the righ
of your data table, start with a formula like this

=INDEX(A:A,ROW()*5)

and copy down. This will get every 5th data point in column A. In th
next colum, go

=INDEX(B:B,ROW()*5)

etc.

Then create your chart off this newly constructed table.

regards, teylyn



Hi, this is my first time posting. I need to create a graph of tw
variables,

but I have way to many data points (over 32,000) If I wanted to selec say
every 5 data points and then use these to make a graph, how would I d

this?

 

[Misange]

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 :