How to Graph a Modified Goodman Diagram in Excel

Learn how to create a modified Goodman diagram in Excel for fatigue analysis, including setting up stress calculations, plotting the failure lines, and interpreting the results for mechanical component design.

In this tutorial:

Setting up stress data
Creating the Goodman line
Adding yield strength lines
Plotting operating points

You'll need:

Excel (2010 or newer)
Material properties data
Basic knowledge of fatigue analysis

Creating a Modified Goodman Diagram in Excel

Step 1: Setting Up Material Properties

Enter Material Properties


                            A1: Ultimate Tensile Strength (Sut)

                            A2: Yield Strength (Sy)

                            A3: Endurance Limit (Se)

                            A4: Safety Factor (n)

Create Stress Table

Mean Stress	Alternating Stress
0	Se
Sut	0

Step 2: Creating the Basic Plot

Insert Scatter Plot

• Select your stress data
• Insert > Scatter Plot
• Choose "Scatter with Straight Lines"

Format Axes

• X-axis: Mean Stress (0 to Sut)
• Y-axis: Alternating Stress (0 to Se)
• Add gridlines for better readability

Step 3: Adding Yield Strength Lines

Yield Line Equations:

For positive yield line:

σa + σm = Sy

For negative yield line:

σa - σm = -Sy

Create Additional Data Series

Add columns for yield lines using the equations above.

Step 4: Plotting Operating Points

Add Operating Points


                            Create new columns:

                            Operating_Mean_Stress | Operating_Alt_Stress

Pro Tips and Best Practices

Formatting Tips:

Use different colors for different lines
Add a legend for clarity
Include grid lines for easy reading

Analysis Tips:

Check safety factor at critical points
Consider stress concentration factors

Common Issues and Solutions

Graph Not Displaying Correctly:
Check data ranges and axis settings
Lines Not Intersecting:
Verify material property values and calculations