Yuav ua li cas los tsim ib daim ntawv qhia Gantt hauv Excel?

Yog tias koj raug nug kom sau peb lub ntsiab lus tseem ceeb tshaj plaws ntawm Microsoft Excel, koj yuav npe dab tsi? Feem ntau, cov nplooj ntawv uas cov ntaub ntawv nkag mus, cov qauv uas siv los ua kev suav, thiab cov kab kos uas cov ntaub ntawv ntawm qhov sib txawv tuaj yeem sawv cev rau cov duab.

Kuv paub tseeb tias txhua tus neeg siv Excel paub tias daim ntawv yog dab tsi thiab yuav tsim nws li cas. Txawm li cas los xij, muaj ib hom kab ntawv uas tau muab zais rau hauv qhov tsis meej rau ntau tus - Gantt daim ntawv qhia. Cov lus qhia ceev no yuav piav qhia txog cov yam ntxwv tseem ceeb ntawm Gantt daim ntawv qhia, qhia koj yuav ua li cas thiaj li yooj yim Gantt daim ntawv qhia hauv Excel, qhia koj qhov twg mus rub tawm Gantt daim ntawv qhia qib siab, thiab yuav ua li cas siv Project Management online pabcuam los tsim Gantt kab kos.

• Gantt daim ntawv yog dab tsi?
• Yuav ua li cas los tsim ib daim ntawv qhia Gantt hauv Excel?
• Gantt daim duab templates

Gantt daim ntawv yog dab tsi?

Gantt daim ntawv qhia muaj npe tom qab Henry Gantt, tus kws tshaj lij Asmeskas thiab tus kws tshaj lij kev tswj hwm uas tau los nrog daim duab qhia xyoo 1910. Gantt daim ntawv hauv Excel sawv cev rau cov haujlwm lossis cov haujlwm ua ib qho kev sib tw ntawm kab kab rov tav kab kos. Daim ntawv qhia Gantt qhia txog cov qauv tawg ntawm qhov project (hnub pib thiab ua tiav, ntau yam kev sib raug zoo ntawm cov haujlwm hauv qhov project) thiab yog li pab tswj kev ua tiav cov haujlwm hauv lub sijhawm thiab raws li cov qauv ntsuas.

Yuav Ua Li Cas Tsim Gantt Chart hauv Excel 2010, 2007 thiab 2013

Hmoov tsis zoo, Microsoft Excel tsis muaj cov qauv tsim hauv Gantt. Txawm li cas los xij, koj tuaj yeem tsim koj tus kheej sai sai siv cov ntawv qhia ua haujlwm thiab me ntsis ntawm formatting.

Ua raws li cov kauj ruam no ua tib zoo thiab nws yuav siv sijhawm tsis pub dhau 3 feeb los tsim ib daim ntawv qhia Gantt yooj yim. Hauv peb cov piv txwv, peb tab tom tsim ib daim ntawv qhia Gantt hauv Excel 2010, tab sis tib yam tuaj yeem ua tiav hauv Excel 2007 thiab 2013.

Kauj ruam 1. Tsim ib qhov project rooj

Ua ntej tshaj plaws, peb yuav nkag mus rau qhov project cov ntaub ntawv rau hauv daim ntawv Excel. Sau txhua txoj haujlwm ntawm ib txoj kab sib cais thiab tsim kom muaj kev npaj ua tiav los ntawm kev qhia meej hnub pib (Pib hnub tim), kawm tiav (hnub kawg) thiab ntev (Lub Sij Hawm), uas yog, pes tsawg hnub nws yuav siv sij hawm los ua kom tiav txoj haujlwm.

Tswv yim: Tsuas yog cov kab uas xav tau los tsim daim ntawv Gantt Pib hnub и Duration. Txawm li cas los xij, yog tias koj kuj tsim ib kab Hnub kawg, Tom qab ntawd koj tuaj yeem xam lub sijhawm ntawm txoj haujlwm uas siv cov qauv yooj yim, raws li pom hauv daim duab hauv qab no:

Kauj ruam 2. Tsim ib daim ntawv qhia Excel tsis tu ncua raws li "Start date" kem database

