Too much data

J

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?
 
M

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 :
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Graph Line Width ? 1
Adding Additional Points to a Line Chart 7
32,000 Data Points? 7
Warning message on "number of data points" 7
How to reorder data points on a graph? 1
XY scatter plot with more than 32000 rows in Excel 2003 0
Locking object to data points 2
create hourly graph from half hour data 0

Top