Forum Discussion
Automatically update x-axis values at year end
I have a Gantt chart. The x-axis minimum and maximum bounds are currently 45292 and 45657, signifying 01/01/2024 and 12/31/2024 respectively. These minimum and maximum numbers are driven by a 'Date' ...
What exactly did you ask ChatGPT? instead of tweaking the x-axis of a chart, you should tweak the underlying data for x-axis instead. e.g. you can ask ChatGPT: "how to write a script to update the dates in row 4 of an excel sheet to the current date if they reach year end?"