View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Extracting useful info from test data

Hi
not quite sure but try creating a pivot table based on your source data
and create a pivot chart. See

http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html

--
Regards
Frank Kabel
Frankfurt, Germany


Hi everyone,

I'm doing a considerable amount of mechanical testing for my graduate
work, and am having a heck of a time sorting through the data to get
meaningful results. I have about 10,000 data points, which represent
about 400 cycles of tests. I want to extract the cycle number, and
plot the minimum and maximum loads encountered in each cycle with
respect to the cycle number. Can anyone give me a hand? Thanks in
advance, Tony


---
Message posted from http://www.ExcelForum.com/