Yuav ua li cas Ntxiv Cov Ntawv yuam kev hauv Excel

Cov txheej txheem:

Yuav ua li cas Ntxiv Cov Ntawv yuam kev hauv Excel
Yuav ua li cas Ntxiv Cov Ntawv yuam kev hauv Excel
Anonim

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.

  1. Xaiv daim duab hauv koj daim ntawv Excel.
  2. Xaiv Daim Ntawv Qhia , sawv cev los ntawm ntsuab ntxiv (+) kos npe rau ntawm sab xis saum toj ntawm daim duab.

    Image
    Image
  3. 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
    Image

    Tus qauv yuam kev, feem pua, thiab tus qauv sib txawv tau txhais ua ntej hauv Excel.

  4. Rau qhov chaw kho kom haum ntxiv, xaiv Ntau Xaiv.

    Image
    Image
  5. The Add yuam kev Bars dialog yuav qhib. Xaiv qhov Series los hloov kho, ces xaiv OK.

    Image
    Image
  6. 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
    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.

  1. 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
    Image
  2. 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
    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.

  3. 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
    Image
  4. Qhov kawg Style muab rau koj xaiv kom muaj Cap lossis Tsis Muaj Cap ntawm qhov kawg ntawm koj qhov yuam kev Bar.

    Image
    Image
  5. 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
    Image
  6. Yog koj xaiv Custom, xaiv Specify tus nqi.

    Image
    Image
  7. Los ntawm no, koj tuaj yeem kho qhov txiaj ntsig zoo thiab tsis zoo. Thaum teeb tsa, xaiv OK.

    Image
    Image
  8. 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
    Image

Pom zoo: