Hello
I am not aware of any Excel function that does that
automatically.
In general you can use integration to calculate the area
under the curve / line.
Suppose you had...
x y
0 0
1 1
2 2
3 3
If you plot that data you get a straight line of equation
y = x i.e 0=0 , 1=1 etc.
If you integrate y = x you have y = (x^2)/2. For the
whole area below the line use x values 0 and 3. So if x =
3 then y = 4.5. If x = 0 then y = 0. Subtract one from
the other so 4.5 - 0 = 4.5 sq units (This is area under
curve).
If you wanted the area between x = 1 and x = 2 then you
would use those numbers in the equation.
i.e x = 2 y = 2 and x = 1 y = 0.5 So area is 2 - 0.5 =
1.5.
This is the only method I know of. Does this help? If you
post your raw data I could calculate the area for you if
you are unfamiliar with integration.
Alex
