Charts and Visualization

Project Plan (Gantt Chart) in Excel

Project Plan (Gantt chart) has been created in MS Excel. MS Excel cells has been used to create this. We have not used any type of chart to create this Project Plan. This is a beautiful creation and can be used in Project Management Dashboard or Business presentations.  We have used conditional formatting to create this project plan. There is a highlight option available. We can highlight any date by using this option.

Two types of status are available – Completed and pending.

Completed will displayed in the green color and Pending in Red.

Also see our other Project Plan charts


Note: Worksheet can be unprotected by using Alt+T+P+P. There is no password to un-protect the worksheet.

Project Plan in Excel
Project Plan in Excel

Click here to download the Project Planner workbook.


Watch to step by step tutorial of Project Plan in Excel-

My Name is PK. I am founder of I am a Microsoft Certified Professional. I have more than 12 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.

Leave a Reply