plotting mohr-coulomb failure envelope in excel

[svidrod]

I am trying to plot a Mohr-Coulomb failure envelope in excel. I can't figure out how to get excel to plot the Mohr's circle along the x axis given the two stresses.

 

[GregLocock]

Do you not know how to plot a circle, given its centre and radius, or do you not know the centre and radius of the circle?





Cheers

Greg Locock

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

 

[svidrod]

i do not know how to plot a circle given its center and radius.

 

[GregLocock]

Create a column of angles from 0 to 2 pi, each of those is theta in the following equations.
x=x0+r*sin(theta)
y=y0+r*cos(theta)


Cheers

Greg Locock

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

 

[joerd]

Don't forget to use a scatter plot when plotting y vs. x

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

 

[svidrod]

alright, i got the circle to work just fine, thanks. now, how would i plot a straight line with one end fixed and the other end tangent to said circle.

 

[GregLocock]

http://www.netsoc.tcd.ie/~jgilbert/maths_site/applets/circles/tangents_to_circles.html

etc


Cheers

Greg Locock

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

 

[svidrod]

thanks a bunch!