txheem
Nyob rau hauv zaj lus qhia kawg, peb tau paub txog hom kab kos hauv Excel, tshuaj xyuas lawv cov ntsiab lus tseem ceeb, thiab tseem tsim cov histogram yooj yim. Hauv zaj lus qhia no, peb yuav txuas ntxiv mus paub txog cov duab kos, tab sis nyob rau theem siab dua. Peb yuav kawm yuav ua li cas los tsim cov kab kos hauv Excel, txav lawv ntawm nplooj ntawv, tshem tawm thiab ntxiv cov ntsiab lus, thiab ntau ntxiv.
Daim duab layout thiab style
Tau ntxig ib daim ntawv rau hauv Excel daim ntawv ua haujlwm, feem ntau nws yuav tsum tau hloov qee cov ntaub ntawv tso saib xaiv. Layout thiab style tuaj yeem hloov pauv ntawm lub tab constructor. Nov yog qee qhov kev ua uas muaj:
- Excel tso cai rau koj ntxiv cov ntsiab lus xws li cov npe, cov lus dab neeg, cov ntawv sau, thiab lwm yam rau koj daim ntawv. Cov ntsiab lus ntxiv pab txhawb kev nkag siab thiab nce cov ntsiab lus ntawm cov ntaub ntawv. Txhawm rau ntxiv cov khoom, nyem rau ntawm qhov hais kom ua Ntxiv Chart Element tab constructor, thiab tom qab ntawd xaiv qhov koj xav tau los ntawm cov ntawv qhia zaub mov nco-down.
- Txhawm rau hloov cov khoom, xws li lub npe, nyem ob npaug rau nws thiab kho nws.
- Yog tias koj tsis xav ntxiv cov ntsiab lus ntawm tus kheej, koj tuaj yeem siv ib qho ntawm cov txheej txheem preset. Txhawm rau ua qhov no, nyem rau ntawm qhov hais kom ua Qhia layout, thiab tom qab ntawd xaiv qhov xav tau layout los ntawm cov ntawv qhia zaub mov poob.
- Excel muaj ntau tus qauv uas tso cai rau koj hloov pauv sai sai ntawm koj daim ntawv qhia. Txhawm rau siv cov style, xaiv nws hauv pawg hais kom ua Daim duab style.
Koj tuaj yeem siv cov khawm shortcut formatting ntxiv cov ntsiab lus rau daim ntawv, hloov cov style, lossis lim cov ntaub ntawv.
Lwm Txoj Kev Xaiv Daim Ntawv Qhia
Muaj ntau ntau txoj hauv kev los kho cov kab kos thiab style. Piv txwv li, Excel tso cai rau koj los txheeb xyuas cov ntaub ntawv qub, hloov hom, thiab txawm txav daim ntawv mus rau ib daim ntawv cais.
Hloov kab thiab kab
Qee lub sij hawm koj yuav tsum tau hloov pauv cov ntaub ntawv hauv pawg hauv Excel li cas. Hauv qhov piv txwv hauv qab no, cov ntaub ntawv tau muab faib los ntawm xyoo thiab cov ntaub ntawv series yog hom. Txawm li cas los xij, peb tuaj yeem hloov cov kab thiab kab kom cov ntaub ntawv tau muab faib ua ib hom ntawv. Nyob rau hauv ob qho tib si, daim ntawv qhia muaj tib cov ntaub ntawv tab sis raug teeb tsa sib txawv.
- Xaiv daim duab koj xav hloov.
- Hauv Advanced tab constructor nias hais kom ua Kab kab.
- Kab thiab kab yuav hloov ib leeg. Hauv peb qhov piv txwv, cov ntaub ntawv tam sim no tau muab faib ua ib hom ntawv thiab cov ntaub ntawv series tau dhau los ua xyoo.
Hloov hom kab ntawv hauv Excel
Yog tias koj pom tias daim duab tam sim no tsis haum rau cov ntaub ntawv uas twb muaj lawm, koj tuaj yeem hloov mus rau lwm hom. Hauv qhov piv txwv hauv qab no, peb yuav hloov hom kab kos los ntawm Cov Keeb Kwm on Timetable.
- Hauv Advanced tab constructor nyem command Hloov hom kab kos.
- Nyob rau hauv lub dialog box uas tshwm Hloov hom kab kos xaiv ib hom kab ntawv tshiab thiab layout, ces nias OK. Hauv peb qhov piv txwv, peb yuav xaiv Timetable.
- Hom kab ntawv xaiv tau tshwm sim. Hauv qhov piv txwv tam sim no, koj tuaj yeem pom qhov ntawd Timetable ntau kom meej meej conveys dynamics ntawm kev muag khoom thaum lub sij hawm muaj.
Txav ib daim duab hauv Excel
Thaum muab tso rau, daim duab pom zoo li ib yam khoom ntawm tib daim ntawv raws li cov ntaub ntawv. Hauv Excel, qhov no tshwm sim los ntawm lub neej ntawd. Yog tias tsim nyog, koj tuaj yeem txav daim duab mus rau ib daim ntawv cais kom zoo dua tso cov ntaub ntawv.
- Xaiv daim duab koj xav txav.
- nias lub constructor, ces nias hais kom ua Txav Daim Ntawv.
- Ib lub dialog box yuav qhib Tsiv daim duab. Xaiv qhov chaw xav tau. Hauv qhov piv txwv tam sim no, peb yuav muab daim duab tso rau ntawm ib daim ntawv cais thiab muab nws lub npe Phau ntawv muag 2008-2012.
- Xovxwm OK.
- Daim duab yuav raug tsiv mus rau qhov chaw tshiab. Hauv peb cov ntaub ntawv, qhov no yog daim ntawv peb nyuam qhuav tsim.
