Tsim kom muaj Gantt daim ntawv qhia hauv Microsoft Excel

Pin
Send
Share
Send

Ntawm ntau ntau daim duab kos duab uas tuaj yeem tsim siv siv Microsoft Excel, Gantt daim duab yuav tsum tau muab ntsiab. Nws yog kab ntawv qhia kab rov tav, rau kab rov tav kab uas yog nyob ntawm lub sijhawm. Siv nws, nws yooj yim heev rau kev xam thiab visually txiav txim lub sijhawm. Cia peb pom yuav ua li cas tsim daim ntawv Gantt hauv Microsoft Excel.

Daim phiaj kev tsim

Nws yog qhov zoo tshaj plaws los qhia cov ntsiab cai ntawm kev tsim Gantt daim qauv siv tus piv txwv tshwj xeeb. Rau qhov no, peb coj ib lub rooj ntawm cov neeg ua haujlwm ntawm lub chaw haujlwm, uas qhia txog hnub lawv tau tso tawm hnub so, thiab cov hnub so uas tsim nyog so. Txhawm rau cov txheej txheem kev ua haujlwm, nws yog qhov yuav tsum tau ua rau kem uas cov npe ntawm cov neeg ua haujlwm tsis muaj cai. Yog tias nws tsim nyog, ces lub npe ntawv yuav tsum raug tshem tawm.

Ua ntej tshaj plaws, peb tsim daim qauv duab. Txhawm rau ua qhov no, xaiv thaj chaw ntawm lub rooj, uas tau ua raws li lub hauv paus rau kev tsim kho. Mus rau kab "Sau" tab. Nyem rau ntawm "Ruled" khawm nyob ntawm lub xov. Hauv cov npe ntawm kab kos hom uas tau tshwm sim, xaiv txhua yam ntawm daim duab kos nrog kev txuam nrog. Piv txwv nyob rau hauv peb cov ntaub ntawv nws yuav yog kab ntawv volumetric bar nrog kev txuam nrog.

Tom qab ntawv, Microsoft Excel ua daim ntawv qhia no.

Tam sim no peb yuav tsum tau ua thawj kab ntawm xiav xim tsis pom kom pom tsuas yog kab qhia qhov lub sijhawm so haujlwm tseem nyob ntawm daim duab. Txoj cai-nyem rau ntawm tej seem xiav ntawm daim duab no. Hauv cov ntawv qhia ua zaub mov, xaiv cov khoom "Cov ntaub ntawv cov ntaub ntawv series ...".

Mus rau tshooj "Sau", thiab teeb tsa tus tes hloov mus rau "Tsis sau". Tom qab ntawv, nyem rau ntawm "Kaw" khawm.

Cov ntaub ntawv ntawm daim duab qhia yog nyob rau hauv qab mus rau saum, uas tsis yooj yim rau kev txheeb xyuas. Sim kho nws. Peb muaj txoj cai nyem rau ntawm lub axis uas cov npe ntawm cov neeg ua haujlwm nyob. Hauv cov ntawv qhia zaub mov, mus rau yam khoom "Axis hom".

Los ntawm lub neej ntawd, peb tau txais mus rau seem "Axis Chaw" ntu. Peb tsuas yog xav tau nws xwb. Peb muab zuam nyob tom hauv ntej ntawm tus nqi "Rov qab qeb yuam". Nyem rau ntawm "Kaw" khawm.

Cov lus dab neeg hauv Gantt daim duab tsis xav tau. Yog li, thiaj li yuav tshem tawm nws, xaiv lub pob nyem khawm nrog nas, thiab nyem rau ntawm Delete khawm ntawm cov keyboard.

Raws li koj tuaj yeem pom, lub sijhawm uas daim duab npog ntxiv mus dhau qhov ciaj ciam ntawm lub xyoo. Txhawm rau kom suav nrog lub sijhawm ib xyoos nkaus xwb, lossis ib lub sijhawm sijhawm twg, nyem rau ntawm kem (axis) uas cov hnub nyob. Hauv cov ntawv qhia zaub mov uas tshwm, xaiv hom "Axis hom" xaiv.

Hauv kab "Axis Parameters", nyob ib sab ntawm "Yam tsawg kawg nkaus" thiab "Ntau Tshaj Tus Nqi", peb hloov lub pob nyem ntawm "pib" mus rau hom "tsau". Peb tsim cov hnub uas peb xav tau nyob rau hauv cov qhov rai coj. Ntawm no, yog qhov xav tau, koj tuaj yeem tsim tus nqi ntawm cov kev sib cais loj thiab nruab nrab. Nyem rau ntawm "Kaw" khawm.

Txhawm rau thaum kawg ua tiav kho cov ntawv qhia Gantt, koj yuav tsum tau los nrog lub npe rau nws. Mus rau ntawm lub tab "Layout". Nyem rau ntawm lub pob "Daim Ntawv Npe". Hauv cov npe uas tshwm sim, xaiv tus nqi "Qauv saum toj."

Hauv daim teb uas muaj lub npe tshwm, peb sau txhua lub npe uas yooj yim rau koj, uas haum rau lub ntsiab lus.

Yog lawm, koj tuaj yeem nqa tawm ntxiv kev hloov kho ntawm qhov tshwm sim, kho nws rau koj cov kev xav tau thiab qab qab, yuav luag mus rau infinity, tab sis, feem ntau, Gantt daim ntawv npaj tiav.

Yog li, raws li koj tau pom, tsim daim phiaj Gantt tsis yog qhov nyuaj li nws zoo li thaum xub thawj siab. Tus txheej txheem kev tsim kho, uas tau piav qhia saum toj no, tuaj yeem siv tsis yog rau kev suav nyiaj thiab tswj cov hnub so, tab sis kuj tseem daws tau ntau lwm yam teeb meem.

Pin
Send
Share
Send