直接利用excel做地球化学微量、稀土配分图的方法

直接利用excel做地球化学微量、稀土配分图的方法geokit,geoplot，都能做。但是是如何做出来的呢。原理如下:准备好数据样品名LaCeFrNd花岗闪长斑岩:3T.5D：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.99]球粒陨石:037:0.980.140.71CBS-1-1二庭巾9BS-1-590.73569BS-2-396.45777BS-2-573.297BS-6-8839.2371BS-6-1023.81471样品名LaCeFeNdSmEu花岗闪长斑岩37.5071.008.3531.505.791.2花岗闪长斑岩33.3064.707.7329.305.531.2花岗斑岩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.370.980.140.710.230.CBS-1-1102.1798BS-1-590.7356996.4577773.297839.237123.81471.BS-2-3BS-2-5BS-6-8BS-6-10对数据进行标准化鼠标去点击相应的，第一排：％格。如第一，输入：=样品个样品，=C/球粒陨石，2/C9，回车。然后回车。样品和球*立陨石的值用,

UCtFrid0Ed 田. rv励itn n 场3T.5：iTl.D：«$S31SO5T9J.35 5.IE 0.794.1TO88£理D.4L E.K 0.44蒲博耳核哓谷■33.3064.TOTT3溶aS型.1.34 5.I.i fl.7&1KO刨2(JCl第 E.75 Q.42:3S.«47!»TOT勿ID5期14E 5.1.7 O.T£44£lD852曲D.» ±.fil 04]郭i如出釜凸3E24W4M110 4i< 0BD#焰D斟210。笑 ax夕卡岩做顷HMsa缶g05& ■冲 D#256Q*1轴0i« i23 0i9夕司tffl百15W】楠ew3客0M 15^ O.ftLM03Oil 。瞻 0I.-0啊5"D.ZR0w—】40.7|0Z3D.IR n.ZII 0.MC.MOWOZ5D.H D.E5 0.04ES-I.-L102.17&B也E20E160.臼始加扭303S2E064-34IE.5172417.335&213.版0链111.7S22B1&3407S10.缠翔1L516S5IL顺网1LW56ES-I-590.T35&966.358第K.4233641.2095&23.够&391L4CS31札融93S13-1034511.338539.STI37410.5&22510.-9550610.42742IL023菰BS-2-3«.J5FT76土翎103Ml.lTSie也巳3347<24.s&m1&.SS&6716..fi!35»]21SL斓自28ll.E.»]35B9.笑依10.642S7la^SBOeW32419IOlTCUSES-2-5?12&?钮-蹄66T盛3SO363d.31TS620.0365312.6d3fi333..S29311CL汹S39.00262S?.^905993.03373Sa.SS8764fl.£7096311ES3E2Efi-fi-fi83&,23T1制,2汹1板109&37-次加13.舛简56『的6传2]5,930^&9&5S1T&TJ915B.叫的|用5,54Z1635.^70790_9^9677>1.9E65T7K-fi-lO褊.-HTLlfi„102^612_Ril6729.3312246.T砧的7136观】68.033634.310^45m洒Z.9T77S3.01KMR3.DSgKlR2-THE碑Z62^1673Kl手动计算第一排的数，如上.然后拖动。自动计算后面的数据。如上。现在开始画图。如下，图表向导，系列D5-L-5E&-2-3ES-i-5BSY-fiIB*地102,17937^83J51$0.73559&&.5HS9796.^57776^6410373.29f?54.6M67839-2371350-25642a_glin1屁1皿D5-L-5E&-2-3ES-i-5BSY-fiIB*地102,17937^83J51$0.73559&&.5HS9796.^57776^6410373.29f?54.6M67839-2371350-25642a_glin1屁1皿5&60.羽脂】角3O3S56.^233641.205565S.1751842.睥74确.35036乳31T861O&.10953?-8?404虱蜘灾15,5172423.939船15.402524.59S7416.66GS7BOSSES12.S43S8|&找奇56.4336732&JSMIAC"匚17.7S5&Z1S.62M916.&99舞13.10545戚B964Z1如48器13.52^41L0L344B316.$8039&弼即件sjsaajLaoM5IL7322E10.3407S11.S385E9.370TT411.54飘j.婀8西勺“0005铝K颂强I6.7191&5,网5网6土闵7口&ajsrn10.92369U.51&K10.MS盛10.$550610.&425710.S65068.4337358.&8卵的艮S4N695.5370733.顷蔬483.顷988311-4939411.548^10.^4211.023&210/网1910.76115g.87096S土1S63E-2d_g&爵网土瓣日蜀T2.也由58A院46度名1冲 WbilH*邸1L 司而:IM如||聃囚|值W =shjr■正fcijl：irm 五II. I上上『齿也）iIT告（Mi对ISfl©J分类（X）轴标志：用鼠标在表中拖动从La-分类（X）轴标志：用鼠标在表中拖动从La-到Lu，然后确定。如上。完成K-3-IE-J-5m15-&-?E-6-IO102,1793T2.82051砌.SW9144.3038踮・。64明1&.51T24H.5856215.5206911.73223?0.73569&6.35W56.453364L2095&界噩油15.40031土6豹焚IX103451L33B58^6.45717 6S.64103 ES.1761S 的33W4 24.知舒4 1L66667 &8542 13„*1432£ 11.54SM73.Z97 5土6&街7 3KI3& K,剽7盼 20,Q36&3 1£,64558 】35踞机】5洲[路 土0C2&西839.2371 330.25^4 105.1095 37. B34O4 13.246T5 6.43&782 15.90039 8.%5517 6.U9W23.Sim H&A0256 12.£4672 9.831224 6.753247 4.367B16 5^03268 4a310345 3.5170610.340731Q.9洒911.51^11.4919411.54瞰或8T0TT410.5622510.9550610.^274211.023&2y.螂鲍10.642571U.2«=5u6Lu.5241S1176115L钩口的9ME35R9BS7&4W09&?9.186S525.405W5民5421595.3ST0799S596?T4.9S68T72.937723.U120配X0S9S882JK22SB2.&24672发现，Y轴是100，200.这样的。。用鼠标放在Y轴上，右击，坐标轴格式，刻度，最大值1000。。。对数刻度。。。

