Yog tias koj xav ua daim phiaj hauv Excel thiab / lossis Google los xij, nws tseem ceeb kom nkag siab lub ntsiab ntawm cov ntsiab lus ntawm cov ntaub ntawv, cov cim kev qhia, thiab cov ntawv sau.
To taub kev siv cov ntawv qhia thiab lwm cov ntawv qhia hauv Excel
Ib qho chaw rau cov ntaub ntawv yog ib qho txiaj ntsig nyob hauv ib daim ntawv ntawm tes uas teev rau hauv daim duab lossis daim duab .
Cov cim qhia ntawv yog kem, taw, lub ncuav lossis lwm yam cim hauv daim duab uas sawv cev rau tus nqi hauv daim phiaj. Piv txwv, nyob rau hauv ib daim duab teeb, txhua tus taw tes rau ntawm kab yog ib qho qhia cov cim qhia txog tus nqi ntawm cov ntaub ntawv nyob hauv ib daim ntawv ntawm tes .
Ib daim ntawv qhia cov ncauj lus qhia txog cov ntaub ntawv ntawm ib tus neeg, xws li tus nqi raug muab xam los ntawm tus xov tooj los yog raws li ib feem pua.
Feem ntau siv cov ntawv sau muaj xws li:
- Numeric values ​​- muab los ntawm cov ntsiab lus ntawm tus kheej hauv cov ntawv sau ;
- Cov npe ntawm cov npe - txheeb txhua kab los yog cov qauv ntawm cov ntawv sau qhia hauv daim ntawv ua haujlwm. Lawv feem ntau siv rau kab ntawv kem, kab kos, thiab kab kab ntawv;
- Qeb npe - qhia txog cov ntsiab lus ntawm tus kheej cov ntaub ntawv nyob rau hauv ib zaug ntawm cov ntaub ntawv. Lawv nquag siv rau cov khoom noj qab zib;
- Feem pua ​​cov ntawv sau - xam los ntawm kev faib cov neeg teb hauv ib qho ntawm cov nqi tag nrho ntawm cov nyiaj. Lawv nquag siv rau cov khoom noj qab zib;
Ib cov ntaub ntawv yog ib pawg ntawm cov ntsiab lus muaj feem xyuam los yog cov cwj pwm uas tau teeb tsa hauv kab kos thiab duab. Qee cov qauv ntawm cov ntaub ntawv yog:
- Ib tug kab hauv ib kab teeb
- Txhua tus neeg hauv ib daim ntawv qhia kab ntawv
Thaum twg ntau cov ntaub ntawv series tau npaj tseg hauv ib qho qauv, txhua daim ntawv qhia tau teev muaj los ntawm ib qho xim lossis shading qauv.
Nyob rau hauv rooj plaub ntawm cov kab los yog lub kab kos, yog tias muaj ntau kab los yog tuav cov xim tib yam, los yog muaj cov duab tib yam li cov duab pictograph , lawv muaj cov ntaub ntawv ib zaug xwb.
Cov ncuav qab zib yog cov txwv tsis pub tshaj tawm rau ib cov ntaub ntawv tawm ib daim duab. Tus neeg lub ncuav ntawm lub ncuav qab zib yog cov ntaub ntawv qhia txog ntau dua li cov ntaub ntawv.
Hloov Cov Ntaub Ntawv Ntiag Tug
Yog hais tias tus kheej cov ntsiab lus ntawm cov ntaub ntawv tseem ceeb rau qee txoj kev, qhov formatting rau cov ntaub ntawv qhia tias sawv cev ntawm qhov taw qhia hauv daim phiaj yuav muab kho kom tus cim kos npe ntawm lwm cov ntsiab lus hauv cov ntawv.
Piv txwv, cov xim ntawm ib kem hauv ib daim ntawv qhia kab lossis ib qho taw tes rau hauv ib daim duab muaj peev xwm hloov tau yog tias tsis cuam tshuam lwm cov ntsiab lus hauv koob tom qab cov kauj ruam hauv qab no.
Hloov cov xim ntawm ib kem nkaus xwb
- Nyem ib zaug ntawm cov lus qhia hauv ib kem ntawv qhia. Txhua kab ntawm cov xim tib yam nyob rau hauv daim ntawv yuav tsum tau qhia. Txhua kem yog nyob ib ncig ntawm ib qho ciam teb uas muaj cov pob zeb me me ntawm cov ces kaum.
- Tshum ib zaug dua zaum thib ob ntawm kem hauv daim ntawv qhia ua ntej yuav tsum muab hloov-tsuas yog qhov sab nrauv yuav tsum tau qhia.
- Nias rau ntawm Hom ntawv ntawm cov ntawv sau, ib lub ntsiab lus tab tab ntxiv rau cov ntawv xov xwm thaum xaiv ib daim ntawv xaiv.
- Nias rau ntawm Daim Phiaj Dab Piav txog qhov qhib Phiaj Xim cov ntawv qhia.
- Nyob hauv Cheeb Tsam Xim ntawm cov ntawv qhia xaiv xiav.
Tib theem ntawm cov kauj ruam no kuj siv tau los hloov ib qho taw tes rau hauv ib kab teeb. Cia li xaiv ib qho khoom teev (marker) ntawm ib kab rau ntawm ib kem.
Exploding Pie
Vim tias ib tus neeg lub npe ntawm daim ntawv ncuav qab zib mas feem ntau txawv xim pib, qhia txog ib qho kev qhia lossis qhov taw qhia cov ntaub ntawv xav tau lwm txoj kev los ntawm kev siv rau kab thiab kab kos.
Feem ntau tseem ceeb ntxiv rau cov khoom noj qab zib tuaj yeem ua kom tawg tawm ntawm ib qho ncuav ntawm lub ncuav ntawm tas seem.
Ntxiv Tseemceeb Nrog Daim Ntawv Qhia Combo
Ib qho ntxiv rau kev qhia txog ntau hom xov xwm hauv daim duab qhia yog qhia txog ob los yog ntau daim ntawv qhia nyob hauv ib daim duab qhia tib si, xws li daim ntawv sau qhia kab ntawv thiab cov kab teeb.
Qhov kev qhia no feem ntau tshwm sim thaum tus nqi raug khwv tau los sib txawv, los yog thaum sib txawv ntawm cov ntaub ntawv raug sau. Ib qho piv txwv yog qhov climatograph lossis teeb graphic, uas yog muab cov lus xaus ntawm qhov kub thiab txias thiab ib qhov chaw rau ib daim duab.
Cov kab kos los yog cov kab kos los yog tsim tawm los ntawm plotting ib los yog ntau tshaj tawm cov ntaub ntawv rau ib theem nrab ntsug los yog Y axis.