如何用Origin画应力应变曲线

1、如何用Origin画应力应变曲线editedby:jsphnee,2011Tl-22本文是作者从小白开始一步一步学着用excel和origin作应力应变曲线的经验分享，只适于初学者，有不对的地方还请高手多多指教。在此也一并感谢网上提供origin及excel相关技巧解答的同志们。1.一、数据导出用Access打开数据库，并将OriginalData导出到excel中（97-03版，否则ori打不开）；I匚NAiFf103!MWArt1Dnidbiii1LB3FIptMaEanhhsi1MID91j|PrrrW-.M:suJItIdFLlieiLraBtlEd旳住EH.LiJiZBiTIII-H

2、40b_.l-i1.(!.AJdBIhditd*IFEfl-W?阿XPXE艺沁UU*JHUU士rtjL-0KHiiM1UL如凹ITF.ZJIIZiaBLS4301Sm.sJTBNDUl址沁STkLftimiU?6琦1習料上住：!rt.1期5fc4-3tan曰吕Wn:ifnA日it十rtitaEiixeTrrtQUmiHI,加：4I鴻AT-krinrw?r3.2.打开导出的OriginalData.xls文件和试验报告文件（实验结果中另一个以日期命名的excel文件，Tip：为方便统一打开与存放，可将试验报告文件复制到OriginalData的新工作表sheet中，可命名为report）；色眄r

3、恤BagffiE:解1511EK碣AafS血卫凶羔T:盅J厂-J遇宅157：*AccnIdiqat宫丰白5事迅算劃31红.血1*宅.Mh虑片苦曜&*iFi神世n一禅FJg眄黑團ait【L?LME-ll?.ii25l盘1052.2$7M910.67D.7巫嚴umui*2L.-M11.H2S4tOH27*7.740.47ft.772IjKiL4JiTft1-31.筑2&：B7idki.aYTH3EL3QT4ft占IE.*iM2-531乂刃2a.6IKE.砖7S7.LIL0G.7國勰LiftSl：.M詬隔曲f.O从函甜LT4t-S2Jill29；37.Km韓也岸6舁H：IEi-a512.；l54.7

4、1敕L罄Mt.臨L.c.彌甌第a慢l：-M2*.71期忑禎厂17,33Ch晰晰迪丄jd皿17,HT4i尸出斥nzWru百屮代!；L|=1C【保存，并更改文件名，（Tip:每次更改后都点一下保存，以免程序卡死时丢失数据。）4.新建以试样编号命名的sheet，有几组试样就建几个sheet；二、数据处理1.筛选各个试样的拉伸数据在OriginalData中，选中TestNo列，再点数据工具栏中的筛选。園|R時*e?-MicrosoftExc*t并曲ISA贾齒冇雋仝比JS迟甫闻理11D淒ifr严；3*Kt?目自耶占吕立申目具忠舶融耐3J*-xV、-快戕外鄙黑5SS1S徘序ft!林述：T*stXoDEF

5、6卜11IDIfiL-AjFlayTiaeLoadValuFositionEztundTckBigDefenDefqxkSw:Ctr1Stup2113#600142.0220.003475c.G00480432133600142.9220.003475*”OO04S0I143J35600142.922Ci003475乱0C0460415J)35600.01177,23110.0.WC66S0J1da138600.01?210.8；IBCLQO54T50.QQ0&310i17613600.094屮20490.0O1C3401S7138600.ISE277.S7390.&07C2BQ.001ISE

6、-0-19a13S600157310.2310.&OM2500013750411091380.13S3J2.2B26(r.010L0.0015370A111LO138600.219374.66S60.OH750366604I12LI138600266108.00220.0123250.0018230I)131213S5D02824-JL.335B0.013475O.OQ2OL7t)411c4l-fJ-LJT.巾片Ael”.tr1JhAArTi-RnJi电点击列标题旁的下拉箭头，出现下面左图中的对话框。ELTestAPEC31ID|TestNo|PlayTineLaadP;EL”企丘TestAB

