Managing Large Amounts of Data

O

OpAmp

Hello All,

I have a CSV file that is a collection of temperatures from several
different thermocouples. The values are measure every 30 seconds for close
to two days.

I am looking to create a graph using excel, but the amount of data
causes my computer slow down. Is there a function or some means were I can
create a graph from every fifth point or every tenth point?

Thanks
$. O.
 
S

ShaneDevenshire

Hi,

Here is a formula to extract every 5th element for a range

=INDEX($A$1:$A$10000,(ROW()-1)*5+1)

Just copy it down as needed. Then convert to values or not and plot.

You can also use the Sampling tool in the Data Analysis command (under Data
menu) if you have the Analysis ToolPak installed.

If this helps, please click the Yes button
 

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

Filter away rows of data 2
Excel 2003 freezing when changing a cell or adding new data 2
Selecting a subset of data from multi columns 1
Copying CSV-XLS, large amounts-different folders 1
Line Graph, Time vs Unit, with Data Points 4
Query returning data for every day of a period. 1
Differing Amounts of Data 1
Inserting rows slow on large report 6

Top