Thread: Drawing a graph from a large volume of unusual data
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Evan
 
Posts: n/a
Default Drawing a graph from a large volume of unusual data
Another possibility - use the OFFSET function with a row offset of 2*ROW()-n.
Here n depends on which varible you want and were your data is.

"mems555" wrote:

How can i draw a gragh from data that is in the following format

LOAD 1
Displacement 0.001
LOAD 5
Displacement 0.012
LOAD 7
Displacement 0.015
etc
etc
etc

Reply With QuoteReply With Quote