Help an Excel novice with a graph formula?
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.
|