Feem ntau, cov ntaub ntawv keeb kwm muaj cov pab pawg sib txuam ntawm qhov tseem ceeb tau muab tso rau hauv cov ntawv nthuav qhia. Qhov yooj yim ntawm kev ntsuam xyuas kev vam khom uas twb muaj lawm yog kom pom kev, thiab rau qhov no koj yuav tsum tsim kom muaj lub ntsuas tsim nyog. Cov ntaub ntawv tshaj tawm Microsoft Office Excel muaj cov cuab yeej siv heev rau txoj haujlwm no, tab sis lawv tsis txhua qhov nyuaj siv.
Tsim nyog
Tabular editor Microsoft Office Excel 2007 lossis 2010
Cov Lus Qhia
Kauj ruam 1
Pib Excel thiab thauj cov ntawv nrog lub rooj xav tau rau hauv nws. Yog tias cov ntaub ntawv uas nws vam koj xav tso tawm yog nyob ntawm kab ib sab lossis kab ntawv ntawm tib daim ntawv, xaiv nws.
Kauj ruam 2
Ntawm "Ntxig" tab nyob rau hauv Excel cov zaub mov, qhib "Scatter" daim ntawv teev nco-down - nws tau muab tso rau hauv nruab nrab ntawm txoj kab ntawv sab xis ntawm cov cim ntawm "Cov Kab Cim" lus txib pab pawg. Cov npe no muaj cov duab schematic ntawm ntau hom kab sib txawv, los ntawm qhov koj yuav tsum xaiv qhov tsim nyog tshaj plaws rau kev ua kom pom cov kev sib cuam tshuam cov ntaub ntawv los ntawm koj cov lus. Tom qab ntawd, Excel yuav ntxiv peb lub tabkaub rau cov ntawv qhia zaub mov rau kev ua haujlwm nrog lub teeb, sib koom ua ke ntawm nqe "Ua Haujlwm Nrog Daim Ntawv"
Kauj ruam 3
Yog tias nyob rau thawj kauj ruam koj xaiv tau cov kab uas yuav tsum muaj, lub teeb yuav raug tsim thiab koj tuaj yeem hla tus qib no. Txwv tsis pub, tsuas yog thaj chaw khoob yuav tsim. Nyem rau ntawm "Xaiv cov ntaub ntawv" khawm hauv pob "Cov Ntaub Ntawv" pab pawg rau ntawm ib qho ntawm cov tab ntxiv - "Tus Tsim". Hauv qhov rai uas qhib, nyem "Ntxiv" khawm nyob hauv qab cov ntawv sau "Cov lus dab neeg (kab)" thiab Excel yuav pom lwm lub qhov rai uas muaj peb daim teb.
Kauj ruam 4
Hauv kab ntawv "Series name", qhia lub npe ntawm kab xwm - piv txwv li, nyem rau ntawm kab ntawv nrog lub npe ntawm cov ntaub ntawv kab. Hauv daim teb txuas ntxiv - "X Qhov Tseem Ceeb" - tso rau qhov chaw nyob ntawm ntau qhov chaw ntawm cov lej uas muaj cov lej uas txiav txim siab faib cov ntsiab lus nyob ntawm kab txiav abscissa. Qhov no tuaj yeem ua tau ob qho tib si los ntawm cov keyboard thiab los ntawm xaiv cov kab xav ntawm cov hlwb nrog nas. Tib yam, tab sis rau cov ntaub ntawv ntawm kev tsa ua, ua hauv "Y Tsim Nyog" teb.
Kauj ruam 5
Nyem rau khawm lawv xaiv nyob hauv ob lub pob qhib qhib thiab teeb tsa kev yees duab kev vam khom.
Kauj Ruam 6
Siv cov kev tswj ntawm kab ntawv "Layout" thiab "Format" tab ntawm cov ntawv teev cov khoos phis tawm kom haum raws li cov duab qauv tsim. Koj tuaj yeem hloov ob qho xim thiab fonts ntawm cov ntawv lo ntawm daim duab nws tus kheej, thiab cov tsos ntawm cov keeb kwm yav dhau. Koj tuaj yeem muab nws ntim, hloov nws cov duab, teeb xim thiab sau txheej txheem, xaiv qhov kev ntxhib los mos, thiab lwm yam.
