如何用Origin畫應(yīng)力應(yīng)變曲線

1、如何用Origin畫應(yīng)力應(yīng)變曲線editedby:jsphnee,2011Tl-22本文是作者從小白開始一步一步學(xué)著用excel和origin作應(yīng)力應(yīng)變曲線的經(jīng)驗(yàn)分享，只適于初學(xué)者，有不對的地方還請高手多多指教。在此也一并感謝網(wǎng)上提供origin及excel相關(guān)技巧解答的同志們。1.一、數(shù)據(jù)導(dǎo)出用Access打開數(shù)據(jù)庫，并將OriginalData導(dǎo)出到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習(xí)料上住：!rt.1期5fc4-3tan曰呂Wn:ifnA日it十rtitaEiixeTrrtQUmiHI,加：4I鴻AT-krinrw?r3.2.打開導(dǎo)出的OriginalData.xls文件和試驗(yàn)報告文件（實(shí)驗(yàn)結(jié)果中另一個以日期命名的excel文件，Tip：為方便統(tǒng)一打開與存放，可將試驗(yàn)報告文件復(fù)制到OriginalData的新工作表sheet中，可命名為report）；色眄r

3、恤BagffiE:解1511EK碣AafS血衛(wèi)兇羔T:盅J廠-J遇宅157：*AccnIdiqat宮豐白5事迅算劃31紅.血1*宅.Mh慮片苦曜&*iFi神世n一禪FJg眄黑團(tuán)ait【L?LME-ll?.ii25l盤1052.2$7M910.67D.7巫嚴(yán)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:每次更改后都點(diǎn)一下保存，以免程序卡死時丟失數(shù)據(jù)。）4.新建以試樣編號命名的sheet，有幾組試樣就建幾個sheet；二、數(shù)據(jù)處理1.篩選各個試樣的拉伸數(shù)據(jù)在OriginalData中，選中TestNo列，再點(diǎn)數(shù)據(jù)工具欄中的篩選。園|R時*e?-MicrosoftExc*t并曲ISA賈齒冇雋仝比JS遲甫聞理11D淒ifr嚴(yán)；3*Kt?目自耶占呂立申目具忠舶融耐3J*-xV、-快戕外鄙黑5SS1S徘序ft!林述：T*stXoDEF

5、6卜11IDIfiL-AjFlayTiaeLoadValuFositionEztundTckBigDefenDefqxkSw:Ctr1Stup2113#600142.0220.003475c.G00480432133600142.9220.003475*”O(jiān)O04S0I143J35600142.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電點(diǎn)擊列標(biāo)題旁的下拉箭頭，出現(xiàn)下面左圖中的對話框。ELTestAPEC31ID|TestNo|PlayTineLaadP;EL”企丘TestAB

7、cD1IDTsstNo-fPlayTimeLoadVaA.汀升序iJ降厚側(cè)按麵色掛號（JD噥從TestNo11中浦粽篩選Q拽顏蘭排呼越Mi進(jìn)迥p*(全選j138601386171386231386S*13864z13865三*13S&*13S67-r從汗旳勺中j訓(xùn)篩選按頗皀篩選數(shù)宇篩選出.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然后按照相同的步驟依次篩選該組的各個拉伸試樣的數(shù)據(jù)拷貝到該sheet中。

9、如下圖:it伸宓-MicrosoftExcel幵貯曰Access白河站白立本自賊也來逓現(xiàn)冃旺窗連捉主卻刷新T三一石塔室麼在灘sjIS,T*Bra謹(jǐn)I排序和篩陡幵曲JS貝S1布局云在PTTlKrast1?i5ffiuli_jL_iBAccess自網(wǎng)站自文審自我如5f現(xiàn)有囤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-!銅比創(chuàng)怡B0.C4111B6277.372&!0.Mia5:lO.23lID0.W1Q37342.法甜lla.001666374.&5旺120.M1B234M40220.C020L7m.3356Ua(JQ2Zl175.617150.M233950B.細(xì)帕160.豹經(jīng)苑541.J36617D.Q02M574.強(qiáng)昭出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，F(xiàn)5.町倔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=郵訃標(biāo)距Z.SSEF5O*lE_rt=0n0*131.-tx1ncdaTxn

14、fti4）調(diào)整第一行應(yīng)變與應(yīng)力值的格式，分別為百分?jǐn)?shù)與數(shù)值（四位小數(shù)）Tip:也可只調(diào)整前兩個單元格（H2和12），其余單元格可用黏貼選項(xiàng)里的格式功能來復(fù)制H2和12的格式，如下圖：5）選中第一行的應(yīng)變應(yīng)力值，雙擊填充柄，即可將公示與格式同時填充。如下圖:%*條杵格式拿用單元蹄式圏措式T迄”徘序選至掛0操械字斤鋅式年元梏6）計算其它sheet的應(yīng)變應(yīng)力值時更方便，只需將試樣參數(shù)都復(fù)制到與第一個sheet相同的位置上，然后拷貝第一個sheet的中第一行應(yīng)變與應(yīng)力值，接著選中要黏貼的單元格：右鍵一選擇性黏貼一公式與格式即可，再雙擊填充柄，一步搞定。5、origin中的數(shù)據(jù)處理1）在ori中新建wo

15、rkbook，及時改名，最好讓ori中的sheet與excel中相應(yīng)試樣組的sheet命名一致，以免混淆。2）在ori中空白位置右鍵一Addnewcolumns，使其與excel中應(yīng)變與應(yīng)力值的列數(shù)一致。3）將excel中應(yīng)變值與應(yīng)力值列copy到ori的列中。（如果顯示#，請將列寬調(diào)大一點(diǎn)）。4）如果數(shù)據(jù)導(dǎo)入后，下面的數(shù)據(jù)有出現(xiàn)多余的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中的標(biāo)題行選中，右鍵一SetAsLongName.如圖:6）將第一列和第二列的LongName改成應(yīng)力應(yīng)變曲線中軸坐標(biāo)想要顯示的名稱，并設(shè)置一二列的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點(diǎn)擊左上角的單元格，選中所有列，右鍵一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胱產(chǎn)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）然后直接點(diǎn)PlotfLineLine，即可出圖。8）雙擊坐標(biāo)軸可調(diào)整相應(yīng)參數(shù)。以下幾點(diǎn)是需要在google中搜的，我一并寫了出來。想使坐標(biāo)軸刻度顯示在坐標(biāo)軸里面，請?jiān)赥itle&Format里設(shè)置；Axis-Layer1TfettLat回MinorTick

24、Labp百Cugton丁drLabt甫ScaleTitle、FiunLGridLInegBreakSelectitShorAkis&TickTitCqLqg|BlackTtiicknestCpth5JlajorTick8ApplyT*_CaLtThiaLayer*licksLIThicknessThisLLyer+LjTickLengt確走收眉|應(yīng)用GO為使橫坐標(biāo)向下圖一樣順利地顯示百分?jǐn)?shù)；100-0|IJL|JL|51Dlii2025EngineeringStrain(%)需雙擊橫坐標(biāo)，在TickLabels中的Divideby填入0.01。如下圖:XAxisLayer1同時要想使坐標(biāo)原點(diǎn)只

25、顯示一個0”，就在Scale中將From的值設(shè)為0.01。EngineeringStrain(%)10）最后調(diào)整線的顏色及指示框等。11）若要處理其它sheet,可直接右鍵sheet標(biāo)簽Duplicatewithoutdata,然后直接拷入相應(yīng)數(shù)據(jù)，并除去多余行。這樣可省去設(shè)置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-