Forum Discussion
Gannt Chart
- Nov 28, 2022
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 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.
Thank you for your help. Here is a screen shot of the table we are using. The staff names are on the left, and I Have input numbers for the days they are n and letters when out so I can tally the numbers for each day. When the chart dates advance with each new week, the numbers/letters associated with those days do not advance. So the data for the week of 11/28 ends up in the week of 12/5. Does that make sense? I was wondering if there was a way for the week and the data to advance together.
- Riny_van_EekelenNov 28, 2022Platinum Contributor
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.
- SarahP1109Nov 28, 2022Copper Contributor
Thank you for that explanation, it sounds like maybe this isn't the right chart to use.