Bite my bytes

What I learn by day I blog at night - A blog from Microsoft Consultant working from Ljubljana, Slovenia

  Home :: Contact :: Syndication  
  999 Posts :: 7691 Comments :: 235 Trackbacks

Search

Most popular posts
in last 180 days

Categories

My Projects

Archives

Stuff


Copyright © by David Vidmar
 
Contact me!
 
LinkedIn Profile
 
 
 

Finally some time to post and finished my all-time longest bloging pause.

Mojca had to create Gantt chart last week in Word or Excel. Word seemed like a very bad idea so we chose Excel. First, we tried with draw a stacked bar graph with white and colored bars, but we gave up. One of the requisites was that x axis needed a break. In had to run from 1 to 45 and from 45 to 65, the x axis had a break from 45 to 65. We couldn't figure how to do that in Excel.

So Google had another idea. Create a Gantt chart in Excel using conditional formating. It worked great.

You can download sample Excel worksheet with a simple Gantt chart.

Posted on Tuesday, October 19, 2004 9:36 PM | Filed under: Stuff Developement |

Feedback

# re: How to create Gantt charts in Excel 8/18/2006 12:36 PM ritu
pls send sample Gannt Chart File

Thanks

ritu

# re: How to create Gantt charts in Excel 9/21/2006 1:46 PM d
WTF!!!

# re: How to create Gantt charts in Excel 2/23/2007 12:37 AM t0pc4t
mail me for gannt chart

# re: How to create Gantt charts in Excel 10/10/2007 10:19 AM bani
How to create Gantt charts in Excel

# re: How to create Gantt charts in Excel 2/8/2008 5:42 PM S
http://peltiertech.com/Excel/Charts/GanttLinks.html

# How to create Gantt charts in Excel 5/20/2008 7:35 AM Vishwajit
Dear Sir
Please guide me how to prepare Gantt Chart in MS Excel.
Instead of days, I want to put hours as time frame.

Regards
Vishwajit

# re: How to create Gantt charts in Excel with mile stone 5/26/2008 10:39 AM kamlesh R. patel
dear sir,

I have to prepare a gantt chart for our project work like building -time frame ( 15 days+ 15 days ......),machinery,electrical ,humidification,production....
also add mile stone where require. pl. help me.

regards

kamlesh


# re: How to create Gantt charts in Excel 6/10/2008 2:06 AM reenum
can someone create gantt chart using the following info:

Week # Hours Weeks

1 - 3 Shopping Chart 125 3.125
Design
Integration
Set-Up
Modification/Configuration
Testing
4 - 5.5 Ad Manager 58 1.45
Physical Layout/sizing
Configuration
View/Delete Banners
Testing
5.5 - 7.5 Mass Uploader 83 2.075
Generative Fields
Uploader Module
Image Uploader
Testing
6 - 8 MH Retail Card 33 0.825
Modify shopping for MH Gateway
Check-out Process
Customize/Integration
Testing
6 Westpac Gateway 16 0.4
Configuration w/Payment Express
Testing
1 -3 + 7 Delivery System Module 95 2.375
Database Creation
Create Control Panel
Implement Security
Login/Logout
Integration DSM with Shop Cart/Database
Testing


# re: How to create Gantt charts in Excel 8/28/2008 2:54 PM tnskumar
I have to prepare a gantt chart on EHS Management system procedures and training schedule in 16weeks. pl help me



# re: How to create Gantt charts in Excel 10/20/2008 12:54 PM TUMI
steps

# re: How to create Gantt charts in Excel 2/22/2009 1:40 AM Shazia Zahid
this can answer you qs

# re: How to create Gantt charts in Excel 2/22/2009 1:41 AM shazia
http://www.ganttchartexcel.com/

# re: How to create Gantt charts in Excel 4/21/2009 8:45 AM shreedhar
Please guide me a step by step proceedure to create a GANT CHART in excel.
please do the needy.

# how to prepare login and logout time in excel 5/30/2009 3:56 PM M. Sudhakar
Hi Team,

Please let me know how to prepare login and logout time of the employees in excel.

Thanks,
Sudhakar M.

# re: How to create Gantt charts in Excel 7/28/2009 11:32 AM seetharaman
Please guide me a step by step proceedure to create a GANT CHART in excel.
i wnat to create gantt chart for weekly work..so please help me.

# re: How to create Gantt charts in Excel 9/7/2009 11:16 AM amit kumar tiwaruy
not sufficient

# re: How to create Gantt charts in Excel 11/20/2009 10:32 AM wendy val
Please help me to writ8e a gantt chart

# re: How to create Gantt charts for planning in an organization in Excel 2/25/2011 7:55 AM kavitha
Help me in creating a gantt chart for our organization planning in excel

# re: How to create Gantt charts in Excel 5/29/2011 2:40 PM Pravin
Pls. Send me a info. n Gantt Chart

Comments have been closed on this topic.