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...

excel

Formulas and Functions

Riny_van_Eekelen
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.

Riny_van_Eekelen

Platinum Contributor

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

Copper Contributor

Nov 28, 2022

Riny_van_Eekelen

Thank you for that explanation, it sounds like maybe this isn't the right chart to use.

Forum Discussion

Gannt Chart