# Turn a list of milestones into a project timeline or Gantt chart

Converts milestones and dates into a phased timeline, a Gantt-style table for Excel, and a one-slide version for PowerPoint.

- Topic: Projects & Operations
- Framework: Few-Shot
- Level: Standard
- Tags: Analyze, Plan, Fill-in Template
- Source: https://www.thinkwithprompt.com/prompts/turn-a-list-of-milestones-into-a-project-timeline-or-gantt-chart

## Prompt

```text
Turn my milestones into a project timeline.

**Milestones and dates:** [PASTE THE LIST - e.g. "Design sign-off: May 10", "Pilot live: June 30"]
**Project start and end:** [DATES]
**Known dependencies:** [e.g. "pilot can't start until security review is done"]
**Audience for the timeline:** [team / sponsor / executives / client]
**Where it will live:** [Excel / PowerPoint slide / project tool / email]

Steps:
1. Order the milestones and group them into 3-6 phases.
2. Add the main activities that must happen between milestones, so the gaps make sense. Mark anything you added with [ADDED - confirm].
3. Check the sequence: flag milestones that come before something they depend on, phases with no buffer, and dates on weekends or holidays I listed.
4. Highlight decision points and approvals, since they cause most slips.

Return:
1. A timeline table: Phase | Activity or milestone | Start | End | Duration (weeks) | Depends on | Owner (if known).
2. A Gantt chart layout for Excel: one row per activity, one column per week, with instructions to shade cells using conditional formatting.
3. A one-slide version: 5-8 milestones on a horizontal line, with a title that states the key date ("Pilot live by June 30, launch in September").
4. Risks to the timeline: the 3 places it is most likely to slip and why.

Do not change any date I gave. If a date looks impossible, say so and suggest an alternative instead.
```

## What to fill in

- DATES
- e.g. "pilot can't start until security review is done"
- team / sponsor / executives / client
- Excel / PowerPoint slide / project tool / email
- ADDED - confirm

Free to copy and use. From ThinkWithPrompt (https://www.thinkwithprompt.com/), a library of 2,663 curated AI prompts.