Pib tsim ib daim ntawv Gantt hauv Excel los ntawm kev tsim ib qho yooj yim stacked bar daim ntawv qhia:

• Highlight ib qhov ntau Pib Cov Hnub nrog rau kab ntawv kab lus, hauv peb qhov piv txwv nws yog B1: IB 11. Nws yog ib qho tsim nyog los xaiv tsuas yog cov hlwb nrog cov ntaub ntawv, thiab tsis yog tag nrho cov kem ntawm daim ntawv.
• Hauv Advanced tab Insert (Ntxig) hauv kab ntawv, nyem Ntxig daim ntawv qhia bar (Bar).
• Hauv cov ntawv qhia zaub mov uas qhib, hauv pab pawg Kav liam (2-D Bar) nyem Txoj Cai Stacked (Stacked Bar).

Yog li ntawd, daim ntawv qhia hauv qab no yuav tsum tshwm sim ntawm daim ntawv:

Nco ntsoov: Qee qhov ntawm lwm cov lus qhia rau kev tsim Gantt kab kos qhia tias koj ua ntej tsim ib daim ntawv qhia khoob thiab tom qab ntawd sau nws nrog cov ntaub ntawv, raws li peb yuav ua hauv cov kauj ruam tom ntej. Tab sis kuv xav tias txoj kev qhia tau zoo dua vim Microsoft Excel yuav cia li ntxiv ib kab ntawm cov ntaub ntawv thiab txoj kev no peb yuav txuag tau qee lub sijhawm.

Kauj ruam 3: Ntxiv cov ntaub ntawv Duration rau daim ntawv

Tom ntej no, peb yuav tsum ntxiv ib cov ntaub ntawv ntxiv rau peb daim ntawv Gantt yav tom ntej.

