Ouch. If there were some lovely formulas that could move things around automatically, I could see that working…but I bet people were literally dragging around cells one at a time.
Look, when I paste, it gives me the option to Move Cells to the Right!
I admire your faith in the goodness of people. No, it went in the other direction: editing VBASIC in the developer options and all the horrors that brings. Obviously, that’s too easy to break. So it was locked down. So, of course, people started making copies so they could make it do the things they wanted that it wasn’t supposed to do. It seemed like by the end, each person probably had their own, slightly different copy with degrees of functionality depending on their Excel skills. Not a great environment for making a baseline and a critical path. Do not recommend.
Ahem In my defense, the way I did it wasn’t totally terrible. The dates are all gathered from other sheets, the chart is generated automatically with conditional formatting, and it’s locked so there’s no moving of cells or changing the colour manually. Don’t hate me.
Gantt Chart
Oh lord, it’s hilarious that when I searched ‘Gantt Chart’ to learn what it was, the second or third link was to excel templates for it.
Ouch. If there were some lovely formulas that could move things around automatically, I could see that working…but I bet people were literally dragging around cells one at a time.
I admire your faith in the goodness of people. No, it went in the other direction: editing VBASIC in the developer options and all the horrors that brings. Obviously, that’s too easy to break. So it was locked down. So, of course, people started making copies so they could make it do the things they wanted that it wasn’t supposed to do. It seemed like by the end, each person probably had their own, slightly different copy with degrees of functionality depending on their Excel skills. Not a great environment for making a baseline and a critical path. Do not recommend.
Ahem In my defense, the way I did it wasn’t totally terrible. The dates are all gathered from other sheets, the chart is generated automatically with conditional formatting, and it’s locked so there’s no moving of cells or changing the colour manually. Don’t hate me.
Judgment is God’s purview. I just arrange the meeting.
Honestly, if it worked well for you and all the other affected stakeholders, I think that’s what matters most.