Yuav Paub
- Xaiv kab (lossis daim duab) cuam tshuam nrog cov ntaub ntawv thib ob. Hauv qhov Chart Tools tab, xaiv Format.
- Xaiv Kev xaiv hom ntawm sab laug ntawm lub vijtsam. Xaiv Secondary Axis hauv lub vaj huam sib luag sab xis.
- Kho lub axis thib ob los ntawm kev hloov cov ntawv nyeem lossis kev taw qhia lossis tus lej hom. Qhov thib ob axis tshwm rau sab xis.
Kab lus no piav qhia yuav ua li cas ntxiv cov axis thib ob rau daim ntawv qhia hauv Excel kom koj tuaj yeem saib tsis zoo li yam ntawm tib daim duab. Cov lus qhia no ua haujlwm hauv Excel hauv Microsoft 365, Excel 2019, Excel 2016, thiab Excel 2013.
Yuav Ua Li Cas Ntxiv Qhov Thib Ob axis hauv Excel
Excel cov kab kos muab ntau txoj hauv kev rau koj pom koj cov ntaub ntawv. Rau cov kab kos uas siv X-thiab-Y-axis layout, koj muaj peev xwm saib cov ntaub ntawv, uas tso cai rau koj los sib piv ob yam sib txawv, tab sis cov khoom no feem ntau muaj tib chav ntsuas. Lub axis thib ob yog siv los sib piv ob yam uas tsis muaj qhov ntsuas tib yam.
-
Ua ntej, xaiv kab (lossis kem) cuam tshuam nrog cov ntaub ntawv thib ob.
Image -
Los ntawm xaiv ib lub ntsiab lus ntawm daim ntawv qhia, Daim Ntawv Qhia Cov cuab yeej tab yuav tshwm sim hauv kab.
Image -
Xaiv lub Format tab.
Image -
Rau rau sab laug, lub thawv Xaiv Tam sim no yuav tsum tau tso tawm cov koob uas koj xaiv. Hauv qhov piv txwv no, nws yog Series "Cov Neeg Ua Haujlwm."
Image -
Select xaiv xaiv.
Image -
Tam sim no, nyob rau hauv lub vaj huam sib luag sab xis, hauv qab Cov Kev Xaiv Series, xaiv Secondary Axis.
Image - Ib zaug ntxiv, qhov thib ob axis tuaj yeem hloov kho ib yam li thawj axis. Koj tuaj yeem hloov kho cov ntawv nyeem los yog kev taw qhia, muab nws daim ntawv lo cim axis, lossis hloov tus lej hom.
-
Tam sim no saib koj daim ntawv qhia. Qhov thib ob axis yuav tshwm nyob rau sab xis, thiab Excel yuav txawm siv qee qhov kev kwv yees hais txog qhov ntsuas. Piv rau thawj version ntawm daim ntawv qhia no, ntxiv qhov thib ob axis ua rau nws yooj yim dua los sib piv cov qauv.
Image
Thaum Koj Yuav Tsum Siv Cov axis Secondary hauv Excel
Xav txog qhov piv txwv no qhia txog lub tuam txhab cov nyiaj tau los piv rau nws cov nuj nqis rau tsib xyoos dhau los.
Ob leeg ntawm no yog ntsuas hauv las, yog li peb tuaj yeem teeb tsa ib kab teeb qhia ob qho tib si hauv qhov kev pom los txiav txim siab kev sib raug zoo.
Raws li koj tuaj yeem pom, y-axis ntawm sab laug yog tso tawm USD units, tab sis ua li cas yog tias koj xav pom tias muaj qhov sib xws li nws cuam tshuam rau cov nqi thiab cov neeg ua haujlwm? Chav tsev rau Cov Neeg Ua Haujlwm yog tib neeg, tsis yog nyiaj, yog li koj tsis tuaj yeem siv qhov y-axis uas twb muaj lawm. Qhov no yog qhov uas koj yuav tsum tau ntxiv qhov thib ob axis kom ntseeg tau tias koj cov neeg nyeem tuaj yeem nkag siab tias tus lej txhais li cas.
Ib qho laj thawj thib ob yog thaum ob lub koob tsis muaj cov ntaub ntawv hauv tib qhov loj. Xav txog, piv txwv li, cov nyiaj tau los ntawm lub tuam txhab piv rau cov neeg ua haujlwm. Daim duab saum toj no qhia tau hais tias thaum pom ua ke nws tsis muaj kev nkag siab ntau, vim tias cov neeg ua haujlwm tsawg heev koj tsis tuaj yeem txiav txim siab tias muaj dab tsi tshwm sim nrog nws.
Xwb, koj tuaj yeem ntxiv qhov axis thib ob uas muaj ob qho tib si nws tus kheej nrog rau nws tus kheej nplai, tso cai rau koj los sib piv ob qho tib si.
