Kev nthuav tawm ntau cov ntaub ntawv sib txawv ntawm ib daim duab hauv Excel tsis pab. Hmoov tsis zoo, yog tias koj cov ntaub ntawv muaj cov chav sib txawv, koj yuav pom nws ua tsis tau lossis nyuaj los tsim cov duab tsim nyog. Nyuaj! Koj ua tau. Cov txheej txheem ntawm kev ua cov duab zoo li no yog qhov yooj yim heev! Qhov wikiHow qhia koj yuav ua li cas ntxiv ob Y-axis rau daim duab hauv Microsoft Excel.
Kauj ruam
Ntu 1 ntawm 2: Ntxiv Y-Axis Thib Ob
Kauj Ruam 1. Tsim daim ntawv nthuav qhia nrog cov ntaub ntawv uas twb muaj lawm
Txhua cov ntaub ntawv yuav tsum tau ntxiv rau hauv ib lub thawv cais nrog daim ntawv lo kab thiab kab.
Kauj Ruam 2. Xaiv cov ntaub ntawv koj xav kom teeb duab
Nyem thiab luag tus cursor txhawm rau qhia tag nrho cov ntaub ntawv koj xav kom teeb duab. Nco ntsoov tias koj kos tag nrho cov ntaub ntawv nkag thiab daim ntawv lo.
Yog tias koj tsis xav tsim lub teeb los ntawm tag nrho cov ntawv ua haujlwm, koj tuaj yeem xaiv ntau lub thawv los ntawm kev tuav tus yuam sij Ctrl thiab nyem rau txhua lub thawv uas koj xav siv los ua cov ntaub ntawv teeb tsa
Kauj Ruam 3. Nyem Ntxig
Nws nyob hauv cov ntawv qhia zaub mov nyob rau sab saum toj ntawm nplooj ntawv. "Insert" vaj huam sib luag yuav tshwm rau saum lub qhov rais Excel.
Kauj Ruam 4. Nyem rau lub cim uas zoo li hom duab koj xav tsim
Tom qab ntawd, daim duab yuav raug tsim raws cov ntaub ntawv xaiv.
Koj kuj tseem tuaj yeem ntxiv ob txoj kab rau kab kab lossis kab kab
Kauj Ruam 5. Nyem ob npaug rau kab uas koj xav tau ntxiv rau lub axis thib ob
Yog tias koj nyem ib zaug, txhua cov ntaub ntawv nkag ntawm kab yuav raug cim. Yog tias koj ob npaug nias nws, cov ntawv "Format Data Point" cov zaub mov yuav tshwm rau ntawm sab xis ntawm kab ntawv.
Kauj Ruam 6. Nyem rau lub cim uas zoo li kab duab kab
Lub cim no yog "Kev Xaiv Series" lub cim xaiv. Koj tuaj yeem pom nws nyob rau sab saum toj ntawm "Format Data Point" ntawv qhia zaub mov, ntawm sab xis.
Kauj Ruam 7. Xaiv lub pob "Secondary Axis" xov tooj cua
Lub pob no nyob hauv "Cov Qauv Xaiv" hauv "Ntawv Qhia Cov Ntaub Ntawv". Kab ntawm kab thib ob nrog tus lej ntawm nws sab xis yuav tshwm.
Ntu 2 ntawm 2: Hloov Tus Qauv Zais Zaum Ob
Kauj Ruam 1. Txoj cai-nias kab ntawv
Cov kab ntawv feem ntau tshwm rau hauv nruab nrab ntawm daim ntawv Excel. Cov ntawv qhia zaub mov tshiab yuav tshwm tom ntej ntawm kab kab.
Kauj Ruam 2. Nyem Hloov Cov Qauv Kab Qauv
Qhov kho kom raug lub qhov rai yuav tshwm tom qab ntawd.
Kauj Ruam 3. Nyem rau ntawm lub npov nyob ib sab ntawm lwm kab uas koj xav ntxiv rau Y axis
Txhawm rau ntxiv lwm txoj kab rau Y-axis, nyem rau ntawm lub npov nyob hauv qab "Y-axis", mus rau sab xis ntawm koob lossis cov ntaub ntawv series nyob rau sab qis-sab xis ntawm lub qhov rais.
Kauj Ruam 4. Xaiv hom kab ntawv rau txhua cov ntaub ntawv
Ntxiv rau kev teeb duab xaiv cov ntaub ntawv teeb tsa rau cais Y-axis, koj tseem tuaj yeem sawv cev cov ntaub ntawv nrog lwm hom kab ntawv. Siv cov ntawv qhia zaub mov nco-down xaiv hom kab ntawv rau txhua cov ntaub ntawv series lossis kab nyob rau hauv qis-txoj cai ces kaum ntawm lub qhov rais.
Kauj Ruam 5. Nyem Ok
Kev hloov pauv hauv daim duab yuav raug cawm.
