txheem
Excel tsis yog tsuas yog ua haujlwm nrog cov ntaub ntawv tabular. Qhov kev zov me nyuam kuj tso cai rau koj los tsim ntau hom kab kos, ntawm cov ntawv Gantt, tej zaum, tsim nyog tshwj xeeb. Qhov no yog ib qho zoo sib xws thiab nrov hom kab kos uas pom zoo li daim ntawv qhia bar nrog lub sijhawm kab rov tav. Nws tso cai rau koj los txheeb xyuas cov ntaub ntawv zoo nrog cov hnub thiab lub sijhawm. Tej zaum koj tau pom cov duab kos ntau zaus, vim lawv siv yuav luag txhua qhov chaw. Nyob rau hauv tsab xov xwm no, peb yuav piav qhia nyob rau hauv kom meej thiab step-by-step yuav ua li cas los tsim nws.
Cov ntsiab lus: "Yuav ua li cas los tsim ib daim ntawv Gantt hauv Excel"
Daim duab tsim
Txhawm rau qhia thiab piav qhia hauv txoj hauv kev siv tau li cas Gantt daim duab tsim, peb yuav siv tus piv txwv meej. Siv ib lub cim nrog cov npe ntawm cov khoom kis las, qhov twg cov hnub ntawm lawv cov khoom xa tuaj thiab lub sijhawm xa khoom raug cim.
Ua tib zoo mloog rau ib qho kev nthuav dav tseem ceeb! Kem nrog lub npe ntawm cov khoom yuav tsum tsis muaj npe - qhov no yog qhov yuav tsum tau ua ua ntej, txwv tsis pub txoj kev yuav tsis ua haujlwm. Yog hais tias ib kem muaj ib nqe lus, nws yuav tsum tau muab tshem tawm.
Yog li, cia peb pib tsim daim ntawv Gantt.
- Ua ntej tshaj, cia peb tsim ib daim duab yooj yim. Txhawm rau ua qhov no, koj yuav tsum qhia qhov xav tau ntawm lub rooj nrog tus cursor thiab nyem "Insert". Ntawm no, hauv "Histogram" thaiv, xaiv "Stacked Bar" hom. Rau peb lub hom phiaj, ntawm lwm yam, "XNUMXD stacked kab" kuj tsim nyog.
- Peb tau txais peb daim duab kos thiab peb tuaj yeem mus rau kauj ruam tom ntej.
- Tam sim no peb txoj haujlwm yog tshem tawm kab xiav, ua kom pom tsis pom. Yog li ntawd, tsuas yog strips nrog lub sijhawm xa khoom yuav tsum tau muab tso tawm. Txoj cai-nias nyob qhov twg hauv txhua kab xiav thiab nyem rau ntawm "Format Data Series ...".
- Nyob rau hauv lub qhov rai uas qhib, mus rau qhov "Fill", teeb qhov parameter no li "Tsis muaj sau" thiab tom qab ntawd kaw lub qhov rais teeb tsa.
- Raws li peb tuaj yeem pom, cov ntaub ntawv sau rau ntawm daim duab tau tshwm sim tsis yooj yim heev (los ntawm hauv qab mus rau sab saum toj), uas tuaj yeem cuam tshuam lawv cov kev txheeb xyuas. Tab sis qhov no tuaj yeem hloov tau.
- Hauv daim teb nrog cov npe khoom, nyem tus nas (txoj cai khawm) thiab xaiv cov khoom "Format Axis . ".
- Ntawm no peb xav tau ntu "Axis Parameters", los ntawm lub neej ntawd peb tsuas yog nkag mus rau tam sim ntawd. Peb tab tom nrhiav rau qhov parameter "Rov qab kev txiav txim ntawm pawg" thiab muab zuam rau pem hauv ntej ntawm nws. Tam sim no koj tuaj yeem kaw lub dialog box.
- Peb tsis xav tau cov lus dab neeg hauv daim duab no. Cia peb tshem nws los ntawm kev xaiv nws nrog tus nas thiab nias lub pob "Delete" ntawm cov keyboard.
- Ua tib zoo mloog rau ib qho kev nthuav dav. Yog hais tias, hais, koj xav qhia tsuas yog ib lub sij hawm rau ib lub xyoo daim ntawv qhia hnub, los yog ib co lwm lub sij hawm, right-click rau ntawm qhov chaw uas cov hnub nyob. Cov ntawv qhia zaub mov yuav tshwm nyob rau hauv uas peb txaus siab rau cov khoom "Format Axis ...", nyem rau ntawm nws.
- Lub qhov rais uas muaj teeb tsa yuav qhib. Ntawm no, nyob rau hauv lub axis tsis, yog tias xav tau, koj tuaj yeem teeb tsa cov hnub xav tau (yam tsawg kawg thiab siab tshaj). Tom qab kev hloov kho, kaw lub dialog box.
- Peb daim ntawv Gantt yuav luag npaj txhij, tsuas yog qhov uas tshuav yog muab nws lub npe.
- Txhawm rau ua qhov no, nyem sab laug ntawm lub npe, tom qab ntawd xaiv nws thiab kho nws raws li peb xav tau. Tsis tas li ntawd, nyob rau hauv "Tsev" tab, koj tuaj yeem, piv txwv li, teeb tsa qhov loj me thiab ua kom siab tawv.
- Ntawd yog tag nrho, peb daim ntawv Gantt tau npaj tiav.
Tau kawg, koj tuaj yeem hloov kho daim duab txuas ntxiv, vim Excel lub peev xwm tso cai rau koj los kho nws ntau npaum li koj nyiam rau qhov xav tau thiab xav tau, siv cov cuab yeej hauv "Designer" tab. Tab sis, feem ntau, tam sim no muaj peev xwm ua haujlwm nrog nws.
xaus
Thaum xub thawj siab ib muag, nws zoo nkaus li tias tsim ib daim ntawv qhia Gantt hauv Excel yog ib txoj haujlwm nyuaj uas yuav tsum tau siv sijhawm ntau thiab siv zog. Txawm li cas los xij, hauv kev xyaum nws hloov tawm tias txoj haujlwm no ua tau zoo heev thiab, ntxiv rau, siv sijhawm tsawg heev. Daim duab peb tau qhia saum toj no tsuas yog ua piv txwv xwb. Ib yam li ntawd, koj tuaj yeem tsim lwm daim duab los daws koj cov teeb meem.