Change the Project Start Date in an Excel Gantt Chart
Question details
The user wants to change the project start date shown in an Excel Gantt chart template.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The template shows 07/07/2018 as the project start date, but the controlling cells are unclear.
- Observed behavior
- The chart uses the earliest date in column F as the project start date.
Open the Gantt chart workbook and identify the worksheet containing the dates in column F. Check the intended task dates before changing the earliest entries.
Update the earliest dates in column F
Use this method to change the source date that controls the template's project start.
Open the Gantt chart worksheet in Excel and inspect the dates in column F. Look for the two cells near the bottom that contain 07/07/2018.
Select each date cell in column F that needs to change, including the two cells containing 07/07/2018, and enter the appropriate new dates.
Review column F for any remaining dates earlier than the intended start date, then check that the Gantt chart updates to use the earliest date in the column.

Update Gantt Chart Dates in WPS Spreadsheet
Open the Excel template in WPS Spreadsheet, change the source dates in column F, and check the chart before saving the workbook.
- 1. Open the workbook: In WPS Spreadsheet, select Open and choose the Excel Gantt chart workbook.
- 2. Locate the dates: Go to the worksheet with the chart data and inspect column F, including the two cells near the bottom containing 07/07/2018.
- 3. Edit the start dates: Select the relevant cells in column F and enter the new dates. Check that no unintended earlier date remains.
- 4. Review and save: Check that the chart reflects the updated dates, then select Save or Save As to save the workbook.

Frequently Asked Questions
Which cell controls the project start date in this template?
The template uses the earliest date in column F rather than a single fixed cell. Inspect the dates in that column, including the two entries near the bottom containing 07/07/2018.
Why does the chart still show an earlier start date?
Check column F for another date earlier than the intended start. Update that cell if the date is incorrect, then check the chart again.
Can I change the chart's displayed axis without changing the project dates?
In Excel, right-click the chart's date axis and select Format Axis. Under Axis Options, adjust the minimum bound if available. This changes the displayed range, not the dates in column F.
Can I edit the Excel Gantt chart template in WPS Spreadsheet?
Yes. Open the XLSX file in WPS Spreadsheet, edit the relevant dates in column F, and check the chart before saving. Verify the chart's appearance and behavior after opening it because template features can vary.




