Tom qab tsim cov kab kos hauv Microsoft Excel, los ntawm lub neej ntawd, cov axes tsis ua haujlwm. Yog lawm, qhov no heev ua rau kev nkag siab txog cov ntsiab lus ntawm daim duab. Hauv qhov no, qhov teeb meem ntawm kev ua kom pom lub npe ntawm cov axes ua qhov cuam tshuam. Cia peb pom yuav ua li cas kos npe rau axis ntawm kab kos hauv Microsoft Excel, thiab yuav ua li cas rau npe lawv.
Ntsug kab ntsug lub npe
Yog li, peb muaj ib daim duab npaj tau nyob hauv qhov uas peb xav tau muab cov npe rau cov kab sib chaws.
Txhawm rau kom muab ib lub npe rau qhov ntsuas ntsug ntawm kab ntawv, mus rau "Layout" tab ntawm daim qauv wizard ntawm Microsoft Excel ribbon. Nyem rau ntawm "Axis Npe" khawm. Peb xaiv cov khoom "Lub npe ntawm lub ntsiab ntsug." Tom qab ntawv, xaiv qhov chaw npe.
Muaj peb txoj hauv kev rau qhov chaw nyob ntawm lub npe:
- Tig;
- Ntsug;
- Kab rov tav
Peb xaiv, cia hais, lub npe tig.
Lub npe duab pib tshwm hu ua Axis Npe.
Tsuas yog nyem rau ntawm nws thiab muab nws hloov mus rau lub npe uas haum rau txoj kab puag nruab nrab uas muab rau.
Yog tias koj xaiv qhov ntsug kev tso npe ntawm lub npe, tom qab ntawd cov tsos ntawm kab ntawv yuav muaj raws li hauv qab no.
Thaum muab tso ua haujlwm dhau toj, lub inscription yuav raug nthuav dav raws li hauv qab no.
Kab rov tav axis npe
Yuav luag tib txoj kev, lub npe ntawm kab rov tav yog muab.
Nyem rau ntawm "Axis Npe" khawm, tab sis lub sijhawm no xaiv "Lub npe ntawm kab rov tav tseem ceeb". Tsuas muaj ib txoj hauv kev xaiv cov chaw no nyob ntawm no - Nyob rau hauv Axis. Peb xaiv nws.
Zoo li lub sijhawm dhau los, tsuas yog nyem rau ntawm lub npe, thiab hloov lub npe mus rau ib qho uas peb xav tias tsim nyog.
Yog li, cov npe ntawm ob qho ob leeg tau muab ua haujlwm.
Hloov kab sau kab rov tav
Ntxiv rau lub npe, lub axis tau kos npe, uas yog, cov npe ntawm cov nqi ntawm txhua qhov kev faib. Nrog lawv, koj tuaj yeem ua qee qhov hloov pauv.
Txhawm rau hloov pauv qhov kos npe hom ntawm kab rov tav, nyem rau ntawm "Axis" khawm thiab xaiv tus nqi "Main kab rov tav axis" muaj. Los ntawm lub neej ntawd, qhov kev kos npe yog muab tso ntawm sab laug rau sab xis. Tab sis los ntawm txhaj rau ntawm cov khoom "Tsis Yog" lossis "Tsis muaj npe kos npe", koj tuaj yeem tso tawm feem ntawm cov zaub kos npe ntawm kab rov tav.
Thiab, tom qab txhaj rau ntawm yam khoom "Muaj cai mus rau sab laug", qhov kos npe pauv nws kev coj.
Tsis tas li, koj tuaj yeem nyem rau ntawm qhov khoom "Cov lus tsis tseem ceeb ntawm lub ntsiab kab rov tav ...".
Tom qab ntawd, lub qhov rais qhib uas muaj ntau qhov chaw rau kev teeb tsa lub axis: qhov sib txawv ntawm kev faib tawm, kab xim, cov hom ntawv kos npe ntawm cov ntaub ntawv kos npe (tus lej, nyiaj txiag, ntawv nyeem, thiab lwm yam), hom kab, kab teeb, thiab ntau ntxiv.
Hloov pauv kab lus ntsug
Txhawm rau hloov txoj kab kos npe ntsug, nyem rau ntawm pob "Axis", thiab tom qab ntawd mus rau lub npe "Main axis axis". Raws li koj tuaj yeem pom, qhov no, peb pom ntau txoj kev xaiv rau xaiv qhov kev tso kawm ntawm lub npe kos rau ntawm kab ntawv. Koj tuaj yeem hla lub axis txhua, tab sis koj tuaj yeem xaiv ib qho ntawm plaub txoj hauv kev rau kev siv cov lej:
- hauv txhiab;
- hauv lab;
- hauv ntau lab;
- nyob rau hauv daim ntawv ntawm logarithmic scale.
Raws li daim duab hauv qab no qhia peb, tom qab xaiv cov khoom tshwj xeeb, cov nplai qhov tseem ceeb hloov raws.
Ntxiv rau, koj tuaj yeem xaiv tam sim ntawd "Cov kev xaiv zoo rau lub ntsiab ntsug loj ...". Lawv zoo sib xws rau cov khoom siv tau rau kab rov tav.
Raws li koj tuaj yeem pom, kev suav cov npe thiab kos npe ntawm kev sib dhos ntawm Microsoft Excel tsis yog cov txheej txheem tshwj xeeb, thiab, feem ntau, yog kev paub tab. Tab sis, txawm li cas los xij, nws yooj yim dua rau nws, muaj ntawm tes ntawm phau ntawv qhia kom ntxaws rau kev ua. Yog li, koj tuaj yeem txuag lub sijhawm kawm cov haujlwm no.
