|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 20th, 2010, 07:24 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
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? 
|
|
#2
February 21st, 2010, 09:51 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
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?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
