用Excel作地球化学微量元素蛛网图、稀土元素配分模式图以及地球化学散点图要点

1、直接利用Excel作地球化学微量元素蛛网图、稀土元素配分模式图以及地球化学散点图GeoKit,Geoplot都是很好的地球化学数据处理软件。但是怎么样直接利用Excel作地球化学微量元素蛛网图、稀土元素配分模式图以及地球化学散点图等常用地球化学图解呢？原理如下：1.准备好数据：样品名CeI花岗闪民斑岩:3T50:71.008.3531.50匚花岗闪民斑岩33.3064.707.7329.30匚花岗斑岩35.4067.907.9730.10匚花岗斑岩26.9053.306.3524.40匚夕卡岩308.00322.0014.4026.90夕卡岩8.7415.701.766.991球粒陨石:0.3

2、7:0.980.140.71CBS-1-1=C2/t9BS-1-590.73569BS-2-396.45777BS-2-573.297BS-6-8839.2371BS-6-1023.81471样品名LaCeFrNdSmEu花岗闪长斑岩37.5071.008.3531.505.791.3花岗闪长斑岩33.3064.707.7329.305.531.3花岗斑岩35.4067.907.9730.105.681.4花岗斑岩26.9053.306.3524.404.641.1夕卡岩308.00322.0014.4026.903.060.E夕卡岩8.7415.701.766.991.560.3球粒限石0.

3、370.980.140.710.230.CBS-1-1102.1798BS-1-590.73569BS-2-396.45777BS-2-573.297BS-6-8839.2371BS-6-1023.81471.2.对数据进行标7陨石的值用，鼠隹化，第一标去点击相排：输入:应的格。=样品/球如第一个样粒陨石，然品，=C2/卡后回车。C9,回车。样品和球粒UCt盘艮TVF惑血7*TbLa3T.BT1&：iS3631505T9J.£5.32a.?94.h|T088212D.4LE.Ka.-k霆酣冲良確警33.»64.TOTT3£9305S3J.345.IJa.T

4、E(.3£0创2CJ0.39E.TSa.is35.40ft?00TW30105314&5.ITfl.Tfi44008525D.K2.HI04花祐斑吿筑»S330a3524帕电M1104if-Qdtl$舶0购210D322.2QU.K餅W32JCBH种芻丸Zi)56-«曲055s£56口醋3事0W1230IEhnISTO160M1制o.aL加0!501301L0CTmIfl瑋也K石D.370WOH0710ElD.呢D.ZII0.WC.300WO23D.D4D.E5n.Q4BS-l-lES-l-5ES-2-3ES-2-5ESTTK-«-|0

5、102.179®如.T35關9e.35777712W趣23T1常.RWTL72.B2051朋.3589fT關.E矶03创一閱筋T&0.9輻血龜42336E.17518碾350361皈10斡12easiz寸壬303B41. 2095642. 33fl7t3d.3173&3T,374049. 的1的425.0649423.舗24.5血420_。矚$124&T5反T53Z4T15.517241&.40231&.£&&£?12,SdlSCa鼠4367324.储丁旳吕17. 335腔16.關9351&的5叱13