7、cD1IDTsstNo-fPlayTimeLoadVaA.汀升序iJ降厚側按麵色挂号（JD哝从TestNo11中浦粽筛选Q拽颜兰排呼越Mi進迥p*(全选j138601386171386231386S*13864z13865三*13S&*13S67-r从汗旳勺中j訓篩选按颇皀筛选数宇筛选出.338000.310.2310.00902o0.0013750410913B600.188342,28260,01010.001537041110138600.21&茁丄66360.01117d0.0016S6041211138600.266408.00220.0122250.0018220413121386

8、06292441.33580.0134750.002017041413138606313475.6170.0145750.00221041113B600.3&50B.95060.0156750.00233901It1513B600,391541,33t60,0167&0.002496041.16738600.4235?4,0292D.0178250.00269041.S17L38600.4a3607.36270.0189：o0.0028a1041918L38600.485640.69640.0200250.00301204然后按照相同的步骤依次筛选该组的各个拉伸试样的数据拷贝到该sheet中。

9、如下图:it伸宓-MicrosoftExcel幵贮曰Access白河站白立本自賊也来逓现冃旺窗连捉主却刷新T三一石塔室麼在滩sjIS,T*Bra謹I排序和筛陡幵曲JS貝S1布局云在PTTlKrast1?i5ffiuli_jL_iBAccess自网站自文审自我如5f现有囤fH=J*BkdEFHI1Lc*a-dValuBzteDdta；LGa.dValuiEAtendVa：Loa.dVarjiEztenlValue2142S22乩0&OiS；6j.S57272.SE-05SO.7420L-2.BE-052142.922(LOT04.S；65.357272LS2E-0q80.74201-ZSE-Oo

10、142,9620,WM4S；65.3-5727,SEE-Q530,7-1201-1.8E-05a177.2311(LO006CT：65.357272LS2E-0o80.74201-2.SE-Oo6210.8713!0-0OS31；65,357272,8SE-Q530.74201-2.8E-05Ti244=2049；0a08腔虽阪357272LS2E-Q58G.74201-2.SE-Oo&277.872910.0011&6；5,35727,SEE-Q530,7-1201-1.8E-059310.2310.001375*65.357272LS2E-0o80.74201-2.SE-Oo10342.2

11、836!0-001537：65,S57272,8SE-Q530.74201-2.8E-0511374.66860.(J016&6詁乩3572T2.82E-0o8D.74201-2.BE-Qo-lO8.K3SiO.O(J1&23；5,15727S,S2E-0580,；4301-1.8E-0513441.335S0.002017*65-357272.82E-0d80.74201-ZBE-Qd14-35：L5合LUp?AB1Ewte-dVo.；LoadBiLui2|0.0001314E.922D如如142224o.oooia14E.92250.CK10W9177.23116o.oweai10.&mT

12、0.W1KE-!銅比创怡B0.C4111B6277.372&!0.Mia5:lO.23lID0.W1Q37342.法甜lla.001666374.&5旺120.M1B234M40220.C020L7m.3356Ua(JQ2Zl175.617150.M233950B.细帕160.豹经苑541.J36617D.Q02M574.強昭出d.2651607.M2719o.om?610.的84nnnAflirivim712S2E-O565.S57272.2314-0560,7JB&12-8SE-45師5727S2E-&565.3*57272.S2314I-0&60.沏够2.&23L4E-06074201S

13、trfl.in3xmb1.L6MTEP6函.*4L55trfl.inlStre-5515trBin-25tres:-21.9197ilE-fl5，F5.町倔1.1293GE-K2.6B654B232E-0565.157272.E23LJI-05&1T42012S2E-O5诙.157272.S23L4E-05GO.74201EEE-W553.3UT273.S23L4E-0560.T-JEQ1132EP565.3ci7272.E23L41-05&1TJ2Ci262E-.55輻.15727i.23lJI-05&X7jS&1=邮讣标距Z.SSEF5O*lE_rt=0n0*131.-tx1ncdaTxn

14、fti4）调整第一行应变与应力值的格式，分别为百分数与数值（四位小数）Tip:也可只调整前两个单元格（H2和12），其余单元格可用黏贴选项里的格式功能来复制H2和12的格式，如下图：5）选中第一行的应变应力值，双击填充柄，即可将公示与格式同时填充。如下图:%*条杵格式拿用单元蹄式圏措式T迄”徘序选至掛0操械字斤锌式年元梏6）计算其它sheet的应变应力值时更方便，只需将试样参数都复制到与第一个sheet相同的位置上，然后拷贝第一个sheet的中第一行应变与应力值，接着选中要黏贴的单元格：右键一选择性黏贴一公式与格式即可，再双击填充柄，一步搞定。5、origin中的数据处理1）在ori中新建wo

15、rkbook，及时改名，最好让ori中的sheet与excel中相应试样组的sheet命名一致，以免混淆。2）在ori中空白位置右键一Addnewcolumns，使其与excel中应变与应力值的列数一致。3）将excel中应变值与应力值列copy到ori的列中。（如果显示#，请将列宽调大一点）。4）如果数据导入后，下面的数据有出现多余的0,删除之。AJK11B(Y1JCiXJl取燈l=(K)1FgIUnfcs%何CanmnanisLonqFdameEnn&erlrgStrEngme&ingSir5train-251r&ss-25tran-lStres-33367DD92813.33519-0.

16、1W383T24H2160JBJ3809421641D的2的662689D&010407722.4431003曲5&3379375009299032044050J04Z27207040300B953&33424S5337(1D09907B31411&5010437T1BB3694aIJB961&13.Q171-3710.09316S50.B05SS-0.104S2716.962410.0B96S93555293372DQ93250301057190.HH6771497?00B976932D94用3W3DM33401047120790I3&9SS931GSMsaw0.CS343瑚.920590.

17、104&5710.65101Q.闕I1.2341633750.09362KB2359&0.1K117JB西689Od&BMO&5992伽D09361B57&244&JT00&M6&304347-fl33770.0537856B&311000090139299S4Q913719DM379S615439aaa05021294334.2337S0.09367GS&1囱00Q.OSO2092B.95911烟DQ9396B549&591G飞0.09&36925題田42ED4945&543624-5aa33820.094I43.7437800-0.0SO5I9-27.654S时却DD94238531113

18、80a00905800&066冊24641耀E&37383384D09斗32B52+&52&aa33B5006441&51B20240000SO73&26-W21233E6HQ945B512D157aQDngae&2BD46BS33B7Q.Q94S9&50.&61?800o.ofte25.625313309D0943関9刖044GF0.09096陀521丁轲5）将原来excel中的标题行选中，右键一SetAsLongName.如图:6）将第一列和第二列的LongName改成应力应变曲线中轴坐标想要显示的名称，并设置一二列的Units为所需显示的单位。A(X)B(Y)C(Y)D(Y)E(F(V)

19、Units%MPaCommentsLongNameEngineeringStr1.91974E-SEngineeringSu|Strain-25tre53-25train-3Stress-315.07891.12926E-62.686551.16047E-63-3190621.91974E5.371391.12926E-62.696551.16047E-63.31S953191974E-55971991.12926E-026865511SO47E-03.3199542.B7795FS72851911292&E-62686551.16O47E-&3.3189&5332324F58.BB7BB11

20、2926E-0Z68555116O47F.-03.3189S64.O975SE-51C.O30181.1292BE-62.686551.16047C-63.31S95点击左上角的单元格，选中所有列，右键一SetAs-XYXY.DlotRfYlC(Y)D(Y)E(Y)CommsLongNa為Cut电CopyCopy(fullprecision)ifiPasteInsertDeleteClearSetAsFillColumnsWithSortColumnsSortWorksheetSOStatisticsonColumns,.盒StatisticsonIRow5.ColumnViidth.r,Se

21、tSampling|ntervaL.MoveColijinnsShawXColumnSwapColumns.,rAddSparklines.u.Mask2|1.614S4E-4Strain-2112926E-GL12920E-61.12920E-6112926E-6112&26E-611州州F-HmiCDisregardXiYXYYXYYXVYVXWYXYVErrXYYErrXWErrXVZZXZXYZ540903112926E-6112926E-6112&26E-G112920E-GStress2Slrain-3Stress-32B3S5511GM7E-G331895Z035&5UGCMTl

22、E-G3.318952-69655k15047E3.311995168BK1.16W7E-6131895268655-Ti6(M7E-6J31805268&STl6W7E-63310952easss116CM7E-6321S9-52ea&511GG47E-G3318952B3S5-511GM7E-G3318952_G0&55i.iao47E-a3-31695168BK1.16W7E-63.318952686551.i6W7E-e331095心:-L16W7E-63318952E胱产116W7E-63318952ea&K11GG47E-G3213952B3S5-511GM7E-G3318952_

23、03&5UGCHTlE-G3.31895i69&55W47E用3-319952.686551.16047E-6131896268655TietMTE-SJ31885268&5ST.l6W7E-63310952easss11GCM7E-G321S9-52eas5511GG47E-G331S952B3&5511GM7E-G331895F(YJ7）然后直接点PlotfLineLine，即可出图。8）双击坐标轴可调整相应参数。以下几点是需要在google中搜的，我一并写了出来。想使坐标轴刻度显示在坐标轴里面，请在Title&Format里设置；Axis-Layer1TfettLat回MinorTick

24、Labp百Cugton丁drLabt甫ScaleTitle、FiunLGridLInegBreakSelectitShorAkis&TickTitCqLqg|BlackTtiicknestCpth5JlajorTick8ApplyT*_CaLtThiaLayer*licksLIThicknessThisLLyer+LjTickLengt确走收眉|应用GO为使横坐标向下图一样顺利地显示百分数；100-0|IJL|JL|51Dlii2025EngineeringStrain(%)需双击横坐标，在TickLabels中的Divideby填入0.01。如下图:XAxisLayer1同时要想使坐标原点只

25、显示一个0”，就在Scale中将From的值设为0.01。EngineeringStrain(%)10）最后调整线的颜色及指示框等。11）若要处理其它sheet,可直接右键sheet标签Duplicatewithoutdata,然后直接拷入相应数据，并除去多余行。这样可省去设置name、unit及列属性等操作。BtYUICPC21rmECG)FiY31Iunits曲MPaCommentsLongNameEngheerhgStrEngineeringSirScraln-2Slress-2Strain-3Stress-342.B7795E-57.2B&19L12926E-02.636551.16Q47E-63.318955332324E-5s.cersB112926E-61.1-6kl7E-S3.31S95e4.DS75SE-510.Q3B1BL129KE-S2.S3S551.11BQ47E-63.318957A74200E-511.42213112926E-61.1-6M7E-63.31S95S5.501DSE-512.752231J2925E-S2.G3&551.16Q47E-63.318959614630E-514.069721I.12926E-62.&36551.16CM7E-63.31S95100.66262E-515.4DD971J2925E-