Forum Discussion
Gannt Chart
I created a Gannt chart using the simple Gannt chart template for staffing. As the weeks progress, I am finding that the date moves but the data in the cells does not. For example, people marked as being on vacation one week are then marked incorrectly when the weeks move forward. Is there a way to have the week AND data associated with those days move forward so that the information remains correct? Hope that makes sense.
SarahP1109 But you shouldn't put anything in the grid of a Gantt chart. Everything is driven by conditional formats, based on the start and end dates in E and F and the dates in row 5. Putting numbers and characters in the grid are just that. Numbers and characters in the cells were you entered them. The is not time intelligence in those cells that could connect them the dates in row 5 that, in turn, are controlled by cell E4.
Better to use a regular calendar template, though there are many useless types of calendars available on-line. So, you have to pick one that suits your needs. But it's not going to be a Gantt chart.
SarahP1109 Which template might that be? Can you provide a link to where you found it?
- The template I used is: SIMPLE GANTT CHART by Vertex42.com
SarahP1109 OK! I found the template but have difficulty picturing how you use this for tracking staff and vacation etc. Can you include a screenshot showing how you use this template. Or even better, share a link to a file on OneDrive or similar. Just make sure replace any private and confidential information with fake information.
