From the course: Python in Excel: Getting Started with Data Analysis

Unlock the full course today

Join today to access over 24,600 courses taught by industry experts.

Create a Gantt chart

Create a Gantt chart

From the course: Python in Excel: Getting Started with Data Analysis

Start my 1-month free trial Buy for my team

Create a Gantt chart

“

- [Instructor] Excel has a lot of great chart types that it can create, but one of the ones that's missing and not built in is the Gantt chart. A Gantt chart is a horizontal bar chart that visually represents a project schedule over time. It's a pretty common project management tool that is often used for planning, scheduling, and monitoring the process of a project. So let's build one of these using Excel and Python. So here in my worksheet you can see that I have a table that represents a project I'm working on, and there are several milestones with associated dates. So I'm going to begin by making a data frame that represents the data in my project table, and we know how to do that already. So I'll make a Python cell here in B11, and then I'm going to write DF equals, and that's going to give me my data frame. And I'm going to select the data rows of the table but not the title part. So let's go ahead and commit that. And that gives me my data frame. Let's resize the formula bar a…

Contents