Creating S-N Diagrams with Excel

  • Thread starter fmunene
  • Start date
  • Tags Tags
    Diagrams
1 reply · 14K views · last reply
fmunene
Messages
1
Reaction score
0
Hello, I need help
with plotting a S-N curve using Excel given the data below
I know how to plot using the scatter function in excel but i am confused on what values should go on the y-axis...i.e S...it is clear that the number of cycles will obviously go onto the x-axis...Please explain what excel equations I need to get . Any help will be highly appreciated.

"Average Diameter [in]","Moment [in-lb]","Number Cycles [N]"
0.25, 122.718463, 20000
0.2513, 101.2723101, 40000
0.2496, 91.59776729, 100000
0.2503, 76.97548741, 200000
0.2506, 61.80207912, 500000
0.2513, 52.1941906, 1000000
0.251, 46.5738686, 2000000
0.2513, 38.95088851, 5000000
0.2503, 33.09945959, 10000000
0.2506, 30.90103956, 100000000
 
fmunene: Compute stress, S = 32*M/(pi*d^3), where d = diameter. After you plot S versus N, display the graph with the log-log display option.