Does anyone know how I can get the area under the curve
for a graph I've created?

Hi Mike,

Check out Bernard's examples of how to implement Trapezoid and Simpson Rules
www.stfx.ca/people/bliengme/ExcelTips

Mike wrote:

> Does anyone know how I can get the area under the curve
> for a graph I've created?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Do you know the functional form of the curve? Many curves (for example
polynomials) can be analytically integrated after estiimating a few
parameters. Cubic splines approximates the chart line smoother in most
cases, and is easily integrated piecewise. David Braden has posted VBA
code for cubic splines

http://groups.google.com/groups?selm...chester.rr.com

Jerry

Mike wrote:

> Does anyone know how I can get the area under the curve
> for a graph I've created?