Kab daim duab hauv Excel

Lub hauv paus ntsiab lus ntawm kev tsim cov kab ntawv bar

Cov duab kab kab hauv Excel yog siv los tso cov ntaub ntawv sib txawv sib txawv txog cov lus xaiv. Vim tias qhov no, kev xav tau tshwm sim tsis tsuas yog tsim nws, tab sis kuj tseem yuav teeb tsa raws lawv cov haujlwm. Thaum xub thawj, nws yuav tsum tau txheeb tawm txog kev xaiv ntawm daim duab kab, thiab tom qab ntawd npaj mus rau qhov hloov ntawm nws cov teeb meem.

1. Tshaj tawm qhov uas xav tau ntawm lub rooj lossis nws tag nrho, tuav lub khawm nas laug.



2. Nyem qhov ntxig tab.



3. Hauv kev thaiv nrog cov kab kos, nthuav tawm "cov ntawv qhia zaub mov" tso tawm hauv cov zaub mov thiab muaj lub pob nyem rau lwm cov histograms.



4. Yog tias koj nias lub tom kawg, ib qho tshiab "ntxig charter" lub qhov rais yuav qhib, ntawm cov npe ntau, xaiv "linely".



5. Xav txog tag nrho cov kab kos tam sim no los xaiv ib qho uas haum rau kev ua cov ntaub ntawv ua haujlwm. Cov version nrog cov pab pawg muaj kev vam meej thaum koj xav tau los sib piv cov txiaj ntsig hauv ntau hom.



6. Qhov thib ob hom yog ib txoj kab nrog kev tsub zuj zuj, tso cai rau koj mus pom kev sib npaug ntawm txhua qhov kev sib tw rau ib qho.



7. Tib hom chart, tab sis tsuas yog nrog "ib txwm" cov lus qhia sib txawv ntawm cov ntaub ntawv yav dhau los rau cov ntaub ntawv xa tawm. Ntawm no lawv tau qhia nyob rau hauv feem pua ​​piv, thiab tsis yog feem.



8. Peb hom ntawm kab ntawv hauv kab ntawv yog peb-seem. Thawj tus tsim txoj kev pab ib yam nkaus uas tau sib tham saum toj no.



9. Cov duab sib sau ib puag ncig daim duab ua rau nws pom tau ib qho sib npaug sib piv hauv ib qho.



10. Cov khoom lag luam li qub yog zoo li ob-seem, qhia cov ntaub ntawv hauv feem pua.



11. Xaiv ib daim duab kab kos, saib cov saib thiab nyem rau nkag mus ntxiv rau lub rooj. Tuav lub teeb nrog lub khawm laug nas txav nws mus rau txoj haujlwm yooj yim.

Hloov cov duab ntawm peb daim ntawv teev cov kab

Cov kab kos bar peb-seem, muaj npe nrov thiab tso cai rau koj ua kom pom tseeb ntawm cov ntaub ntawv thaum kev nthuav qhia ua haujlwm. Cov Txheej Txheem Excel muaj peev xwm hloov tau cov duab ntawm cov duab nrog cov ntaub ntawv, tawm hauv kev xaiv classic. Tom qab ntawd koj tuaj yeem hloov kho cov hom ntawm daim duab, muab nws tus neeg tsim qauv.

1. Koj tuaj yeem hloov daim duab ntawm ib daim duab kab thaum nws tau tsim nyob rau hauv ib hom peb-seem, yog li nws tam sim no yog tias lub sijhawm tseem tsis tau raug ntxiv rau lub rooj.



2. Nias LKM ntawm cov kab ntawm cov ntaub ntawv txheej txheem thiab siv kom pom txhua qhov tseem ceeb.



3. Ua kom lub khawm xis nrog tus nas txoj cai khawm thiab los ntawm cov ntawv qhia zaub mov, mus rau ntu "cov ntaub ntawv ntau".



4. Ntawm sab xis yuav qhib lub qhov rai me me uas yog lub luag haujlwm rau kev teeb tsa cov kab ntawm peb-seem. Hauv "Daim Duab" thaiv, cim lub cim tsim nyog rau hloov tus qauv thiab saib qhov tshwm sim hauv lub rooj.



5. Tam sim ntawd, qhib ntu nyob rau hauv nruab nrab lub luag hauj lwm rau kev hloov cov qauv ntawm cov duab. Hais kom nws nyem, lub contour thiab muab cov ntawv nyeem thaum tsim nyog. Tsis txhob hnov ​​qab saib xyuas cov kev hloov pauv ntawm daim duab thiab ncua lawv yog tias koj tsis nyiam qee yam.

Hloov deb ntawm cov kab kos duab

Nyob rau hauv tib cov ntawv qhia zaub mov, ua haujlwm nrog cov duab series muaj ib qho chaw sib cais uas qhib los ntawm cov kab "tsis sib xws. Nws yog lub luag haujlwm rau kev nce lossis txo qis hauv qhov sib txawv ntawm cov kab ntawm ob sab pem hauv ntej thiab sab pem hauv ntej. Xaiv qhov kev ncua deb ntawm kev txav cov swb no. Yog tias tam sim ntawd lub teeb tsis haum koj, xa rov qab lub neej ntawd (150%).

Hloov qhov chaw nyob ntawm lub axes

Qhov chaw kawg uas yuav muaj txiaj ntsig thaum ua haujlwm nrog lub sijhawm ua haujlwm - hloov qhov chaw ntawm lub axes. Nws hloov lub axis ntawm 90 degrees, ua cov zaub ntawm graph ntsug. Feem ntau, thaum koj xav tau npaj cov hom zoo sib xws, cov neeg siv xaiv lwm daim duab, tab sis qee zaus koj tuaj yeem hloov chaw ntawm qhov tam sim no.

1. Nyem rau ntawm lub axis txoj kev khawm nas.



2. Cov ntsiab lus teb cov lus qhia tshwm sim uas koj qhib lub axis lub qhov rais.



3. Nyob rau hauv nws, mus rau lub tab kawg nrog cov tsis muaj.



4. Nthuav "Kos Npe".



5. Los ntawm "txoj hauj lwm kos npe" tso-down-down-down yam uas xav tau, piv txwv li, rau sab saum toj, thiab tom qab ntawd xyuas qhov tshwm sim.