Excel 2010 : Gantt Chart help request

[pritishkamal]

Hi All,

Need some assistance with excel 2010. I have two columns (mentioned below), corresponding to that I need to highlight the weeks cells in the rows on that particular week column (as gantt chart) for which this effort is expected to last.

Start Date	Scheduled Due Date
22-Jul	23-Aug
15-Jun	30-Jun
30-Jul	5-Aug
18-Jul	29-Feb
30-Jun	25-Jul

<colgroup><col><col></colgroup><tbody>
</tbody>

Nov 1st Week

Nov 2nd Week

Nov 3rd Week

Nov 4th Week

Nov 5th Week

<colgroup><col><col><col><col span="2"></colgroup><tbody>
</tbody>

A quick response is really appreciated, need urgent help, please suggest.

 

[pritishkamal]

I am in desperate need of a response, please help.

 

[AhoyNC]

Maybe attached link will be of some help.

How To...Create a Basic Gantt Chart in Excel 2010 - YouTube

 

[pritishkamal]

Thanks for the reply Ahoy, actual issue is not creating the gantt chart but creating a week column wrt given dates and in turn putting a conditional formatting.

Maybe attached link will be of some help.

How To...Create a Basic Gantt Chart in Excel 2010 - YouTube