6、-5211民罂。却5JES313.曲D的13.1034513-44S2Sld_创4的良9&5517乩glflgjg11.7322311.3385Rll.E.ilSSBSlQ026茹我n乳昭乳弓1丁恥1(134078SiS70749.射融曲r.ggt®餌B.<30E0BZ9幻砒10.姻祐910.5622510642S78_JSST3E反MZ15B3矶测811.51&85m§55俯10.8_鲂£防我5,337D79工询9阍呂11.的1驹10. <K274210.5241S_即09朗此959&”瓷TB22隅11.E匀8關IL023&a

7、mp;210.7S115§_13&24.9瞬硏T£驭菲恥kl3.手动计算第一排的数,如上。然后拖动。自动计算后面的数据。如上。现在开始画图。如下，【图表向导】f【系列】W-L-IB5-L-5ES-2-3E-i-5Ets-e-aBs-ft-ifl10Z.17337SZA5190.735&9莎3閱9T勺氐45T7766410373.29f7別/閱哥335.23?mVKI23.SH71&.102565Q,9489何朗吕師翌3誦41.20&58.175184Z.3S474丽.350363431T861010$637-840412.O4S729,331

8、2242EM4的1&.51T2423.909黜15.402324.5887416.66&5720.OS&581尝4瞞£13.WS43&T8!7532474.367>T仇海215,53091.附3515.1051.&9S4213.4E2813-&24110344S3IS,98d»8.E>17氐翊同4,51055IL732ZS10,3407S11.S385B9.37(X7411.泗謁%&8829生000525k的D弼6.719165.40544)6HMIHH1Q.923旳11.51&K10.删爲10.9

9、650610.6425710.5506BL133735乱轉酹聲乩闕创69取33T0T91013348乳诃9&沏11-4939411.5481019S?4211.023&210a5241910.76115&.8709631»63K2a.9696?孔翱備rr2.7822582-4672|雨如观|:IH鼬7.i|SBEK泗1-I-EE-L-L-E-1-5M-：-：M-L-!K-t-?£-£-!A*-.NCi島：比“幻出wcKC'reKCxcuc益:K:E-L-5BS-2-3Bfi-MB?-fi-S=ShMllif&flL7=Shn

10、lL!irKJL：fF5lMi®労莞町SHS克血=EUmH£JLJEtl(V)I.BM|K上卡饷IT恬盼M|mWJ4. 分类（X）轴标志：用鼠标在表中拖动从La-到Lu,然后【确定】。如上【完成】k-1-i102,179372,SZ051冈翱即14i4.303B25.04開1鼠51T霑17.3855213.62Q6911.7322010.34073109斷911凤阴5H.4319411.54SKk-j-59QM35閃6&u35S9742336船209邸為939喲15.40(23滋&的3513.1<034511.3385S9.870fT410.56225

11、10.9550&10.274211.023&2E-2-396.57776S.64103&8.1751£腔.33計424.58E716.6&E716.8954213.82£11.58569.<1882«910.65710.9(550610.5241410.76115K-S-5T3.37&g.667萌"刃那讯却丁那20,QS&&316455813-5為41】6輕心$2冈羽鬲T,990弗9氐4强7匪£9丽丁閃乩呂口I9ER9,】匪霹2K-&-5839.23T13同2斶4105.1Q

12、95即S3報413.246T56.4367S2M9B0398.9&55176.7191§£4Q55F.542195.357079乳郭頭774.BS6ST7K-t-io23.314T11&.102S&12.£4672S312246.7532474.367B165.0326S4.3103453.5170邑弟TT23.0120483-0B9S8B2.7S22ES2.&24B72l-BS-1-l1-BS-1-EBS-2-5BS-2-5阴再-EI亠旳唧10|发现，Y轴是100,200,这样的。用鼠标放在Y轴上，右击f坐标轴格式f刻度，最大值1

13、000。对数刻度。K-J-1P102.17872-32(1510.89144.303325.0S4-9415.5172417.3356213.购。閃1L7322810u3407B10.如3的11.51511.4919411.函鼎1E-I-590.73SS96356756-45336；1.209E621狛阴g15.402316.693513.103511.33BSS旳10.562251U.-955361(1.92742ii.oes&215-39E.4b；'TT旳1閃】253.1T51642.334M2-J.586T4】札&捕強16.B954213.44E阀11-5<

14、1E$69L9E温4910,冏霭了8L生閃T馬10.W6IQ.E2419ia.TensIS-Z-5丫乳却网&閒卿呃,3503&34.3178520.08&5S12.说确13.294110.344S39002&257.990599S.SS8754Bl870968*106352：K-t-H332371330.2564105.109537.3340413.246-75L43&73215.弼0勢8.%5&176,71<116£4嗣D55.U21的5.337079L95WT4.9&&87T尸2耳l2S.8147116.1(5

15、612.&6729B31.2246.753247>.367S165.0326B4.3103>53.517062.S37723.01204A：；.2.7222SE2.6246725怙FYNdMi映制吒旳HoEi?TefbLv5. 在图中空白出右击，图表选项，填上X,Y轴，用Geokit做的图对比花樹闪嗣岩花囱融夕劣4010iaaOfSI-»SP-1QIS枇丨|M1O2.1T-98»73&696.4577TT3rZ97现zm,23.147164TOSTM5330用爲ii戲JP-F*蒔打陽石3S-1-J13-j-E1S-S-3K-*-ei23a.miD

16、.39E.7J0.4E2.gj0.4JBS-2-5ES-S-B亠EE-呂TO30.LD£4U回X-i呈4£ttOHBAfiiSBlW帕土元星蒔村隣石揃*比刃Bit!：«!¥!：T离LLtB5-TBSP舟*-*BS-tt-LOU.S385S11.356SlS?0749.938MB10.S622510.曲潮ID.9550610.S274211.0236210iVfillS10.55«Id.524114轧0D263&r.伽9$3.433T3E乞彌即翎乩阴Q9闢9U除魂fl-T191E5,製開Q55,54Z159£阴丁W94-3&am

17、p;96T74,95637751TQEN9閃723妣開80S98B32.7E22S82.6272内11.73228101344)7810.921L51&B5HL的舸11.E4S56113Ct鬥%蚩品鼬轍黑屮rfl北S右图是Geokit作的。与左图一样。17.513.315.416.3：0S1.74夕卡岩夕卡岩L.78andNcLeiman.1985球春员E0.3T0.390.141144.303S25.0649415.5172Q17.41*2095623.9393915.402342.3347424.5807416.6666716.34*31能620.0365812.6436813”1

18、6.93LS340413.246756.4367S2IE.BS-ft-8108'B5-&-lo9.0312246,7532474.367816BS-1-1花罰討氏斑岩花岗闪*斑想花茴斑岩花岗斑岩5J95.53斤661.C40劣7.737时G.3S315C28.30R3C24.4C710CB4.70閃9(153.30恣O'''IS.F1440旧翌劉選幷牡47.6839236.2397841.9618546.04905294.27794.74114472.£205160.9489166.3589756.4233&69.6410358.175

19、1854,666674S.35036330.2564105.1.09516.1025612.84672BS-6-ST6. 将第一排数据改为新的数据，发现下图中自动变化。可将此作为模版，每次填上新的数据就会自动生成图。按照上面的做法生成微量元素蛛网图：MrI養矗？In.F31F3-Z-bFl2-1-b0.0011310.000673Q.0007676.5Cr'C*0.00261S0.0004310.000862250.0002040.0000560.00009220.0007590.000448D.000390.0S0.003990,0026160.0003210.00CO.O2181&

20、amp;0,0009930.0010410.0010.0360730.0090B70.0003540.00C1209020HICIUIEIFIGIHIIF3-l-b0.0001740.000105920.0001020.0094750.000033252.90667E-051.>>1E-O51.25EF3-2-bCL000104D.00001924CL0000280.00560.000101791.10333E-05£21E-O5268EF12-l-bCk0001180.000034480.0000460.004C7&.000303610.000100967.&#

21、39;7E-0bL131!新数据&.5083510.337340.0848610.0059480.0018610.0078930.0009920.0632640.21211747230.1263690.0589520.002456001570.007145Q+0017810.0662470.23EE”9760220.H71660.0344760.0023390.0000630.005501Cl0004870.0428&90.21律品号样吕禹ThTITStIfCrC«f3-l-b黄扶矿包曩体6.5083510.337340.0848610.0059480.0018610

22、.0078930.0009920.0F3-2-b黄铁矿包褰体3.1747230.1.26369Q.0539520,Q0245G，001570,0071450.001T81aQF12-l-b黄扶矿包奏体6.976022Q.1471660.1134760,0023390.0000630.UQ55010,00043T0.0洁壳$+5252(X081209020计舁F3-l-b1.0012860.01349360.04243050.074351+5508E-0560000877196E-05Ci.0F3-2-b0.4884190.005054760.0294760.03Q6251.3083E-O57.

23、93S89E-O58.91E-O50.0F12-l-b1.0732340.00588664匕0172380.0292375乩25E-076.U22ZE-052.44E-050.0新数据6.5083516.337340.084861O.OOF9480.0018610.007S930.0009926.0632640.23.1747230.1263690.0589520.002450.001570.0071450.0017810.066247Q.297&022.0J4T16£.氏©购&3宓.0,042869,9用Excel绘制地球化学散点图记下坐标轴x为35到79。y为0到16（整数一描图时长点，变成整数）然后做XY散点图一/HLil_r_J-j.暂;XL?J召标堆类型自定文类型图表向导4步驟之1图表类型ABCDXY51452B5Q£551.14.351.24.251.35.151.45.251.54.5651.64.151.74.652,75.653.76.654.77.655.78.616-子團春类型A一.=散号孔比较戒对旳数恒按下不放可査看示例世）dl得胡吕iA莫A尙ABCXY514<525504.5.51.14.351.唸4.唸.51.'3-5.1飞1.45戈51.54.5651M4.151