Graph

[Paul McG]

I have a graph in excel and I am required to find the
area below the line of the graph. Usually I would add a
trendline and the integrate the function to find the
area, however the graph is fairly complex and I was
wondering if there was a magic tool within excel that
will do this for me.

 

[Tushar Mehta]

Check

the cubic spline based code posted by David Braden
(http://groups.google.com/groups?selm=3A11AD33.B1438202%
40rochester.rr.com)

the Trapezoid or Simpsons 1/3 rule documented by Bernard Liengme at
http://www.stfx.ca/people/bliengme/ExcelTips/AreaUnderCurve.htm

Might also be worthwhile to check http://xlrotor.com/Excel_Stuff.htm

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Bernard Liengme]

Hi Paul,
Send me the file - the temp here is minus 30C and I have no intention of
going anywhere tomorrow! Lots of time to mess around.
(US readers can use =CONVERT(-30,"C","F") to get a value on their scale.

 

[Jon Peltier]

Or they can use my industrial strength (I use it at work) temperature
conversion utility:

http://peltiertech.com/Excel/Zips/TempConv.zip

- Jon