Microsoft Excel Graph Drawing Help Needed!
Microsoft Excel Graph Drawing Help Needed!
Author
Discussion

dpbird90

Original Poster:

5,535 posts

221 months

Sunday 7th November 2010
quotequote all
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



Ultuous

2,291 posts

222 months

Sunday 7th November 2010
quotequote all
Sounds like you need to use an x-y graph, rather than a line graph!

K87

2,111 posts

218 months

Sunday 7th November 2010
quotequote all
Plot it as a scatter graph, right click on the graph and go to select data,

Remove one of the series, then select the other and edit.,.... select the column you want for the X axis and then the column you want for the Y axis.

And voila...

dpbird90

Original Poster:

5,535 posts

221 months

Sunday 7th November 2010
quotequote all
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.

Ultuous

2,291 posts

222 months

Sunday 7th November 2010
quotequote all
Can't remember if you can I'm afraid (I don't have Excel on this machine), but I'm pretty sure you can right-click on the line and set display options for the series - at the very least you could probably display a formula for the curve and integrate that to find the area! nerd

spikeyhead

20,650 posts

228 months

Sunday 7th November 2010
quotequote all
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.

Dixie68

3,091 posts

218 months

Sunday 7th November 2010
quotequote all
Are any of you guys speaking English? wink

Doobs too

102 posts

276 months

Sunday 7th November 2010
quotequote all
The tensile strength is the highest point on your stress strain curve. You don't need to find the area under the curve for this.

JungleJim

2,430 posts

243 months

Sunday 7th November 2010
quotequote all
excel can be a bit idiosyncratic about plotting y against x - sometimes it will plot two lines, sometimes one.

just plot x-y style.

as for integration just use trapezium (excel will not integrate)

Ultuous

2,291 posts

222 months

Sunday 7th November 2010
quotequote all
Doobs too said:
The tensile strength is the highest point on your stress strain curve. You don't need to find the area under the curve for this.
Good point! The area under the elastic portion of the curve does have a use though, so it's worth checking what's actually required!

dpbird90

Original Poster:

5,535 posts

221 months

Sunday 7th November 2010
quotequote all
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.

mike_knott

344 posts

255 months

Sunday 7th November 2010
quotequote 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...

mrmr96

13,736 posts

235 months

Sunday 7th November 2010
quotequote all
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.

spikeyhead

20,650 posts

228 months

Sunday 7th November 2010
quotequote all
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.

It shouldn't take more than a minute to plug the trapezium rule into excel

mrmr96

13,736 posts

235 months

Sunday 7th November 2010
quotequote all
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.

It shouldn't take more than a minute to plug the trapezium rule into excel
There will be a perfect function to match the graph, however deriving it and then integrating it will be considerably harder than the trapezium method.

mike_knott

344 posts

255 months

Sunday 7th November 2010
quotequote all
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.

It shouldn't take more than a minute to plug the trapezium rule into excel
There will be a perfect function to match the graph, however deriving it and then integrating it will be considerably harder than the trapezium method.
Deriving the equation is a few clicks: Chart>Add Trendline>Polynomial, 6th order, and tell it to display the equation on the chart. It doesn't need to be perfect; the trapezium rule isn't perfect either. This will then integrate directly from the website above.

Mike...

mrmr96

13,736 posts

235 months

Monday 8th November 2010
quotequote all
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.

It shouldn't take more than a minute to plug the trapezium rule into excel
There will be a perfect function to match the graph, however deriving it and then integrating it will be considerably harder than the trapezium method.
Deriving the equation is a few clicks: Chart>Add Trendline>Polynomial, 6th order, and tell it to display the equation on the chart. It doesn't need to be perfect; the trapezium rule isn't perfect either. This will then integrate directly from the website above.

Mike...
Oh ok. I didn't know you could get excel to make a trendline which has a polynomial function driving it which could then be displayed.