How to Label Proportional and Ultimate Stresses on Excel Stress-Strain Diagrams?

  • Thread starter Thread starter Saladsamurai
  • Start date Start date
  • Tags Tags
    even Excel
Click For Summary
SUMMARY

This discussion addresses the process of labeling proportional and ultimate stresses on stress-strain diagrams created using Excel's 'Insert X-Y Scatter' function. The user initially struggled to find a way to add text boxes to the graph but successfully discovered the feature under the 'View' menu, specifically in 'Toolbars' and then 'Drawing'. This solution allows for clear annotation of key stress points on the diagrams, enhancing their clarity and usability.

PREREQUISITES
  • Familiarity with Excel 2016 or later for creating graphs
  • Understanding of stress-strain diagrams in material science
  • Knowledge of proportional and ultimate stress concepts
  • Basic skills in using Excel's drawing tools
NEXT STEPS
  • Research how to customize Excel charts for better data visualization
  • Learn about advanced features in Excel 2016 for graph annotations
  • Explore best practices for presenting stress-strain data in engineering reports
  • Investigate other software options for stress-strain analysis, such as MATLAB or OriginLab
USEFUL FOR

Engineers, material scientists, and students involved in mechanical testing and data presentation will benefit from this discussion, particularly those using Excel for graphing stress-strain relationships.

Saladsamurai
Messages
3,009
Reaction score
7
EVEN EASIER EXCEL question!

I am a little confused as to how I am supposed to "mark" the proportional and Ultimate stresses on my stress-strain diagrams. I created them with Excels 'insert x-y scatter' function. I cannot find any way to add a text-box though... Any ideas?

I basically just want to add text in on the graph like http://www.ae.msstate.edu/~masoud/Teaching/pics/propor_yeild.gif
 
Physics news on Phys.org


Nevermind...I found it under view-->toolbars-->drawing if anyone cares :)
 

Similar threads

Solving Stress-Strain Curve: Ultimate Stress, Units Confirmation
  • · Replies 1 ·
Replies
1
Views
2K
Stress-Strain Graphs of different materials
  • · Replies 9 ·
Replies
9
Views
7K
Confusion Calculating Young's Modulus
  • · Replies 5 ·
Replies
5
Views
2K
How to Plot a Stress-Strain Graph for Steel Sheet?
  • · Replies 2 ·
Replies
2
Views
2K
Why Are My Strain Values Displayed Incorrectly on the X-Axis in Excel?
  • · Replies 8 ·
Replies
8
Views
6K
Calculate Modulus of Toughness from Stress-Strain Graph
  • · Replies 2 ·
Replies
2
Views
26K
Understanding Transformer Phasor Diagrams
  • · Replies 3 ·
Replies
3
Views
3K
Comp Sci How Comprehensive Should an Undergraduate Explanation of MPLS Be?
  • · Replies 1 ·
Replies
1
Views
1K
Analyzing a Truss with Excel: Solving the Matrix Problem
  • · Replies 1 ·
Replies
1
Views
5K
Calculating Young's Modulus, Yield Stress, etc. from Force-Elongation Graph
  • · Replies 2 ·
Replies
2
Views
8K