Page 1 of 1

Project Scheduling in Excel Workbook (Gantt Chart in Excel)

Posted: Sat 10 Jul 2010 6:42 pm
by pearl.sac
Hey Guys,
How you doing?? I got a trick and wanna share with you people. I am sure you gonna enjoy it.

Creating Gantt Chart in Excel...

First of all you need Excel 2003 or 2007 version installed in your workstation.
Open a new worksheet and type your task, start date, finish date.

1- Sr. No --- Task--- Start Date --- Finish Date 1-jul 2-jul 3-jul.............15-jul 16-jul 17-jul ........26-jul 27-jul 29-jul 30-jul 31-jul
2 - 1 --- A --- 1-Jul --- 5-Jul
3 - 2 --- B --- 5-Jul --- 9-Jul
4 - 3 --- C --- 1-Jul --- 16-Jul
5 - 4 --- D --- 10-Jul --- 15-Jul
6 - 5 --- E --- 15-Jul --- 25-Jul
7 - 6 --- F --- 25-Jul --- 30-Jul
8 - 7 --- G --- 18-Jul --- 21-Jul
9 - 8 --- H --- 4-Jul --- 19-Jul
10- 9 --- I --- 22-Jul --- 27-Jul
11 10 --- J --- 27-Jul --- 29-Jul

Column names are A,B, C.....and 1,2,3 are rows.

Now apply formula to shell E2:-- =and(E$2>=$C2,E$2<=$D2)

Copy formula and select all area where you want the bar chart, (in this case E2:AH11) and paste the formula. You will see the true and false combination everywhere on your sheet. Now copy formula from shell E2 and open conditional formatting. In conditional formatting window you will see "call value is" and corresponding arguments. Change that to "formula is" and you will see one blank box in right side. Paste the formula and select formatting to fill your cell. Now you are done. Click OK and then copy the cell E2 and select the bar chart area and press Alt+E+S+T. That's all.

Shashank Mishra

Re: Project Scheduling in Excel Workbook (Gantt Chart in Excel)

Posted: Thu 19 Aug 2010 10:16 am
by bazk

Yes you can use Excel for Project Scheduling but it's not really what Excel was designed for and how would you share the project schedule? How would you ensure version control?

To successfully schedule projects especially in an enterprise environment you need a solution like Microsoft Project Server 2010, which allows for portfolio optimisation, project selection / scheduling / resourcing etc.

Kind regards,


Re: Project Scheduling in Excel Workbook (Gantt Chart in Excel)

Posted: Tue 24 Aug 2010 10:31 pm
by dhaughey
Here is a step-by-step video guide to creating a Gantt chart using Microsoft Excel 2007.

How to Create a Gantt Chart Using Microsoft Excel

Comment: Really easy to do with clear steps.


Re: Project Scheduling in Excel Workbook (Gantt Chart in Excel)

Posted: Sun 12 Sep 2010 11:42 pm
by satisfactionuk
Why go to all that bother when you can down load a ton of free gantt chart programmes. Heres one that is quite basic but good enough for very simple projects.