Gantt chart Excel

gantt-chart-excel.py

from matplotlib.dates import date2num
gantt_df = xl("tasks[#All]", headers=True)

# Plot Gantt chart
fig, ax = plt.subplots(figsize=(10, 6))

# Define positions for the tasks on the y-axis
y_positions = range(len(gantt_df))

# Create bars for each task
for i, task in enumerate(gantt_df.itertuples()):
    ax.barh(y=i, width=(task.End - task.Start).days, left=date2num(task.Start), height=0.5, align='center', color='skyblue')

# Customize the plot
ax.set_yticks(y_positions)
ax.set_yticklabels(gantt_df['Task'])
ax.xaxis_date()  # Format x-axis as dates
ax.set_xlabel("Date")
ax.set_ylabel("Tasks")
ax.set_title("Gantt Chart")