Yuav Paub
- Xaiv thaj chaw dawb huv ntawm daim ntawv qhia Daim Ntawv Qhiantawm sab xis ntawm daim ntawv, tom qab ntawd xaiv Daim Ntawv Qhia (ntxiv kos npe).
- Txhawm rau nkaum tag nrho cov axes, tshem lub Axes kos lub thawv. Txhawm rau nkaum ib lossis ntau axes, hla Axes thiab xaiv tus arrow kom pom cov npe ntawm axes.
- Ntawm lub thawv kos rau cov axes koj xav nkaum. Xaiv lub thawv kos rau cov axes koj xav kom tso saib.
Kab lus no piav qhia yuav ua li cas tso saib, zais, thiab kho peb lub ntsiab axes (X, Y, thiab Z) hauv daim ntawv Excel. Peb tseem yuav piav qhia ntxiv txog daim duab axes feem ntau. Cov lus qhia npog Excel 2019, 2016, 2013, 2010; Excel rau Microsoft 365, thiab Excel rau Mac.
Hide and Display Chart Axes
Txhawm rau nkaum ib lossis ntau axes hauv daim ntawv Excel:
-
Xaiv thaj chaw dawb huv ntawm daim ntawv qhia Daim Ntawv Qhiantawm sab xis ntawm daim ntawv.
Image -
Xaiv Chart Elements, kos npe ntxiv (+), txhawm rau qhib Daim Ntawv Qhiamenu.
Image -
Txhob zais tag nrho cov axes, tshem tawm Axes kos lub thawv.
Image - Yuav kom nkaum ib lossis ntau axes, hla Axes kom pom tus xub sab xis.
-
Xaiv tus arrow los tso saib cov npe ntawm cov axes uas tuaj yeem pom lossis muab zais rau ntawm daim ntawv.
Image - Ntawm lub thawv kos rau cov axes koj xav nkaum.
- Xaiv lub thawv kos rau cov axes koj xav kom tso saib.
Axis yog dab tsi?
Ib axis ntawm daim duab lossis duab hauv Excel lossis Google Cov Ntawv yog kab kab rov tav lossis ntsug uas muaj cov ntsuas ntsuas. Cov axes ciam teb rau thaj tsam ntawm kab kab kos, kab kos duab, kab kab, thiab lwm yam kab kos. Ib qho axis qhia txog cov ntsuas ntsuas thiab muab ib lub thav duab ntawm kev siv rau cov ntaub ntawv pom hauv daim duab. Feem ntau cov kab kos, xws li kab thiab kab kab kos, muaj ob lub axes uas siv los ntsuas thiab faib cov ntaub ntawv:
Lub axis ntsug: Y lossis tus nqi axis.
kab kab rov tav: X lossis qeb axis.
Txhua daim ntawv axes raug txheeb xyuas los ntawm lub npe axis uas suav nrog cov chav nyob hauv axis. Bubble, radar, thiab daim duab ncuav qab zib yog qee hom kab kos uas tsis siv axes los tso saib cov ntaub ntawv.
3-D Daim Ntawv Axes
Ntxiv rau cov kab rov tav thiab ntsug, 3-D kab kos muaj peb axis. Lub z-axis, tseem hu ua qhov thib ob ntsug axis lossis qhov tob axis, cov ntaub ntawv raws qhov thib peb qhov ntev (qhov tob) ntawm daim duab.
Vertical Axis
Txoj y-axis yog nyob ntawm sab laug ntawm thaj chaw. Qhov ntsuas rau qhov axis no feem ntau yog raws li cov ntaub ntawv muaj nuj nqis uas tau teev tseg hauv daim ntawv.
Kab rov tav axis
Kab rov tav x-axis pom nyob hauv qab ntawm thaj chaw thaj chaw, thiab muaj cov npe qeb coj los ntawm cov ntaub ntawv hauv daim ntawv ua haujlwm.
Secondary Vertical Axis
Ib tug thib ob ntsug axis, uas pom nyob rau sab xis ntawm daim ntawv qhia, qhia ob lossis ntau hom ntaub ntawv hauv ib daim ntawv qhia. Nws kuj yog siv los teev cov ntaub ntawv muaj nuj nqis.
Ib daim duab huab cua lossis climatograph yog ib qho piv txwv ntawm daim ntawv qhia ua ke uas siv ob txoj kab ntsug los tso saib ob qho tib si kub thiab nag lossis daus cov ntaub ntawv piv rau lub sijhawm hauv ib daim ntawv qhia.
