Excel question...area under the graph

[dmw16]

I have a graph on excel. There is no set equation so I cant just intergrate it. Is there any way to make excel graph the area under a graph?
thanks,
-doug

 

[Hector13]

you mean like making it an "area" chart instead of a line chart? Or do you actually want to calculate the area under the curve?

 

[dmw16]

It isnt a curve. Its lines, but yes, the area under it.
-doug

 

[Dark4ng3l]

a graph of a function, whether a curve or a line, is always caled a curve.

 

[dmw16]

Yeah, thanks, that was helpful.
-doug

 

[dolph]

doesn't matter, you're still going to know how to do it for the final in calculus

 

[dmw16]

Calc final...yeah that is done. I did my time in calc1, calc2, and calc3. Just diffeq left. This was actually for Mechanics of Materials project. Anyone actually know how to do what I want to do?
-doug

 

[Hector13]

simple answer: there is no easy formula built into excel (atleast none that I have ever seen).
But if you actually have gone through calc 1-3, like you say you have, doing a simply "simpson's rule" calculation would be real easy.

 

[dmw16]

What do you mean if i've actually been through calc1-3? Why would i lie about that? I dont think that taking calc makes me cool.
-doug

 

[Hector13]

Originally posted by: dmw16
What do you mean if i've actually been through calc1-3? Why would i lie about that? I dont think that taking calc makes me cool.
-doug

cool? it has nothing to do with cool. It has everything to do with the fact that you could have done the calculations by yourself using simple formulas in a lot less time than it would take for you to get an answer here.

 

[dmw16]

well...for that matter. It is just a V-M diagram. So it is triangles and squares. The point is, I wanted to do it in excel so that it would look nice. It has nothing to do with ability to do the calculations.
-doug

 

[Sukhoi]

Haha, you're gonna die in diffeq. I'm so hoping to pass my final on Tuesday..

 

[dighn]

Originally posted by: dmw16
well...for that matter. It is just a V-M diagram. So it is triangles and squares. The point is, I wanted to do it in excel so that it would look nice. It has nothing to do with ability to do the calculations.
-doug

maybe script one of the numerical methods like the mentioned simpsons rle, just google it if u dont rmember

 

[cressida]

do it by hand ... take the intergral of it

 

[raptor13]

Do you mean you want to know how to calculate the area under the curve or you want to know how to make Excel shade that area?

 

[notfred]

do a riemann sum and break it up into sections based on your data points

 

[Hector13]

Originally posted by: dmw16
well...for that matter. It is just a V-M diagram. So it is triangles and squares. The point is, I wanted to do it in excel so that it would look nice. It has nothing to do with ability to do the calculations.
-doug

look nice? I still don't think anyone understands what you are trying to do. Like I asked you above, do you want:

1) To have excel shade the area between your curve and zero (which, again, would be an "area" chart)

2) Calculate the area under the curve (you will need to do this manually with simpson's rule or trapezoids)