Gnatt Chart

J

jonespandrew

New member
Joined
Jan 27, 2016
Messages
122
Reaction score
0
Points
0
Hi

I am trying to create a schedule of visits for my Landscaping teams but in Gnatt chart style

they have to do a minimum for 1 visit a week at each site but can do more
the target is 4/5 a month depending on how many weeks are in that month.

how will i got about doing this.
 
This is what I currently use

TeamSiteDurationAug 01 - Aug 07Aug 08 - Aug 14Aug 15 - Aug 21Aug 22 - Aug 28
MTWTFSSMTWTFSSMTWTFSSMTWTFSS
01020304050607080910111213141516171819202122232425262728
FranklandLow NewtonWeekly during growth seasons YY
DurhamWeekly during growth seasons YYYYY
FranklandWeekly during growth seasons YYYYY
LeedsLeedsWeekly during growth seasons y
WhetherbyWeekly during growth seasons yy
Glen ParvaFoston HallWeekly during growth seasons y
GartreeWeekly during growth seasons y
Glen ParvaWeekly during growth seasons y
LeicesterWeekly during growth seasons y
OnleyWeekly during growth seasons y
 
Reply using Go Advanced and attach the workbook here, please. On a separate sheet in it, mock up the sort of thing you are looking for.
 
Thanks - just having a look. Please note that you are asking about a GANTT chart (not gnatt). ;)
 
So which cells should be grey? When a cell has Y added to it, you want it to turn green - is that it?
 
yep but like the idea of using a different table to produce Gantt chart but using bar chart graph turned on its side.
 
Please could you provide a mock-up of the output you are wanting? You are leaving a fair bit to the imagination!
 
You must log in or register to reply here.
Back
Top