ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Calculation of Area Under a Plotted Graph (https://www.excelbanter.com/excel-worksheet-functions/145031-calculation-area-under-plotted-graph.html)

un1c0rn

Calculation of Area Under a Plotted Graph
 
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



DazzaData

Calculation of Area Under a Plotted Graph
 
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

-----------------------------------------------------
Please press 'yes' if this was useful





"un1c0rn" wrote:

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





All times are GMT +1. The time now is 02:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com