Excel Gantt Chart

[Harvey12]

Hi All,

I have a table of data and I'm trying to create a gantt chart, I have looked on numerous websites, even posted on here and I still can't get it to work, can anyone walk me through the process start to finish please?

Many thanks
Harvey

 

[RCBricker]

Hi All,

I have a table of data and I'm trying to create a gantt chart, I have looked on numerous websites, even posted on here and I still can't get it to work, can anyone walk me through the process start to finish please?

Many thanks
Harvey

This is not easy to do.

I created one with lots of rips from the internet.

It uses a Userform for creating new tasks and layers.

The first step (and only because it is easy) is to determine how you want your GANTT to look when it is finished. That way you know what you are working towards.

Step two is to list all of your tasks and determine their relationship. This is essential to project management so plan carefully.

Step three is to begin coding.

The hardest part is the WBS numbering (ie 1.1.1.2.3) and getting the tasks to layer out correctly.

The second hardest part was coding the area that tracks the time (the calendar portion) as I wanted it to be in weekdays only and account for holidays.

This will take some serious time to put together. I would suggest looking for a GANNT code that already works. the problem is then fitting your data to match the code rather than writing the code to match your data.

Is there a reason you can not use MS Project or some other project management software?

Thanks,

 

[Harvey12]

Currently I don't have access to MS Project but it is in the pipeline with managers, so maybe when it comes out, but currently I am the only one with some excel knowledge, so is there a justifiable reason as to why this isn't possible? To non-excel minds? Struggling to justify how this isn't the easiest thing to do?

 

[RCBricker]

to non-excel minds it is tricky to explain what can or cannot be done. It has been my experience that those who do not work heavily in excel AND do NOT do their workings in the higher than average skill levels, are torn between believing excel can do anything or that it can only do what they understand.

That said, a GANTT model is heavily dependent on logic. It can be done. the problem is changing existing code to meet your needs or your needs to meet the code (the former is much better). The second problem is organizing the data. Although this is less of an argument as it will need to be done before entering it into a project management program.

IF your bosses are willing to allow you the time to bring this thing together, then I say have at it. but they are going to have to understand that the length of time needed to do this yourself will be determined by the data, the code and your experience in reading and writing (and re-writing) code.

 

[Harvey12]

RCBricker, thank you ever such a lot for all of your help, it's very much appreciated.

I will speak to them about getting MS Project Manager that way I can do it easily in there.