Register to reply 
Does any one know how to make a stress strain diagram in MS excel? 
Share this thread: 
#1
Feb908, 05:22 PM

P: 3,016

Or know of any good tutorials?
This is a PAIN to do by hand. 


#2
Feb908, 06:18 PM

P: 1,127




#3
Feb908, 06:48 PM

P: 3,016

Yes. I have the values. I am just having a hard time figuring out how to enter and plot the values? I tried using line chart, but it seems to be graphing a line for both strain and stress instead on just one line for stress VS strain.
What do you mean "published ones"? 


#4
Feb908, 07:00 PM

P: 1,127

Does any one know how to make a stress strain diagram in MS excel?
Most materials have published stressstrain charts.
Anyway, back to Excel. What other choices do you see for plot type? 


#5
Feb908, 07:09 PM

P: 3,016

These are all of the line charts, all the others are just pie, bar, scatter plots...



#6
Feb908, 07:23 PM

P: 3,016

I think the scatter plot will do it, I just can't figure out how to change the scaling of the axes.
I got it to look like this: Now I just need to get the blown up graph for the elastic range. I want to make it show up underneath the main curve with its own scaling just like a standard stressstrain diagram 


#7
Feb908, 08:40 PM

P: 483

You can change the max/min values right on the open dialog box in your image. See the minimum and maximum fields? Nice curve, by the way.



#8
Feb908, 08:45 PM

P: 3,016

Right. The only thing is, I want to get a second curve in there. I want to expand (blow up) the linear portion of the graph. . .



#9
Feb1008, 01:40 PM

Sci Advisor
P: 5,095




Register to reply 
Related Discussions  
Stressstrain diagram using deformation ?  Engineering, Comp Sci, & Technology Homework  2  
Finding the max shear stress at a point on a plate (with a hole)  Classical Physics  1  
Stress vs. Strain  Engineering, Comp Sci, & Technology Homework  2  
Stressstrain diagram  Introductory Physics Homework  0  
Stress strain  Engineering, Comp Sci, & Technology Homework  2 