
How to Create a Project Dashboard in Excel
Turn a task list into an Excel dashboard with completion, overdue work and a chart by status.
Build the source table
On a sheet called Tasks, use one row per task. Create columns named Task, Owner, Due Date and Status. Use consistent statuses such as Not started, In progress and Done. Enter due dates as Excel dates. Select the range, choose Insert → Table, confirm that it has headers and name the table Tasks in Table Design.
Add three measures on a Dashboard sheet
Total tasks: =COUNTA(Tasks[Task]). Completed tasks: =COUNTIF(Tasks[Status],"Done"). For completion rate, divide completed tasks by total tasks and format the result as a percentage. For example, if your total is in B2 and completed is in B3, use =IFERROR(B3/B2,0).
Track overdue items
Use =COUNTIFS(Tasks[Task],"<>",Tasks[Due Date],">0",Tasks[Due Date],"<"&TODAY(),Tasks[Status],"<>Done"). It counts named tasks with a due date before today that haven’t been marked Done. Tasks due today and rows without a date stay outside this count. Adjust the status text in the formula if your team uses a different label.
Chart the workload by status
List each status in a small summary table. If your first label is in D2, type =COUNTIF(Tasks[Status],D2) in E2 and copy it down. Select those labels and counts and insert a bar chart. Add a title such as “Tasks by status” and use a separate overdue count so it remains visible during team reviews.
Check the numbers before sharing
Try four rows: one Done, one open and overdue, one open due today and one open with no due date. The dashboard should show four tasks, one completed, 25% completion and one overdue. Add any new tasks inside the source table so the counts update.