Calculation of Area Under a Plotted Graph

U

un1c0rn

Hi Gurus,

Can anyone please assist me in finding a formular to calculate the area
under a plotted graph (not a curve or straight). The area I need to measure
is between the X, Y and graph area and stopping at any given point on the X
axis. Any help would be muchly appreciated.

Thanks
 
D

DazzaData

Hi,

You don't say what sort of graph it is exactly, but for an area chart the
area under the graph between two points A (x1,y1) & B (x2,y2) will be

=((x2-x1) * (y1 + 0.5(y2-y1)

If you repeat this for each of the 'polygons' and add them up it should give
you the result

Cheers

Dazza
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

area under the graph 3
Calculation of Area Under a Continuos curve......Scatter Curve. 0
Calculation of Area Under a Continuos curve...... 5
Trendline Not Appearing In Chart Problem ? 0
How to put same scale on X and Y axis on graph 2
X-Axis Appearing in Plot Area 2
Automatic deleting graph segments 0
Get value equal to final point of chart trendline [=Trend( )] ? 1

Top