Create Gantt Chart from Task List

Hi,

I created a multi-functional task list & now that I think works fairly well. In the attachment, you see that it not only lists the tasks, but also list some various metrics & highlights completed, due soon or past due tasks through conditional formats.

Now, I'm trying to show a Planned vs. Actual Gantt chart. I'm hoping I don't have to drastically modify my task list template either, but I am open to revisions or suggestions or even a drastically different type of template.

I'm also struggling to figure out the "cleanest" I can present the Gantt chart by either presenting it through the worksheet columns or to produce a graphical image. Either way, I need to copy the image & put into my PowerPoint presentation as "clean" as possible.

Here's I currently have my columns set up.

In columns E & I, I have the Date Assigned & Due Date respectively. For the most part, this is my Planned duration.

In column K, I have the Date Completed. This is suppose to represent my Actual duration

Now, I'm trying to figure out on how to produce a Gantt chart from this task format that can show Planned vs. Actual either through conditional rules or through a graphical image. It would also be nice to be able to show milestones &/or dependencies, but I'm probably asking for too much.

Also MS Project does a lot of this, I find that it still has some restrictions & limited flexibility with what I am trying to do.

Look forward to your suggestions.

Thanks

Hi,

Does anyone have any suggestions?