E-J-1102.1腴72-S2051就射89144.3033菠。钥狗15.5172417.奇5位13.位口的1L7322810.3407B10.盟瞬11.51&B511.4919411.M856-E-1-5如J3淞&6.353-3756„^2336如.网沮23.游S3,15.402316.6-^3513.103^51L3SESS土的如410.E6225lii.j5E.U610.927421K0(23&2IS-J-3非.4闵T7的.同】璘53.1151E碌:颁T」24-泗416-6K6T16PE95421?,44E2311.64^69-哭£24910.褶颂1挪网6JA5找1310.T6U5K-Z-5T3”湖网.&蹄67现3503&34.3178520.0S&5S12.&43SS13.能明110.344S39、如Z诡5T.990599&433馈S.SS8754E.870968^.185352E-t-H33^2371330.2564105.109537.S34M13.246-75L福阱8215.弼口盼8.螂5176,71<116 40^055.54216^5.3370794.9泌章4.yE^STTl2S.8141116.1Cr25612-&]672土血2四&.7532^7■L367S165.0326B4L3103*153.517062.S37723.01204fl2；.■::SySSS2.7E22SE2.62^672LaCePrLaCePrWd CdTbDyHqBrTii性3-BS-1-5加BS-2-5■—EXT—BSfTQ础何5期夕Z夕刑E-J-JSS-j-51S-S-31SW15*】。CePrNdSmEuCdTb珈EfoItTji¥bLu稀土元素球剧J!石标准花分布图将I十元xjtwca石蚯re让壮布以式辱7.73E9.XI5.IL0T613ETW1屿5.J70.T81.402.gl1O2.1T3S如.础何5期夕Z夕刑E-J-JSS-j-51S-S-31SW15*】。CePrNdSmEuCdTb珈EfoItTji¥bLu稀土元素球剧J!石标准花分布图将I十元xjtwca石蚯re让壮布以式辱7.73E9.XI5.IL0T613ETW1屿5.J70.T81.402.gl1O2.1T3S如.7356^196.砧?咨73.河购Z371,器.31如1株龈金际阿畋〕ESHUFi14XL.Xns&&JITiiTkU.Mi*B：5rTZ^ES>iUL^*:B【•崖］I靠漕；BS-2-5- n|分软Hgt慰fll丘MHOP：桦寸:.■住四日»-T4日MTkb-1-1B5-LT-*—BS-fli-LQ,图慕访酒J11.7322310.M07S10.9诙911.51&E511』如舸11-E.435&i11.33S5B11.&43E69l8TW49.勺甜皿10.S62251Cl€«S7也倒610.&27^210.始满勺11.02362%OOZ63&7,弗两煦3.1333735arS83T64S.S7O9&99」眼5£&T19155,如词眄5.MZlfi?5.337079土9的6口53.517052.3^723.012M8壹『顾濒％史7S2W浇£6刖目ZW-H-l右图，是geokit做的。与左图一样。。。。。BS-1-I花岗闪长诳岩1L5T1003,353150S爪1.35BS-1-5花岗闪任斑治13.364.707.7329.305.S31.34BS-2-3往岗斑岩15.45790T.OT30105.66145BS-2-5花岗斑格16.953.30B.3S24.404.641.10BS-6-8夕卡岩：0SJ2200H40a903.06056BS-6-10夕卡整1.7415.701.766.991.5B0.38IS.TaylorandNcLennanj,1985联粒陨石D.37lZS0.90D.140.710.230.00BS-1-L47.6833272.S20&160.94脂144.303825.0649415.5172117.17.5：BS-1-b36.239786&358卯56.4233641.2095623.9393915.402316.13.3拍沁t41.9618569.6410358.1751842.3347424.58S7416.6666716.15.出BS-2-546.0490554.6666746.3503634.3178620.08&S812.6436813.16.9；bs-s-®294.2779330.2564105.109537.S340413.246756.4367821&108；BS-6-104.74114416,1025612.846729.8312246.7532174.3678165.1.74；将第一排数据改为新的数据，发现下图中自动变化。可将此作为模版，每次填上新的数据就会自动生成图。$2

再来看个微量元素的蛛网图。按照上面的做法生成蛛网图，样导岳样后名ThIVStTCrc?Vi黄铁矿包裹体d0011310.0026480.0002040.0007580.003990,01)26160.000321o.00CF3-2-b黄铁矿包褒体0.0006730.00043L0.OOOOE60.000^430.0218150.000993U.0010410.001F12-1-L黄铁矿也襄体0.000767D.0008620.000092D.00039il0360730.0090870.0003540.001陆壳252p.081209020F3-l-b0.0001740.000105920.000102CLQO9如50.000033252.906&7E-D51.E1E-O5L25JF3-2-b0.00i0104Q.000019240.0000280.00560.000101791.10333E-055.21E-052.635F12-l-b(X0001180,000034^80.000046以0堂％0.00030X10,000100967J.,;7E-0b1,13E新蟀6.50S3510.33734D.0848610.0059480.001S610,0078930.000992Cl0632640.21E3+1747230.1263690.0589520.002450.00157OhOOT14S0.0017810.06&2470.23E6.976022U.0.0344760.0023390.0000630.005501Q.OOO^ST0,0428