- #1
Saladsamurai
- 3,009
- 7
Or know of any good tutorials?
This is a PAIN to do by hand.
This is a PAIN to do by hand.
Does any one know how to make a stress strain diagram in MS excel?
Click For Summary
Discussion Overview
The discussion revolves around creating a stress-strain diagram using Microsoft Excel. Participants are exploring methods to plot stress versus strain values, seeking tutorials, and sharing tips on graphing techniques within the software.
Discussion Character
- Technical explanation
- Homework-related
Main Points Raised
- Some participants express frustration with manually creating stress-strain diagrams and seek tutorials for assistance.
- One participant mentions having the necessary values but struggles with plotting them correctly in Excel, specifically using line charts.
- Another participant suggests using published stress-strain charts as a reference.
- There is a discussion about the types of charts available in Excel, with one participant noting that only line charts, pie charts, bar charts, and scatter plots are available.
- One participant proposes that a scatter plot might be suitable for the task but is unsure how to adjust the axis scaling.
- Another participant provides feedback on a graph, suggesting how to change the maximum and minimum values of the axes.
- There is a request to add a second curve to the graph to highlight the linear portion of the stress-strain relationship, with detailed steps provided for adding a new data series and formatting it.
Areas of Agreement / Disagreement
Participants generally agree on the challenges of plotting stress-strain diagrams in Excel and share various methods to address these challenges. However, there is no consensus on the best approach, as different techniques and chart types are discussed.
Contextual Notes
Participants mention specific features of Excel and the need for adjustments in graph formatting, but there are no detailed explanations of the underlying principles of stress-strain relationships or the implications of different plotting methods.
- #2
TVP45
- 1,041
- 5
Saladsamurai said:
What exactly are you doing? Do you already have values? Why don't you just use the published ones?
- #3
Saladsamurai
- 3,009
- 7
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"?
What do you mean "published ones"?
- #4
TVP45
- 1,041
- 5
Most materials have published stress-strain charts.
Anyway, back to Excel. What other choices do you see for plot type?
Anyway, back to Excel. What other choices do you see for plot type?
- #5
Saladsamurai
- 3,009
- 7
These are all of the line charts, all the others are just pie, bar, scatter plots...
- #6
Saladsamurai
- 3,009
- 7
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 stress-strain diagram
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 stress-strain diagram
Last edited:
- #7
z-component
- 494
- 2
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
Saladsamurai
- 3,009
- 7
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
FredGarvin
Science Advisor
- 5,097
- 10
Put in your second set of data. Highlight it and press control-c. This will put the data in your clipboard. Click once on your graph. Go to the edit menu and select paste special. You should the get a dialog box that will ask you if you want to paste it as a new series of data. Say yes. This will put the data on the same chart. However, you must click on either of the data sets and right click. Select format data series. There should then be a tab labelled Axis. Select it and there will be a selector box that says Primary or Secondary. Select secondary to put it on the other axis. You can then format the range of that axis separately.Saladsamurai said:
Similar threads
- · Replies 1 ·
- · Replies 1 ·
- · Replies 1 ·
- · Replies 9 ·
- · Replies 5 ·
- · Replies 2 ·
- · Replies 2 ·