Are you using a Line graph or an XY graph? The x-values in a Line graph
are categories, and are not necessarily "scalable." Make sure you're
using an XY plot where the x-values are treated as real numbers.

As for getting the area under the graph, to my knowledge Excel doesn't
have that ability built into it. But Excel is certainly capable of the
calculations necessary to obtain the area under the graph. Without
seeing the actual data, I can't say for sure the best approach. If you
know V(t) and can also come up with an anti-derivative for V(t), then
you can make use of the fundamental theorom of calculus to determine
the area under the curve. If you don't have V(t), but can get a
reasonable V(t) using curve fitting techniques, then you can use that
V(t) to get the area under the curve. If your delta-t values are small
enough (small enough depends on how curved V(t) is), then you can use
Riemann sums to estimate the area under the curve.

Does that help?


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=483247