Hi.
I am trying to create a cool tool to create Gaant charts with minimum effort. I have seen an example of this from J.Walkenbach's excel bible, but I want to extend this with your help!
Esentially, I just want the user to specify the following:
Type of Job, Week starting (number or date or both), duration (weeks or days or both), who is assigned to do the job (initials).
I want to end up with:
week number and dates across the top as columns,
type of job listed down the side,
the people's initials printed on the center of the bars in the chart.
To take it even further, I would like to get an extra column, where one would specify % of work completed. For instance, for job no1 if the project is 80% complete, the user would type 80% in a column and 80% of the bar would be shaded in.
Not as easy as you may think....
RET79
I am trying to create a cool tool to create Gaant charts with minimum effort. I have seen an example of this from J.Walkenbach's excel bible, but I want to extend this with your help!
Esentially, I just want the user to specify the following:
Type of Job, Week starting (number or date or both), duration (weeks or days or both), who is assigned to do the job (initials).
I want to end up with:
week number and dates across the top as columns,
type of job listed down the side,
the people's initials printed on the center of the bars in the chart.
To take it even further, I would like to get an extra column, where one would specify % of work completed. For instance, for job no1 if the project is 80% complete, the user would type 80% in a column and 80% of the bar would be shaded in.
Not as easy as you may think....
RET79