HOME INSERT PAGE LAVOUT FORMIULAS DATA REW VEW DESIGN FORMAT

HOME INSERT PAGE LAVOUT FORMIULAS DATA REW VEW DESIGN FORMAT . ForingTableStyl Styles Chart 1 ·11 Strain linin) Stress IMpa) Aluminum 6063 Stress-Strain Diagram for Aluminum 6061 (blue), Polyethylene (Gray), and Steel (Orange 0.005 5 Yield Strength 0.0475 0.165 124 UTS Failure Engineering Ultimate Stress Steel 1040, 520 MPa 8 Strain [infin) Stress(Mpa) Steel 1040 290 Yield Strength 0.0485 0.182 UTS Failure Failure at 18% Strain for a 2 in. gauge length 48% Reduction in Area, Steel 1040 12 14 Strain in/in Sreas (MPal Polyethylene (HOPE 30 Yield Strength Engineering Yield Stress Steel 1040, 290 MP 0.004 0.0345 0.154 ae 0.2 % ethet 32 Failure 20 Reference 21 Callister, 4th Edition Enginaering Ultimate Stress AJ 6061, 124 MP rslure at 16% Strain for a 2 in. gasge le 48% Reduction in Area, N 6061 -X 1 Search the web and Windows

Solution

To create a log-log graph in Microsoft Excel, you must first create an XY (scatter) graph. This is the only graph type that will work; other graph types permit logarithmic scales only on the Y axis.

To create a log-log graph, follow the steps below for your version of Excel.

Excel 2010 or 2007
In your XY (scatter) graph, right-click the scale of each axis and select Format axis....
In the Format Axis box, select the Axis Options tab, and then check Logarithmic scale.

Other versions of Excel
In your XY (scatter) graph, double-click the scale of each axis.
In the Format Axis box, select the Scale tab, and then check Logarithmic scale.