Microsoft Excel Graph Drawing Help Needed!
Discussion
For my engineering assignment we're doing tensile stress, and part of the assignment requires a stress/strain curve. However, I cannot for the life of me get Excel to draw one (before anyone says "draw it by hand then" we've been told to do it on Excel as there are 600 readings to account for; 1 every 0.1 secs for 1 minute). I'm doing the regular thing for constructing graphs, highlighting the data I want and using the graph wizard, drawing a line graph. However, I get two lines, one for stress, and one for strain. Those of you who have some knowledge of engineering will know a stress/strain curve is one single curve i.e. I need them plotting against each other, strain on the x axis and stress on the Y axis. I'm using the 2007 version of Excel, anyone know how to do it? Cheers
dpbird90 said:
Thanks guys, thats me sorted. Just one last question, is it possible to get Excel to calculate the area under the curve for me? I need this result for the tensile strength, I can calculate it myself but of course would rather make life easier for myself.
You can calculate the area under the graph using the trapezium rule on the data.Thanks guys, yeah a quick check of the assignment brief says the area under the curve is actually an estimate of the strain energy needed for fracture, couldn't quite remember which way round a few things were after getting up at 5am. Will do the trapezium rule method once it's printed out. Thanks again all.
As above, draw it as an xy scatter graph.
Integrating it is probably easier than trapezium rule. Use:
http://integrals.wolfram.com/index.jsp
Mike...
Integrating it is probably easier than trapezium rule. Use:
http://integrals.wolfram.com/index.jsp
Mike...
mike_knott said:
As above, draw it as an xy scatter graph.
Integrating it is probably easier than trapezium rule. Use:
http://integrals.wolfram.com/index.jsp
Mike...
That only works if he has the function, which he doesn't. He has a series of data points.Integrating it is probably easier than trapezium rule. Use:
http://integrals.wolfram.com/index.jsp
Mike...
mike_knott said:
As above, draw it as an xy scatter graph.
Integrating it is probably easier than trapezium rule. Use:
http://integrals.wolfram.com/index.jsp
Mike...
but that assumes there's a perfect equation to match the graph.Integrating it is probably easier than trapezium rule. Use:
http://integrals.wolfram.com/index.jsp
Mike...
It shouldn't take more than a minute to plug the trapezium rule into excel
spikeyhead said:
mike_knott said:
As above, draw it as an xy scatter graph.
Integrating it is probably easier than trapezium rule. Use:
http://integrals.wolfram.com/index.jsp
Mike...
but that assumes there's a perfect equation to match the graph.Integrating it is probably easier than trapezium rule. Use:
http://integrals.wolfram.com/index.jsp
Mike...
It shouldn't take more than a minute to plug the trapezium rule into excel
mrmr96 said:
spikeyhead said:
mike_knott said:
As above, draw it as an xy scatter graph.
Integrating it is probably easier than trapezium rule. Use:
http://integrals.wolfram.com/index.jsp
Mike...
but that assumes there's a perfect equation to match the graph.Integrating it is probably easier than trapezium rule. Use:
http://integrals.wolfram.com/index.jsp
Mike...
It shouldn't take more than a minute to plug the trapezium rule into excel
Mike...
mike_knott said:
mrmr96 said:
spikeyhead said:
mike_knott said:
As above, draw it as an xy scatter graph.
Integrating it is probably easier than trapezium rule. Use:
http://integrals.wolfram.com/index.jsp
Mike...
but that assumes there's a perfect equation to match the graph.Integrating it is probably easier than trapezium rule. Use:
http://integrals.wolfram.com/index.jsp
Mike...
It shouldn't take more than a minute to plug the trapezium rule into excel
Mike...
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff




