Check out a proposed new feature for Gantt Chart Template Pro that will let you show both the original task dates and the current dates in the same chart.

In this tutorial, you’ll learn how to create a Gantt chart in Excel to track your project’s plan versus actual timeline. With clear steps and practical tips, you’ll master this tool in no time. Let’s dive in and simplify your project management! Download the practice workbook 👉 HERE and follow along.

Make sure dates are formatted as dates. Create a Stacked Bar chart, with two series, Original Start as one, and OriginalEnd - OriginalStart as the second. Unformatted as dates would give you data like the following

Due dates & task duration: Add planned start and planned finish dates and adjust them at any time by dragging and dropping tasks on the Gantt timeline. You can also compare planned vs. actual task duration.

We set up an actual vs expected Gantt chart in Excel. This will be useful for project planning purposes as it’ll show whether your project tasks are currently on track or not. A Gantt chart...