Excel kılavuzu

How to Make a Gantt Chart in Excel

A Gantt chart is an essential tool for project management. By using a stacked bar chart with a transparent first series, you can easily track task durations and progress.

Bunun yerine yapay zekâ ile yap

Adım adım

1
Prepare your data
Create a table with columns for Task Name, Start Date, and Duration (End Date - Start Date).
2
Insert a stacked bar chart
Select your data, go to the 'Insert' tab, click 'Insert Column or Bar Chart', and choose 'Stacked Bar'.
3
Format the first series
Right-click the first data series (Start Dates), select 'Format Data Series', and set 'Fill' to 'No fill' and 'Line' to 'No line'.

=C2-B2

İpuçları

Ensure your dates are formatted as numbers for the chart to recognize them correctly.
You can reverse the order of tasks by checking 'Categories in reverse order' in the Axis Options.

SSS

Why does my Gantt chart look empty?

This usually happens if the Start Date series is hidden but the axis scale is set too high. Adjust the axis minimum to match your earliest start date.