甘特圖專案追蹤表 Excel 模板
填開始日與工期就自動畫出甘特條（右側時間軸），並計算進度、狀態與落後天數。範例日期以今天為基準，打開就是合理的專案狀態。
1 張
工作表
19 列
資料列
139 個
內建公式
完整內容預覽
| 甘特圖專案追蹤表 | |||||||||||
| 專案名稱： | （請輸入專案名稱） | 開始日期： | =TODAY()-WEEKDAY(TODAY(),3)-35 | 今日日期： | =TODAY() | ||||||
| ↓ 改左邊的開始／結束日期，右邊 K 欄之後的甘特條會自動跟著變 | |||||||||||
| 任務編號 | 任務名稱 | 負責人 | 開始日期 | 結束日期 | 工期(天) | 完成% | 狀態 | 前置任務 | 落後天數 | =$E$2 | =K4+7 |
| T-001 | 需求分析 | 王小明 | =$E$2+0 | =D5+4 | =E5-D5+1 | 1 | =IF(G5>=1,"已完成",IF(G5>0,"進行中","未開始")) | - | =IF(G5>=1,0,MAX(0,TODAY()-E5)) | =IF(AND($D5<=K$4+6,$E5>=K$4),IF($G5>=1,"█",IF($G5>0,"▓","░")),"") | =IF(AND($D5<=L$4+6,$E5>=L$4),IF($G5>=1,"█",IF($G5>0,"▓","░")),"") |
| T-002 | 系統設計 | 李小華 | =$E$2+7 | =D6+4 | =E6-D6+1 | 1 | =IF(G6>=1,"已完成",IF(G6>0,"進行中","未開始")) | T-001 | =IF(G6>=1,0,MAX(0,TODAY()-E6)) | =IF(AND($D6<=K$4+6,$E6>=K$4),IF($G6>=1,"█",IF($G6>0,"▓","░")),"") | =IF(AND($D6<=L$4+6,$E6>=L$4),IF($G6>=1,"█",IF($G6>0,"▓","░")),"") |
| T-003 | 前端開發 | 張大偉 | =$E$2+14 | =D7+18 | =E7-D7+1 | 0.6 | =IF(G7>=1,"已完成",IF(G7>0,"進行中","未開始")) | T-002 | =IF(G7>=1,0,MAX(0,TODAY()-E7)) | =IF(AND($D7<=K$4+6,$E7>=K$4),IF($G7>=1,"█",IF($G7>0,"▓","░")),"") | =IF(AND($D7<=L$4+6,$E7>=L$4),IF($G7>=1,"█",IF($G7>0,"▓","░")),"") |
| T-004 | 後端開發 | 陳美玲 | =$E$2+14 | =D8+25 | =E8-D8+1 | 0.45 | =IF(G8>=1,"已完成",IF(G8>0,"進行中","未開始")) | T-002 | =IF(G8>=1,0,MAX(0,TODAY()-E8)) | =IF(AND($D8<=K$4+6,$E8>=K$4),IF($G8>=1,"█",IF($G8>0,"▓","░")),"") | =IF(AND($D8<=L$4+6,$E8>=L$4),IF($G8>=1,"█",IF($G8>0,"▓","░")),"") |
| T-005 | 整合測試 | 林志豪 | =$E$2+42 | =D9+4 | =E9-D9+1 | 0 | =IF(G9>=1,"已完成",IF(G9>0,"進行中","未開始")) | T-003,T-004 | =IF(G9>=1,0,MAX(0,TODAY()-E9)) | =IF(AND($D9<=K$4+6,$E9>=K$4),IF($G9>=1,"█",IF($G9>0,"▓","░")),"") | =IF(AND($D9<=L$4+6,$E9>=L$4),IF($G9>=1,"█",IF($G9>0,"▓","░")),"") |
| T-006 | 使用者驗收 | 王小明 | =$E$2+49 | =D10+4 | =E10-D10+1 | 0 | =IF(G10>=1,"已完成",IF(G10>0,"進行中","未開始")) | T-005 | =IF(G10>=1,0,MAX(0,TODAY()-E10)) | =IF(AND($D10<=K$4+6,$E10>=K$4),IF($G10>=1,"█",IF($G10>0,"▓","░")),"") | =IF(AND($D10<=L$4+6,$E10>=L$4),IF($G10>=1,"█",IF($G10>0,"▓","░")),"") |
| T-007 | 正式上線 | 全體 | =$E$2+56 | =D11+0 | =E11-D11+1 | 0 | =IF(G11>=1,"已完成",IF(G11>0,"進行中","未開始")) | T-006 | =IF(G11>=1,0,MAX(0,TODAY()-E11)) | =IF(AND($D11<=K$4+6,$E11>=K$4),IF($G11>=1,"█",IF($G11>0,"▓","░")),"") | =IF(AND($D11<=L$4+6,$E11>=L$4),IF($G11>=1,"█",IF($G11>0,"▓","░")),"") |
| 專案統計 | |||||||||||
| 總任務數 | =COUNTA(A5:A11) | ||||||||||
| 已完成 | =COUNTIF(H5:H11,"已完成") | ||||||||||
| 進行中 | =COUNTIF(H5:H11,"進行中") | ||||||||||
| 未開始 | =COUNTIF(H5:H11,"未開始") | ||||||||||
| 整體進度 | =AVERAGE(G5:G11) | ||||||||||
| 總工期(天) | =MAX(E5:E11)-MIN(D5:D11)+1 |
內建公式，自動計算
這份模板已寫好 139 個公式，您只需要填入原始數字，合計、小計與百分比都會自動更新。 線上編輯器會即時運算，下載後在 Excel 或 Google 試算表同樣有效。
- E2
=TODAY()-WEEKDAY(TODAY(),3)-35 - H2
=TODAY() - K4
=$E$2 - L4
=K4+7 - M4
=L4+7
怎麼使用這份模板
- 1. 線上編輯：點上方「線上編輯」直接在瀏覽器修改，不需安裝任何軟體，公式即時計算。
- 2. 存到我的專案：登入後可把編輯結果存到雲端，下次接著改；也能產生唯讀分享連結給同事或客戶看。
- 3. 下載 .xlsx：需要離線使用時下載，公式與格式完整保留，可用 Excel、Google 試算表、Numbers 開啟。
專案管理類其他模板
想把「甘特圖專案追蹤表」改成貴公司的版本？
套上品牌色與 Logo、依實際內容重排版面，或整套試算表系列委託設計—— 告訴我們需求與用途，我們回覆可行做法與報價。