Project Scheduling in Excel Workbook (Gantt Chart in Excel)

This forum is for members to share and gain knowledge of Project Management. Got a question about project management? Need help with a problem? Wish to offer tips and advice? Post here.
Post Reply
pearl.sac
New Member
New Member
Posts: 1
Joined: Sat 10 Jul 2010 4:16 pm

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.

Example:-
A B C D E F G S T U AD AE AF AG AH
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.

Regards,
Shashank Mishra
bazk

Hi,

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,

Baz
User avatar
dhaughey
Site Admin
Site Admin
Posts: 434
Joined: Sat 19 Dec 2009 4:39 pm
Location: London

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.

Duncan
satisfactionuk
Expert Member
Expert Member
Posts: 132
Joined: Wed 08 Sep 2010 1:38 pm
Location: Westminster - London

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. http://www.ganttproject.biz/
Post Reply