Excel Gantt Chart

[jaymo]

Hello MrExcel'ers

So I've been asked by my boss to put a project managers hat on, to build a gantt chart. I don't have Project Installed so I'm relying on good old excel

I've provided an image view to show you want I'm after which in summary is to HIGHLIGHT (Column S:AA) based on a month date in column B

https://drive.google.com/file/d/1D_2WiPO9wxaCSpNqH0Jc1DP1JxXO63XJ/view?usp=sharing

So if a task/project is has a deliverable 17/09/18 (17th Sept), then in the Gannt I want Columns for July, Aug, Sept to highlight.

I hope that makes sense?

Thanks guys.

 

[jaymo]

Hi,
Can no one help? It must be possible.

 

[Zenwood]

I would start with on of the Gantt templates built in Excel. (File/New search for template)

 

[Mmaximus]

Prepare Dynamic Excel Gantt charts in Minutes and how to use them for managing simple projects efficiently.

http://www.udemy.com/easily-create-...lines-using-excel/?couponCode=EXCELGANTTOCT95

In this course Gantt charts and Timelines are prepared using Simple excel charts, without any codes or macros. So Even with basic knowledge of Excel, one will be able to use it successfully for simple projects.
It includes learning following -
1) Prepare Gantt charts, Timelines and Events in minutes.
2) Learn to measure progress with Dynamic Planned vs Actual Gantt charts.
3) Gantt chart Dashboard with slicers and Timelines.
4) A simple system to track , monitor, record and manage simple projects.

With Best Regards,