Hello, vijay4u!
You wrote  on Tue, 8 Aug 2006 15:03:23 -0400:

v> Can Anybody Pls Help Me In Calculating The Area Under The Xy
v> ScatterCurve.

You are really asking about doing numerical integration and
there are lots of recipes for it. You could try a Google search
for

Excel "numerical integration".

A web site that comes up early in the listing is from Oregon
State and it's not bad. If you have a fair number of points,
Simpson's rule is quite easy to use.

Another possibility is to fit an equation to your data and
integrate the result algebraically .....polynomials are trivial
and exponentials are not that bad if you recall your high school
algebra.

James Silverton
Potomac, Maryland

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

See  Bernard Liengme's
http://people.stfx.ca/bliengme/ExcelTips/AreaUnderCurve.htm