To mt biu gannt trn excel

To mt biu gannt trn excel

To ra mt biu GanttMtbiu Ganttl mt biu thanh ngang thng c s dng trong cc ng dng qun l d n.Mc d Excel 2010 khng h tr to biu Ganttnhng vic to ra mt n ginbiu Gantt l kh d dng.iu quan trng l d liu ca bn phi thit lp ng:

V d trnbiu Ganttc thit lp m t mt lch trnh d n, trong phm vi tB5: D11.

Trc honh i din cho tng s khong thi gian ca d n, v mi thanh i din cho mt nhim v d n.Ngi xem c th nhanh chng nhn bit thi gian ca tng cng vic v xc nh nhim v no l chng cho.CtBcha tn nhim v, ctCcha cc ngy bt u tng ng, v ctDcha thi lng thc thi ca nhim v.Theo cc bc sau to ra biu Gantt: . 1Chn phm vi tB5: D11v sau vo thInsert, trong danh sch kiu biu , chnnt biu Bar:

Tip theo, chncm biu Bar to ra mt biu :

. 2Thc hin mt trong nhng iu sau y: Trn th Design, trongnhm Data, chnSelect Data:

Nhp chut phi vo khu vc biu v chnSelect Data ...trong popup menu:

Tronghp thoi Select Dat source: Xem d liu trongHorizontal (Category) Axis Labels cchnh xc. Tip theo trongLegend Entries (Series)thit lp d liu nh sau: Series 1:$ C $ 11: $ C $ 5 Serie 2:$ D $ 5: $ D $ 11 Horizontal (Category) Axis Labels:$ B $ 5: $ B $ 11

. 3Kch chut phi vo mt trong nhng ngy dc theo trc tung v chnFormat Axis ...trong popup menu:

Trn ca s Format Axis , iu chnh cc quy m gi tr trc honh Minimum v Maximum tng ng vi ngy bt u v ngy kt thc d n trong d liu. Bn cng c th thit lp cc n v chnh ch ra 7 tun: 4.Trnca sFormat Axischo cc trc honh: trongTy chnAxis option, thit lp cc ty chn c nhnAt maximum categoryv kim tra cc ty chn c nhndanh mc theo th t ngc:

. 5Kch chut phi vo trong dng d liu u tin v chnFormat Data Series ...trong popup menu:

lm cho dng d liu u tin v hnh, trn ca sFormat Data Series: Thit lpFillchn No fill Thit lpBorder, chnNo line

6.p dng nh dng khc nh mong mun.Bi 2:Biu GanttExcelkhng cung cp Gantt l loi biu , nhng n d dng to ra mtbiu Ganttbng cch ty bin cc loi biu thanh xp chng ln nhau.Di y bn c th tm thy d liu biu Gantt ca chng ti.

to ra mt biu Gantt, thc hin cc bc sau y.1.Trn tab Insert, nhn Bar v chnStacked Bar.

2.Nhp chut phi vo biu trng v nhp vo Select Data

3.Nhn Add v thm 2 Series (Ngy bt u (Start Date) v thi hn (Duration)).

4.Nhp vo Edit di Horizontal (Category) Axis Labels v chn phm vi A4: A11.

5.Nhn OK.

6.Nhp vo hp ghi ch pha bn phi v nhn Delete.

7.Trong Axis option chn Categories inreserve order o cng vic theo th t ngc.

8.Nhn Close.

9. khng hin th thanh StartDate (mu ), nhp chut phi vo thanh mu , nhp vo Format Data Series, nhp Fill chn Nofill, nhp vo Border chn No Line

10.Nhn Close.Ngy v thi gian nh s trong Excel v m s ngy k t ngy bt u n khi kt thc d n. V d ngy 1-jun-2012 l ging nh 41061.13-Thng By-2012 l ging nh 41.103.11.Nhp chut phi vo ngy trn biu , nhp vo Format Axis v thit lp ti thiu 41.061, ti a ti 41.103 + thi gian nhim v cui cng = 41.103 + 2 = 41105 v n v chnh 7.

12.Nhn Close.Kt qu. Ta c 01 biu Gantt trong Excel nh hnh sau:.

Lu rng thi im lp t cc ng ng dn nc v cng trnh in c th c thc hin ng thi