Yuav Paub
- Xaiv daim ntawv Excel. Xaiv lub Daim Ntawv Qhia icon (+). Xaiv Yam Bars (los yog coj mus rhaub tus xub thiab xaiv Ntau Txoj Kev Xaiv).
- In the Add Error Bars dialog uas qhib, xaiv cov koob twg los kho thiab xaiv OK. Ua kev hloov kho nyob rau sab qhov rais.
- Xaiv Yam Bars > Ntau Xaivrau qhov yuam kev bar kev taw qhia, kawg style, customized qhov tseem ceeb, thiab qhov zoo thiab qhov tsis zoo qhov yuam kev.
Kab lus no piav qhia yuav ua li cas ntxiv Cov Khaub Ncaws yuam kev rau hauv daim ntawv qhia hauv Excel. Cov ntaub ntawv no siv tau rau Excel 2019, 2016, 2013, thiab Microsoft 365.
Yuav ua li cas ntxiv yuam kev Bars hauv Excel
Txawm tias koj yog tus lej suav lossis xav tau taug qab qhov sib txawv hauv koj qhov kev muag khoom txhua hli, Kev Ua yuam kev hauv Excel tuaj yeem muab qhov pom zoo ntawm qhov tseeb npaum li cas koj cov lej lossis kev ntsuas piv rau tus nqi tiag tiag.
Ntxiv Cov Khaub Ncaws yuam kev rau koj daim ntawv Excel yog txheej txheem yooj yim. Qhov zoo tshaj plaws, yog tias koj xav tau tshem nws, tsuas yog thim rov qab cov lus qhia.
- Xaiv daim duab hauv koj daim ntawv Excel.
-
Xaiv Daim Ntawv Qhia , sawv cev los ntawm ntsuab ntxiv (+) kos npe rau ntawm sab xis saum toj ntawm daim duab.
Image -
Xaiv Error Bars. Koj tseem tuaj yeem xaiv qhov arrow ib sab ntawm qhov yuam kev Bars, tom qab ntawd xaiv Standard yuam kev, Percentage,Standard Deviation , los yog Ntau Options.
Image Tus qauv yuam kev, feem pua, thiab tus qauv sib txawv tau txhais ua ntej hauv Excel.
-
Rau qhov chaw kho kom haum ntxiv, xaiv Ntau Xaiv.
Image -
The Add yuam kev Bars dialog yuav qhib. Xaiv qhov Series los hloov kho, ces xaiv OK.
Image -
Ib lub qhov rais sab yuav qhib hauv Excel. Ntawm no koj tuaj yeem kho qhov taw qhia, Qhov kawg Style, thiab qhov yuam kev ntawm qhov yuam kev Bar siv tus nqi Tsau, Feem pua, tus qauv sib txawv, tus qauv yuam kev, lossis tsim tus nqi Custom.
Image
Siv yuam kev Bars 'Kev xaiv ntau dua
Yog tias koj xaiv los kho koj cov ntawv yuam kev hauv koj daim ntawv qhia, raws li tau piav qhia saum toj no, muaj qhov Kev Xaiv Ntxiv. Ntau Cov Kev Xaiv muab rau koj muaj peev xwm ua tau ntau yam kev hloov kho, suav nrog qee qhov xim ntawm qhov sib txawv ntawm qhov yuam kev Bars.
-
Tom qab xaiv Yam Bars > Ntau Options, koj yuav raug ceeb toom kom xaiv cov koob twg ntxiv qhov yuam kev Bars rau. Xaiv cov Series, ces xaiv OK.
Image -
Qhov yuam kev Bars sab qhov rai yuav qhib. Nyob ntawm seb hom ntawv twg koj muaj, cov kev xaiv yuav hloov me ntsis. Hauv qhov piv txwv no, xaiv kab kab rov tav kab kos.
Image kab kos kab kos tuaj yeem tso tawm ob kab kab rov tav thiab ntsug qhov yuam kev. Kom tshem tau lawv, xaiv lawv, ces nias lub Delete tus yuam sij.
-
The Kab rov tav yuam kev Bar ntu muaj 2 qhov chaw sib txawv. Hauv qab Direction, koj muaj ob peb txoj kev xaiv rau qhov yuam kev Bar:
- ob leeg: yuam kev Bar mus rau ob qho kev qhia
- Minus: yuam kev Bar mus rau sab xis ntawm kab
- Plus: yuam kev Bar mus rau sab laug ntawm kab
Image -
Qhov kawg Style muab rau koj xaiv kom muaj Cap lossis Tsis Muaj Cap ntawm qhov kawg ntawm koj qhov yuam kev Bar.
Image -
Ntu kawg teeb tsa tus nqi yuam kev. Ntawm no koj tuaj yeem teeb tsa tus nqi kho kom haum, Feem pua, lossis Standard Deviation. Koj tuaj yeem xaiv Standard yuam kev lossis Custom txhawm rau ntxiv kev hloov kho ntxiv rau qhov yuam kev.
Image -
Yog koj xaiv Custom, xaiv Specify tus nqi.
Image -
Los ntawm no, koj tuaj yeem kho qhov txiaj ntsig zoo thiab tsis zoo. Thaum teeb tsa, xaiv OK.
Image -
Koj tuaj yeem rov ua cov txheej txheem no rau txhua ntu los ntawm kev xaiv cov ntawv qhia poob qis ntawm ib sab ntawm Kev Xaiv Qhov yuam kev.
Image
