Chart & Visualization Issues

Change the Project Start Date in an Excel Gantt Chart

Amos GikundaAmos Gikunda Nov 14, 2026 868 views

Question details

The user wants to change the project start date shown in an Excel Gantt chart template.

Change the Project Start Date in an Excel Gantt Chart
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.
Before you start

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.

Solution 1Recommended

Update the earliest dates in column F

Use this method to change the source date that controls the template's project start.

1
Find the source dates

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.

2
Change the relevant dates

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.

3
Check the chart

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 the earliest dates in column F
The earliest date controls the start: If another date in column F is earlier than the date you want, the chart will use that earlier date as the project start.
Edit Gantt charts in WPS

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. 1. Open the workbook: In WPS Spreadsheet, select Open and choose the Excel Gantt chart workbook.
  2. 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. 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. 4. Review and save: Check that the chart reflects the updated dates, then select Save or Save As to save the workbook.
Edit the dates that control the Gantt chart's project startOpen and save Microsoft Excel XLSX filesWork with spreadsheet data and charts in one application
microsoft office alternative - wps office

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.