Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I calculate the area between axis and dataseries xl2002
I'm trying to calculate the area of a graph (data series) between the x-axis
and the data-series in excel 2002. I don't know how. Please help! |
#2
|
|||
|
|||
Evert,
With your X-values in A1:A11, and your Y values in B1:B11, the formula =SUMPRODUCT((B2:B11+B1:B10)*(A2:A11-A1:A10))/2 with return the trapezoidal approximation of the area under the curve. Obviously, the smaller the interval of your X values, the better the resolution of the approximation. HTH, Bernie MS Excel MVP "Evert" wrote in message ... I'm trying to calculate the area of a graph (data series) between the x-axis and the data-series in excel 2002. I don't know how. Please help! |
#3
|
|||
|
|||
See my website www.stfx.ca/people/bliengme/ExcelTips
best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Evert" wrote in message ... I'm trying to calculate the area of a graph (data series) between the x-axis and the data-series in excel 2002. I don't know how. Please help! |
#4
|
|||
|
|||
The graph is a little more complicated. It hass these kind of points
X y 1 0 2 15 3 30 4 45 5 53 6 18 7 20 8 10 9 2 10 0 "Bernard Liengme" wrote: See my website www.stfx.ca/people/bliengme/ExcelTips best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Evert" wrote in message ... I'm trying to calculate the area of a graph (data series) between the x-axis and the data-series in excel 2002. I don't know how. Please help! |
#5
|
|||
|
|||
My formula gives a value of 193:
=SUMPRODUCT((B2:B10+B1:B9)*(A2:A10-A1:A9))/2 -- HTH, Bernie MS Excel MVP "Evert" wrote in message ... The graph is a little more complicated. It hass these kind of points X y 1 0 2 15 3 30 4 45 5 53 6 18 7 20 8 10 9 2 10 0 "Bernard Liengme" wrote: See my website www.stfx.ca/people/bliengme/ExcelTips best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Evert" wrote in message ... I'm trying to calculate the area of a graph (data series) between the x-axis and the data-series in excel 2002. I don't know how. Please help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In a 2 Y-Axis chart, how do I assign data ranges to an axis? | Charts and Charting in Excel | |||
can't change how data on 2nd axis is being displayed | Charts and Charting in Excel | |||
Can Excel calculate area for 3-D surface charts? | Charts and Charting in Excel | |||
multiple x axis data | Charts and Charting in Excel | |||
space between y axis and data points.. | Charts and Charting in Excel |