1. Right-click nyob qhov twg hauv daim duab thiab hauv cov ntawv qhia zaub mov nyem Xaiv cov ntaub ntawv (Xaiv cov ntaub ntawv).A dialog box yuav qhib Xaiv cov ntaub ntawv qhov chaw (Xaiv Data Source). Raws li koj tuaj yeem pom hauv daim duab hauv qab no, cov ntaub ntawv kab ke pib Hnub twb ntxiv rau hauv daim teb Cov lus dab neeg (kab) (Cov lus dab neeg nkag (Series). Tam sim no koj yuav tsum tau ntxiv cov kab ke ntawm no Duration.
2. xovxwm Ntxiv (Ntxiv) xaiv cov ntaub ntawv ntxiv (Lub Sij Hawm) los tso saib ntawm Gantt daim ntawv.
3. Nyob rau hauv lub qhov rais qhib Kab hloov (Kho kom raug series) ua li no:
   • Nyob rau hauv lub Row npe (Series lub npe) nkag mus rau "Lub Sij Hawm" lossis lwm lub npe koj xav tau. Lossis koj tuaj yeem tso tus cursor rau hauv daim teb no thiab tom qab ntawd nyem rau ntawm lub npe ntawm kab sib txuas hauv lub rooj - lub npe uas tau nyem rau ntawm yuav raug ntxiv raws li lub npe series rau Gantt daim ntawv.
   • Nyem qhov ntau yam xaiv icon nyob ib sab ntawm daim teb Cov nqi (Series qhov tseem ceeb).
4. Dialog qhov rais Kab hloov (Kho kom raug series) yuav txo. Qhia cov ntaub ntawv hauv ib kab Durationlos ntawm txhaj rau thawj lub xov tooj (hauv peb rooj plaub nws yog D2) thiab rub mus rau cov ntaub ntawv kawg ntawm tes (D11). Nco ntsoov tias koj tsis txhob yuam kev xaiv ib nqe lus lossis qee lub xov tooj khoob.
5. Nias lub icon xaiv ntau dua. Dialog qhov rais Kab hloov (Hloov koob) yuav nthuav dav dua thiab cov teb yuav tshwm sim Row npe (Series npe) thiab Cov nqi (Series qhov tseem ceeb). Nyem OK.
6. Peb mam li rov qab mus rau lub qhov rais dua Xaiv cov ntaub ntawv qhov chaw (Xaiv Data Source). Tam sim no nyob rau hauv teb Cov lus dab neeg (kab) (Lus dab neeg nkag (Series) peb pom ib series pib Hnub thiab tus lej DurationCov. Tsuas nyem OK, thiab cov ntaub ntawv yuav muab ntxiv rau hauv daim ntawv.

Daim duab yuav tsum zoo li no:

Kauj Ruam 4: Ntxiv Cov Lus Qhia Ua Haujlwm rau Gantt Chart

Tam sim no koj yuav tsum tau qhia ib daim ntawv teev cov hauj lwm nyob rau sab laug ntawm daim duab es tsis txhob cov zauv.

1. Txoj cai-nias nyob qhov twg hauv thaj chaw plotting (qhov chaw nrog xiav thiab txiv kab ntxwv kab txaij) thiab hauv cov ntawv qhia zaub mov uas tshwm, nyem Xaiv cov ntaub ntawv (Xaiv cov ntaub ntawv) rov tshwm sim dua lub dialog box Xaiv cov ntaub ntawv qhov chaw (Xaiv Data Source).
2. Nyob rau sab laug ntawm lub dialog box, xaiv pib Hnub Thiab nias qhov hloov (Kho kom raug) nyob rau hauv txoj cai cheeb tsam ntawm lub qhov rais npe Kab rov tav axis labels (categories) ( Kab rov tav (Qeb) Axis Labels).
3. Ib lub thawv me me yuav qhib Axis daim ntawv lo (Axis daim ntawv lo). Tam sim no koj yuav tsum xaiv cov haujlwm zoo ib yam li hauv cov kauj ruam dhau los peb xaiv cov ntaub ntawv ntawm lub sijhawm ua haujlwm (Cov Sijhawm kem) - nyem qhov ntau yam xaiv icon, tom qab ntawd nyem rau ntawm thawj txoj haujlwm hauv lub rooj thiab luag xaiv nrog tus nas nqes mus rau txoj haujlwm kawg. Nco ntsoov tias cov kab ntawv kab lus yuav tsum tsis txhob muab qhov tseem ceeb. Thaum koj ua tiav qhov ntawd, nyem qhov ntau yam xaiv icon dua kom coj mus rau lub dialog box.
4. Ob chav kais OKkaw tag nrho cov dialog box.
5. Rho tawm daim ntawv qhia lus dab neeg - right-click rau nws thiab nyob rau hauv cov ntsiab lus teb ntawv qhia zaub mov nyem tshem tawm (Rho tawm).

Lub sijhawm no, Gantt daim ntawv yuav tsum muaj cov lus piav qhia ua haujlwm ntawm sab laug thiab saib qee yam zoo li no:

Kauj ruam 5: Hloov daim ntawv qhia bar mus rau Gantt Chart

Nyob rau theem no, peb daim ntawv qhia tseem yog ib daim ntawv teev cov kab ntawv. Txhawm rau ua kom nws zoo li Gantt daim ntawv qhia, koj yuav tsum format nws kom raug. Peb txoj haujlwm yog tshem tawm cov kab xiav kom tsuas yog cov txiv kab ntxwv ntawm cov duab kos, uas sawv cev rau cov dej num ntawm qhov project, tseem pom. Technically, peb yuav tsis tshem cov kab xiav, peb tsuas yog ua kom lawv pob tshab thiab yog li tsis pom.

1. Nyem rau ntawm ib kab xiav ntawm Gantt daim ntawv, thiab txhua tus ntawm lawv yuav raug xaiv. Txoj cai-nias ntawm kev xaiv thiab hauv cov ntsiab lus teb cov ntawv qhia nyem Cov ntaub ntawv series (Format Data Series).
2. Hauv lub dialog box uas tshwm sim, ua cov hauv qab no:
   • Hauv seem Sau (Fill) xaiv Tsis muaj puv (Tsis Sau).
   • Hauv seem ciam teb (Border Xim) xaiv tsis muaj kab (Tsis muaj kab).

Nco ntsoov: Tsis txhob kaw lub dialog box no, koj yuav xav tau nws dua nyob rau hauv cov kauj ruam tom ntej.

3. Cov haujlwm ntawm Gantt daim ntawv uas peb tsim hauv Excel yog nyob rau hauv qhov kev txiav txim rov qab. Peb yuav kho qhov ntawd ib pliag. Nyem rau ntawm daim ntawv teev cov haujlwm nyob rau sab laug ntawm Gantt daim ntawv qhia kom pom cov qeb axis. Ib lub dialog box yuav qhib Axis Format (Format Axis). Hauv tshooj Axis parameters (Axis Options) khij lub npov Rov qab kev txiav txim ntawm pawg (Cov pawg nyob rau hauv qhov kev txiav txim rov qab), ces kaw lub qhov rais kom txuag koj cov kev hloov pauv.Raws li cov kev hloov pauv peb nyuam qhuav ua:
   • Cov dej num ntawm Gantt daim ntawv qhia yog nyob rau hauv qhov tseeb.
   • Cov hnub nyob rau ntawm kab rov tav axis tau txav los ntawm hauv qab mus rau sab saum toj ntawm daim ntawv.

Daim ntawv qhia zoo ib yam li Gantt daim ntawv qhia, txoj cai? Piv txwv li, kuv daim ntawv Gantt tam sim no zoo li no:

Kauj ruam 6. Customizing Gantt Chart Design hauv Excel

Daim duab Gantt twb tau ua zoo lawm, tab sis koj tuaj yeem ntxiv ob peb qhov kev ua tiav ntxiv kom nws zoo nkauj tiag tiag.

1. Tshem tawm qhov chaw khoob ntawm sab laug ntawm Gantt daim ntawv

Thaum tsim ib daim ntawv qhia Gantt, peb muab cov kab xiav tso rau ntawm qhov pib ntawm daim ntawv qhia hnub pib. Tam sim no qhov khoob uas tseem nyob hauv lawv qhov chaw tuaj yeem raug tshem tawm thiab cov haujlwm strips tuaj yeem txav mus rau sab laug, ze rau ntawm txoj kab ntsug.

• Txoj cai nyem rau ntawm thawj kab ntawv tus nqi pib Hnub nyob rau hauv lub rooj nrog cov ntaub ntawv qhov chaw, nyob rau hauv lub ntsiab lus teb ntawv qhia zaub mov xaiv Cell format > Number > General (Format Cells > Number > General). Nco tus lej koj pom hauv daim teb qauv (Sample) yog tus lej sawv cev ntawm hnub. Hauv kuv rooj plaub no tus lej 41730. Raws li koj paub, Excel khaws cov hnub ua cov lej sib npaug rau cov hnub hnub tim 1 Lub Ib Hlis, 1900 ua ntej hnub no (qhov twg Lub Ib Hlis 1, 1900 = 1). Koj tsis tas yuav hloov pauv ntawm no, tsuas yog nyem kev tshem tawm (Tau tseg).
• Ntawm Gantt daim ntawv qhia, nyem rau ntawm hnub twg saum toj no daim ntawv. Ib nias yuav xaiv tag nrho cov hnub, tom qab ntawd right-click rau lawv thiab nyob rau hauv cov ntsiab lus teb ntawv qhia zaub mov nyem Axis Format (Format Axis).
• Ntawm cov ntawv qhia zaub mov tsis axis (Axis Options) hloov qhov kev xaiv Yam tsawg kawg nkaus (yam tsawg kawg) rau Number (Txhim kho) thiab sau tus lej koj nco qab hauv cov kauj ruam dhau los.

2. Kho cov hnub ntawm cov axis ntawm daim ntawv Gantt

Ntawm no, nyob rau hauv lub dialog box Axis Format (Format Axis) uas tau qhib nyob rau hauv cov kauj ruam dhau los, hloov cov tsis Kev faib loj (Major united) thiab Kev faib nruab nrab (Minor unit) ntawm Number (Txhim kho) thiab nkag mus rau qhov xav tau qhov tseem ceeb rau cov ntu ntawm cov axis. Feem ntau, lub sijhawm luv luv ntawm cov haujlwm hauv qhov project, qhov me dua qhov kev faib cov kauj ruam yog xav tau ntawm lub sijhawm axis. Piv txwv li, yog tias koj xav qhia txhua hnub thib ob, ces nkag mus 2 rau parameter Kev faib loj (Qhov loj unit). Qhov chaw kuv tau ua - koj tuaj yeem pom hauv daim duab hauv qab no:

Tswv yim: Ua si ncig nrog cov chaw kom txog thaum koj tau txais qhov xav tau. Tsis txhob ntshai ua ib yam dab tsi tsis ncaj ncees lawm, koj tuaj yeem rov qab mus rau qhov chaw pib los ntawm kev teeb tsa cov kev xaiv rau Txav (Auto) hauv Excel 2010 thiab 2007 lossis los ntawm txhaj Pib dua (Reset) hauv Excel 2013.

3. Tshem tawm qhov seem seem ntawm cov kab txaij

Npaj cov haujlwm tuav ntawm daim ntawv qhia ntau dua, thiab Gantt daim ntawv yuav zoo dua.

• Xaiv cov txiv kab ntxwv kab ntawm cov duab los ntawm txhaj rau ib qho ntawm lawv nrog rau sab laug nas khawm, ces right-click rau nws thiab hauv cov ntawv qhia zaub mov uas tshwm, nyem Cov ntaub ntawv series (Format Data Series).
• Nyob rau hauv lub dialog box Cov ntaub ntawv series (Format Data Series) teeb qhov parameter rau overlapping kab (Series Overlap) tus nqi 100% (slider txav mus rau sab xis), thiab rau qhov ntsuas Sab clearance (Gap Width) tus nqi 0% lossis yuav luag 0% (slider tag nrho txoj kev lossis yuav luag txhua txoj kev mus rau sab laug).

Thiab ntawm no yog qhov tshwm sim ntawm peb qhov kev siv zog - ib qho yooj yim tab sis muaj tseeb Gantt daim ntawv hauv Excel:

Nco ntsoov tias daim ntawv Excel tsim nyob rau hauv txoj kev no yog ze rau daim ntawv qhia Gantt tiag tiag, thaum khaws txhua qhov yooj yim ntawm Excel kab ntawv:

• Daim ntawv Gantt hauv Excel yuav hloov pauv thaum ua haujlwm ntxiv lossis tshem tawm.
• Hloov hnub pib ntawm txoj haujlwm (Pib hnub) lossis nws lub sijhawm (Lub Sijhawm Sijhawm), thiab lub sijhawm yuav tau txais kev cuam tshuam tam sim ntawm cov kev hloov pauv.
• Daim ntawv Gantt tsim hauv Excel tuaj yeem khaws cia ua duab lossis hloov mus rau hom HTML thiab luam tawm hauv Is Taws Nem.

Tswv yim:

• Customize lub ntsej muag ntawm koj daim ntawv Gantt los ntawm kev hloov cov kev xaiv sau, ciam teb, duab ntxoov ntxoo, thiab txawm siv cov teebmeem 3D. Tag nrho cov kev xaiv no muaj nyob rau hauv lub dialog box. Cov ntaub ntawv series (Format Data Series). Txhawm rau hu rau lub qhov rais no, right-click rau ntawm daim ntawv qhia bar hauv daim duab kos duab thiab hauv cov ntawv qhia zaub mov nyem Cov ntaub ntawv series (Format Data Series).
• Yog tias tus qauv tsim tsim tau zoo rau lub qhov muag, ces xws li Gantt daim ntawv tuaj yeem khaws cia hauv Excel ua tus qauv thiab siv yav tom ntej. Txhawm rau ua qhov no, nyem rau ntawm daim duab, qhib lub tab constructor (Tsim) thiab nias Txuag li template (Txuag li Template).

Download tau tus qauv Gantt chart

Gantt chart template hauv Excel

Raws li koj tuaj yeem pom, tsim ib daim ntawv qhia yooj yim Gantt hauv Excel tsis nyuaj txhua. Tab sis yuav ua li cas yog tias yuav tsum muaj daim ntawv qhia Gantt complex, nyob rau hauv cov hauj lwm shading nyob ntawm feem pua ​​​​ntawm nws ua tiav, thiab cov phiaj xwm tseem ceeb tau qhia los ntawm kab ntsug? Tau kawg, yog tias koj yog ib qho ntawm cov tsis tshua muaj thiab tsis paub dab tsi uas peb hwm hu ua Excel Guru, ces koj tuaj yeem sim ua cov duab kos koj tus kheej.

Txawm li cas los xij, nws yuav nrawm dua thiab yooj yim dua los siv Gantt daim ntawv qhia ua ntej hauv Excel. Hauv qab no yog cov ntsiab lus luv luv ntawm ntau qhov kev tswj hwm qhov project Gantt chart templates rau ntau yam ntawm Microsoft Excel.

Microsoft Excel 2013 Gantt Chart Template

Qhov no Gantt daim ntawv template rau Excel hu ua Tus Npaj Txoj Haujlwm (Gantt Project Planner). Nws yog tsim los taug qab qhov project kev nce qib tiv thaiv ntau yam kev ntsuas xws li Npaj pib (Plan Start) thiab pib tiag tiag (Qhov pib tiag tiag), Lub sijhawm npaj (Plan Duration) thiab Lub sijhawm tiag tiag (Lub Sij Hawm Tiag), thiab Feem pua ​​​​ua tiav (Percent tiav).

Hauv Excel 2013, cov qauv no muaj nyob rau ntawm tab cov ntaub ntawv (Cov ntaub ntawv) nyob rau hauv lub qhov rais tsim (Tshiab). Yog tias tsis muaj tus qauv hauv ntu no, koj tuaj yeem rub tawm los ntawm Microsoft lub vev xaib. Tsis muaj kev paub ntxiv uas yuav tsum tau siv cov qauv no - nyem rau ntawm nws thiab pib.

Online Template Daim duab Ganta

Smartsheet.com muaj kev sib tham sib online Gantt Chart Builder. Daim duab Gantt no tsuas yog yooj yim thiab npaj siv raws li yav dhau los. Cov kev pabcuam muaj 30-hnub sim pub dawb, yog li xav tias dawb mus sau npe nrog koj tus lej Google thiab pib tsim koj thawj daim ntawv Gantt tam sim ntawd.

Cov txheej txheem yog yooj yim heev: nyob rau hauv lub rooj ntawm sab laug, nkag mus rau cov ntsiab lus ntawm koj qhov project, thiab raws li lub rooj nyob rau hauv, ib daim ntawv Gantt yog tsim nyob rau sab xis.

Gantt Chart Templates rau Excel, Google Sheets thiab OpenOffice Calc

Ntawm vertex42.com koj tuaj yeem nrhiav Gantt chart templates dawb rau Excel 2003, 2007, 2010 thiab 2013 uas tseem yuav ua haujlwm nrog OpenOffice Calc thiab Google Sheets. Koj tuaj yeem ua haujlwm nrog cov qauv no ib yam li koj xav nrog txhua daim ntawv Excel niaj hnub. Tsuas yog sau hnub pib thiab sijhawm rau txhua txoj haujlwm thiab nkag mus rau % ua tiav hauv kab % ua tiav. Txhawm rau hloov hnub tim uas pom nyob rau hauv Gantt daim ntawv qhia cheeb tsam, txav lub slider ntawm lub scroll bar.

Thiab thaum kawg, lwm tus qauv Gantt daim duab hauv Excel rau koj qhov kev txiav txim siab.

Project Manager Gantt Chart Template

Lwm tus qauv Gantt daim duab pub dawb muaj nyob ntawm professionalexcel.com thiab hu ua "Project Manager Gantt Chart". Hauv cov qauv no, nws tuaj yeem xaiv qhov pom (txhua hnub lossis tus qauv txhua lub limtiam), nyob ntawm lub sijhawm ntawm cov haujlwm uas tau taug qab.

Kuv vam tias tsawg kawg yog ib qho ntawm Gantt daim ntawv qhia templates yuav haum koj cov kev xav tau. Yog tias tsis yog, koj tuaj yeem pom ntau yam sib txawv ntawm Gantt daim duab qauv hauv Is Taws Nem.

Tam sim no koj paub cov yam ntxwv tseem ceeb ntawm Gantt daim duab, koj tuaj yeem kawm txuas ntxiv nws thiab kawm yuav ua li cas los tsim koj tus kheej Gantt kab kos hauv Excel kom ua rau koj xav tsis thoob koj tus thawj coj thiab tag nrho koj cov npoj yaig 🙂