Excel Dashboard Video Project Gantt Chart
Chandoo started a new Excel series on his blog — How to create a fully interactive Project Dashboard with Excel.
In this video for Part 1, Chandoo shows how to set up a Project Gantt Chart, and 3 more lessons in the series are coming.
Video: Project Gantt Chart in Excel
To follow along with the video, go to Chandoo’s site and download the sample files. The video timeline is below the video.
Video Timeline
00:00 – Introduction to Wendy’s PM Dashboard Problem
00:42 – Overview of the Gantt Chart
01:59 – Person & Activity data setup
02:40 – Calculation worksheet
04:20 – Gantt chart sheet setup
06:24 – Displaying Gantt with Conditional Formatting
07:53 – Filling missing columns with lookups & more CF rules
09:06 – Highlighting the current date column
10:03 – Making the Gantt interactive
10:48 – Next steps for the PM Dashboard
More Excel Dashboard Tips
For more Excel dashboard tips and videos, go to the Create a Better Excel Dashboard page on my Contextures website.
There’s also a Gantt chart example on my Contextures site, with a short video that shows how to track a simple business project.
_____________________