Yuav ua li cas koj nyiam lub tswv yim ntawm kev ntxiv cov kab kos pom pom los ntawm cov ntsiab lus ntawm daim duab ntawm X thiab Y axes rau qee qhov ntawm koj cov kab kos?
Saib zoo, txoj cai? Ua qhov no yooj yim heev.
Cia peb tsim ib daim duab ua ntej. Xaiv qhov ntau yam nrog cov ntaub ntawv qhov chaw (hauv peb qhov piv txwv, rooj A1: B8) thiab ntawm lub tab Insert xaiv Dotted (Sib ntaus sib tua) nrog kev sib txuas ntu ntawm cov ntsiab lus:
Tam sim no cia peb ntxiv cov cim yuam kev rau cov ntsiab lus ntawm peb daim duab. Hauv Excel 2013, qhov no tuaj yeem ua tiav siv lub pob kos npe ntxiv mus rau sab xis ntawm daim ntawv los ntawm kev qhib lub checkbox Yuam Kev Yuam Kev:
Hauv Excel 2007-2010, qhov no tuaj yeem ua tiav los ntawm kev xaiv ntawm lub tab Layout khawm Yuam Kev Yuam Kev.
Feem ntau, cov ntoo khaub lig-zoo li "whiskers" yog siv los pom qhov pom ntawm daim ntawv qhia qhov raug thiab ntsuas qhov yuam kev, kam rau ua, oscillation corridors, thiab lwm yam. Txhawm rau ua qhov no, ua ntej xaiv qhov ntsug "whiskers" thiab nias lub keyboard shortcut Ctrl + 1 los yog txoj nyem rau ntawm lawv thiab xaiv cov lus txib Format Vertical yuam kev Bars. Hauv qhov rai uas qhib, koj tuaj yeem hloov lawv cov chaw teeb tsa thiab qhov ntau thiab tsawg.
Xaiv ib qho kev xaiv Custom (Kev cai) thiab nias lub pob Teeb Cov Nqi. Hauv qhov rai uas qhib, peb teeb tsa tus nqi yuam kev zoo (saum "whisker") = 0, thiab raws li qhov tsis zoo (qis "whiskers") peb xaiv cov ntaub ntawv thawj zaug raws li Y axis, piv txwv li ntau B2: B8:
Tom qab txhaj rau OK Lub sab sauv "whiskers" yuav tsum ploj mus, thiab cov hauv qab yuav tsum ncab raws nraim rau X axis, piav qhia txog kab:
Nws tseem yuav rov ua cov txheej txheem no rau kab rov tav ua yuam kev raws nraim tib txoj kev, qhia qhov zoo ntawm qhov yuam kev = 0, thiab tus nqi tsis zoo li qhov ntau A2: A8:
Cov tsos ntawm kab tuaj yeem hloov kho los ntawm txoj cai-nias ntawm lawv nrog cov lus txib Hom ntawv ntsug (kab rov tav) tuav ntawm qhov yuam kev (Format Error Bars) thiab xaiv cov xim rau lawv, ib txoj kab dotted es tsis txhob ntawm cov kab khoom, thiab lwm yam.
Yog tias koj muaj hnub tim ntawm X axis, tom qab hloov qhov loj ntawm kab rov tav qhov kev txwv tsis raug, qhov ntsuas feem ntau yuav "tsav" raws X axis thiab koj yuav tsum tau kho nws qhov tsawg kawg nkaus txwv los ntawm txoj cai-nias ntawm lub axis thiab xaiv. lus txib Hom Ntawv Axis los yog nias lub keyboard shortcut Ctrl + 1:
- Yuav ua li cas los tsim ib qho kev sib tham sib "nyob" daim duab
- Yuav ua li cas txiav xim ib daim duab hauv cov xim ntawm cov hlwb nrog cov ntaub ntawv los ntawm
- Yuav ua li cas tsim ib daim duab dej tsaws tsag