View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
James Silverton[_2_] James Silverton[_2_] is offline
external usenet poster
 
Posts: 115
Default area betwen 2 graphs

Travis wrote on Wed, 16 Jan 2008 13:06:01 -0800:

T "Jon Peltier" wrote:

?? You could use this technique from Bernard Liengme's web
site:
??
??
http://people.stfx.ca/bliengme/Excel...UnderCurve.htm
??
?? Calculate both areas, then subtract.
??
?? - Jon
?? -------
\ ?? Is there a way to get excel to calculate the area
between
?? 2 graphs?

T The problem is that the graphs are not curves, and are not
friendly toward
T formulas being applied. They are very irregular in shape.

You could readily set up something as simple as Simpson's rule
for each graph.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not