Create a Gantt chart
ChartsHardLLM judge scoringLatest run
Passed by 3 of 12 products on their best model: Autosheet in Excel, Claude in Excel and Claude in Sheets.
Prompt
Create a Gantt chart.
Data
Starting sheet| A | B | C | |
|---|---|---|---|
| 1 | Task | Start Date | Duration (days) |
| 2 | Plan | 2025-04-01 | 3 |
| 3 | Design | 2025-04-03 | 5 |
| 4 | Build | 2025-04-08 | 8 |
| 5 | QA | 2025-04-14 | 4 |
| 6 | Launch | 2025-04-19 | 2 |
| 7 | Training | 2025-04-20 | 3 |
| 8 | Review | 2025-04-24 | 2 |
| 9 | Wrap-up | 2025-04-26 | 1 |
Chart
Starting sheet| A | |
|---|---|
| 1 |
Expected result
Pass criteria
All must be met, checked by an LLM judge.- A horizontal bar chart
- Only the task blocks are colored
- Readable dates in order
- A clear title; any legend at the top
Passed 9
Autosheet in Excel Opus 5.5 · Medium
Autosheet in Excel GPT-6 Astra · Low
Autosheet in Excel Sonnet 5.5 · Medium
Claude in Excel Opus 5.5 · High
Autosheet in Excel Haiku 5.5 · High
Claude in Sheets Opus 5.5 · Medium
Autosheet in Excel GPT-6.1 Sol · Medium
Claude in Excel Haiku 5.5 · High
Autosheet in Excel GPT-6 Luna · High
Failed 13
Autosheet in Sheets Opus 5.5 · Medium
Why it failed: The horizontal axis shows day numbers ('0', '10', '20', '30') labeled 'Days from project start' instead of readable calendar dates.
Claude Code + Sheets MCP Opus 5.5 · Medium
Why it failed: The horizontal axis shows numeric increments (0, 10, 20, 30) rather than dates.
Claude Code + Autosheet MCP Opus 5.5 · Medium
Why it failed: The horizontal axis shows numeric day offsets rather than readable dates.
ChatGPT + Autosheet MCP GPT-6 · Medium
Why it failed: No chart object was created (chartCount is 0).
Autosheet in Sheets Haiku 5.5 · High
Why it failed: The horizontal axis shows numeric day offsets (0, 10, 20, 30) rather than readable calendar dates.
ChatGPT in Excel GPT-6 Astra · Medium
Why it failed: The horizontal axis counts days from the start, 0 to 28, instead of showing dates.
Claude in Sheets Haiku 5.5 · High
Why it failed: The horizontal axis displays numeric day offsets (0, 10, 20, 30) rather than readable dates.
Copilot in Excel Auto
Why it failed: Floating Gantt blocks were not formed; standard solid bars originate from the vertical axis.
ChatGPT + Drive MCP GPT-6 · Medium
Why it failed: The horizontal axis displays numeric offsets (0, 10, 20, 30) rather than readable dates.
ChatGPT in Excel GPT-6 Luna · High
Why it failed: Start offset bars remain colored and visible.
Gemini in Sheets Auto
Why it failed: The horizontal axis plots numeric day offsets (=B2-$B$2) rather than readable calendar dates.
ChatGPT in Sheets GPT-6 Astra · Medium
Why it failed: No chart was created.
ChatGPT in Sheets GPT-6 Luna · High
Why it failed: No chart was created.