View Single Post
  #2   Report Post  
Conrad Carlberg
 
Posts: n/a
Default

Hi Jeff,

As I read your post, it seems that the comparison you're after is entirely
feasible. But how do you want to decide whether new data sets are above or
below, Less Than or Greater Than a limit that's been set by your graph? On
the basis of a discrete point comparison? [e.g., Average(OldSet)
Average(NewSet)]? In that case, a chart/graph wouldn't be needed. On some
other basis? This sounds like an SPC application.

C^2
Conrad Carlberg

"Jeff C" wrote in message
...
I have worked some with MS Access, much less in Excel and really am not

very
math oriented but I need help. Not much on graphing in the Access Forum

but
several suggestions to use Excel because it is much more powerful in this
area. I have numerical test values on the Y axis matched with numerical
values representing age in hours on the X axis, plotting a line graph in
Access which represent a limit.

I need to compare new data sets on a daily basis with this line graph
identifying each set as either above or below, Less Than or Greater Than

the
limit set my this graph. Is there a formula or method available or that

can
be created or viewed in Excel?

Is this possible? Can someone point me to an example or maybe help walk

me
through? Thank You.