Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Managing Large Amounts of Data
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Managing Large Amounts of Data
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 -- Thanks, Shane Devenshire "OpAmp" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems copying Large Amounts of Data in Excel 2007 | Excel Discussion (Misc queries) | |||
Problems with working out averages with large amounts of data | Excel Worksheet Functions | |||
Doing Analysis from large amounts of DATA | New Users to Excel | |||
Conditional summing with large amounts of data | Excel Worksheet Functions | |||
Help with large amounts of data and formulas | Excel Worksheet Functions |