Question: how to change date range in excel gantt chart?
Answer: Click on any date above the task bars in your Gantt chart. One click will select all the dates, you right click them and choose Format Axis from the context menu. Under Axis Options, change Minimum to Fixed and type the number you recorded in the previous step.