Forum Discussion

SarahP1109's avatar
SarahP1109
Copper Contributor
Nov 28, 2022

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...
  • Riny_van_Eekelen's avatar
    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.

Resources