txheem
Qee lub sij hawm nws tuaj yeem nyuaj kom sai thiab ua tau zoo raws li lub sijhawm ntawm cov haujlwm. Ib daim duab sawv cev ntawm lub sijhawm kawg ntawm qhov project thiab cov ntsiab lus tseem ceeb yuav pab txheeb xyuas cov kev tsis sib haum xeeb thaum lub sijhawm npaj.
Tau kawg, nws tsim nyog xav txog kev siv cov kev tswj xyuas qhov project. Xws li ib qho system yuav qhia lub sijhawm pib thiab xaus ntawm qhov haujlwm ntawm qhov project tiv thaiv keeb kwm yav dhau. Tab sis xws li tshuab yog kim heev! Lwm qhov kev daws teeb meem yog sim siv Excel ncua sij hawm bar daim ntawv qhia thaum npaj kom pom txhua qhov tsis sib haum xeeb hauv qhov project. Kev koom tes nrog pab pawg thiab nrog cov kws tshaj lij thib peb yuav yooj yim dua yog tias qhov kev ua ntawm txhua tus tuaj yeem pom ntawm tib daim ntawv!
Hmoov tsis zoo, tsim lub sijhawm ncua sijhawm hauv Microsoft Excel tsis yog ib txoj haujlwm yooj yim. Kuv tsis xav kom tsim ib daim ntawv qhia Gantt hauv Excel, tab sis lub sijhawm yooj yim tuaj yeem tsim los ntawm kev ua raws li peb cov lus qhia ib kauj ruam:
Kauj ruam 1: Npaj cov ntaub ntawv
Yuav pib nrog, peb xav tau ib lub rooj ntaub ntawv, nyob rau sab laug kem uas (kem А) muaj tag nrho cov npe ua haujlwm, thiab ob kab ntawm sab xis yog tshwj tseg rau hnub pib thiab lub sijhawm ua haujlwm (kem В и С).
Kauj ruam 2: Tsim ib daim duab
Taw qhia cov ntaub ntawv npaj tau, tom qab ntawd ntawm lub tab Insert (Ntxig) hauv ntu Kev kuaj mob (Chav) nyem Txoj Cai Stacked (Stacked Bar).
Kauj Ruam 3: Npaj cov ntaub ntawv ntawm daim duab kom raug
Cov kauj ruam no yog qhov nyuaj tshaj plaws, raws li daim ntawv qhia pib nrog cov ntaub ntawv raug nyob rau hauv qhov chaw tsis ncaj ncees lawm, yog tias cov ntaub ntawv ntawd puas tau tshwm sim hauv daim ntawv!
Nias lub khawm Xaiv cov ntaub ntawv (Xaiv cov ntaub ntawv) tab constructor (tsim). Xyuas seb muaj dab tsi hauv cheeb tsam Cov lus dab neeg (kab) (Lus dab neeg nkag (Series)) ob lub ntsiab lus tau sau - Lub Sijhawm (Lub Sijhawm Sijhawm) thiab hnub pib (Start Date). Yuav tsum muaj ob lub ntsiab lus no xwb.
Cia kuv twv. Puas yog tag nrho cov ntaub ntawv tau txav los yog txav mus rau sab? Cia peb kho nws.
Txhawm rau kho koj cov ntaub ntawv, nyem Ntxiv (Ntxiv) los yog hloov ( Kho kom raug ) hauv cheeb tsam Cov lus dab neeg (kab) (Lus dab neeg nkag (Series)). Txhawm rau ntxiv Hnub Pib, qhia lub cell B1 hauv tshav pob Row npe (Series Name), thiab hauv daim teb Cov nqi (Series Values) – ntau B2: IB 13. Ib yam li ntawd, koj tuaj yeem ntxiv lossis hloov lub sijhawm ua haujlwm (Lub Sijhawm) - hauv thaj chaw Row npe (Series Name) qhia ib lub xovtooj C1, thiab hauv teb Cov nqi (Series Values) – ntau C2: ua 13.
Txhawm rau kho cov pawg, nyem lub pob hloov ( Kho kom raug ) hauv cheeb tsam Kab rov tav axis labels (categories) ( Kab rov tav (Qeb) Axis Labels). Cov ntaub ntawv ntau yuav tsum tau teev tseg ntawm no:
=Лист3!$A$2:$A$13
=Sheet3!$A$2:$A$13
Nyob rau ntawm lub sijhawm no, daim ntawv yuav tsum zoo li ib daim ntawv sib dhos nrog cov npe ua haujlwm ntawm txoj kab ntsug thiab cov hnub ntawm kab rov tav.
Kauj ruam 4: Tig qhov tshwm sim rau hauv daim ntawv Gantt
Txhua yam uas tseem yuav tsum tau ua yog hloov cov xim puv ntawm sab laug ntawm tag nrho cov txiaj ntsig cov kab tuav mus rau dawb lossis pob tshab.
★ Nyeem ntxiv txog kev tsim ib daim ntawv qhia Gantt hauv kab lus: → Yuav ua li cas los tsim ib daim ntawv Gantt hauv Excel - cov lus qhia ib kauj ruam
Kauj ruam 5: Txhim kho qhov zoo ntawm daim duab
Cov kauj ruam kawg yog ua kom daim duab zoo nkauj kom nws tuaj yeem xa mus rau tus thawj tswj hwm. Tshawb xyuas cov kab rov tav: tsuas yog qhov project ncua sij hawm tuav yuav tsum pom, piv txwv li peb yuav tsum tshem tawm qhov khoob uas tau tshwm sim hauv cov kauj ruam dhau los. Right-click rau kab rov tav axis ntawm daim ntawv. Ib lub vaj huam sib luag yuav tshwm sim Axis parameters (Axis Options), uas koj tuaj yeem hloov qhov tsawg kawg nkaus tus nqi ntawm axis. Customize cov xim ntawm Gantt chart bars, teem ib yam dab tsi nthuav. Thaum kawg, tsis txhob hnov qab lub npe.
Timeline hauv Excel (Gantt chart) tuaj yeem siv rau ntau lub hom phiaj. Kev tswj hwm yuav txaus siab tias koj tuaj yeem tsim lub sijhawm zoo li no yam tsis muaj kev siv nyiaj ntxiv ntawm kev yuav cov software tswj hwm qhov project kim!