Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
area betwen 2 graphs
Is there a way to get excel to calculate the area between 2 graphs?
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
area betwen 2 graphs
You could use this technique from Bernard Liengme's web site:
http://people.stfx.ca/bliengme/Excel...UnderCurve.htm Calculate both areas, then subtract. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Travis" wrote in message ... Is there a way to get excel to calculate the area between 2 graphs? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
area betwen 2 graphs
The problem is that the graphs are not curves, and are not friendly toward
formulas being applied. They are very irregular in shape. "Jon Peltier" wrote: You could use this technique from Bernard Liengme's web site: http://people.stfx.ca/bliengme/Excel...UnderCurve.htm Calculate both areas, then subtract. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Travis" wrote in message ... Is there a way to get excel to calculate the area between 2 graphs? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
area betwen 2 graphs
Travis wrote on Wed, 16 Jan 2008 13:06:01 -0800:
T "Jon Peltier" wrote: ?? You could use this technique from Bernard Liengme's web site: ?? ?? http://people.stfx.ca/bliengme/Excel...UnderCurve.htm ?? ?? Calculate both areas, then subtract. ?? ?? - Jon ?? ------- \ ?? Is there a way to get excel to calculate the area between ?? 2 graphs? T The problem is that the graphs are not curves, and are not friendly toward T formulas being applied. They are very irregular in shape. You could readily set up something as simple as Simpson's rule for each graph. James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.verizon.not |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
area betwen 2 graphs
I was afraid to ask what made the data too irregular for this approach
(Bernard's must be Simpson's or something similar). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "James Silverton" wrote in message ... Travis wrote on Wed, 16 Jan 2008 13:06:01 -0800: T "Jon Peltier" wrote: ?? You could use this technique from Bernard Liengme's web site: ?? ?? http://people.stfx.ca/bliengme/Excel...UnderCurve.htm ?? ?? Calculate both areas, then subtract. ?? ?? - Jon ?? ------- \ ?? Is there a way to get excel to calculate the area between ?? 2 graphs? T The problem is that the graphs are not curves, and are not friendly toward T formulas being applied. They are very irregular in shape. You could readily set up something as simple as Simpson's rule for each graph. James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.verizon.not |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
area betwen 2 graphs
Hi,
Can you describe or post a link to how your graph looks if Bernard's approach will not suit. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Travis" wrote in message ... The problem is that the graphs are not curves, and are not friendly toward formulas being applied. They are very irregular in shape. "Jon Peltier" wrote: You could use this technique from Bernard Liengme's web site: http://people.stfx.ca/bliengme/Excel...UnderCurve.htm Calculate both areas, then subtract. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Travis" wrote in message ... Is there a way to get excel to calculate the area between 2 graphs? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Taking out or reducing space betwen paragraphs | Excel Discussion (Misc queries) | |||
Determine years betwen 2 dates | Excel Worksheet Functions | |||
Working betwen excel and acces | Excel Discussion (Misc queries) | |||
graphs and colouring an area | New Users to Excel | |||
Toggle betwen "editing" and "pushing" a button in excel | Excel Discussion (Misc queries) |