From the course: Excel: Charts in Depth
Unlock the full course today
Join today to access over 22,700 courses taught by industry experts or purchase this course individually.
Gantt charts
- [Instructor] Among the various chart types in Excel, you don't see the option a Gantt chart, and yet you can create one. These are widely used in project management scenarios, and we're seeing one on the screen right here on this worksheet called Gantt Chart. Dirt work, for example, takes 20 days. And if we were starting on January 6th in 2020, you could say, well, this is finished on the 26th. But let's say they don't work on Fridays and Saturdays, we need to make an adjusted completion date, using a function called WORKDAY. This simply does not count Saturdays and Sundays, it also has an option for not counting holidays that we're not using. So, actual completion is February 3rd. So the length of the task, not working days, but the length of the task, we subtract the two, the adjusted length. And that's going to be the number that we actually use in the chart. We see the 28th here, and we see it over to the right.…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.