Chart sorted values, source unchanged
ChartsMediumLLM judge scoringLatest run
Passed by 9 of 12 products on their best model. Failed: Copilot in Excel, Gemini in Sheets and ChatGPT in Sheets.
Prompt
Create a chart sorted from highest to lowest without modifying the source table.
Data
Starting sheet| A | B | |
|---|---|---|
| 1 | Product | Revenue |
| 2 | Alpha | 8100 |
| 3 | Beta | 12700 |
| 4 | Gamma | 9400 |
| 5 | Delta | 15300 |
| 6 | Epsilon | 11500 |
| 7 | Zeta | 6900 |
| 8 | Eta | 14100 |
| 9 | Theta | 10200 |
| 10 | Iota | 13300 |
| 11 | Kappa | 7600 |
Report
Starting sheet| A | |
|---|---|
| 1 |
Expected result
Pass criteria
All must be met, checked by an LLM judge.- The Data sheet is unchanged
- A helper table sorted by revenue, highest first
- A bar chart from that table, highest first
Passed 17
Autosheet in Excel Opus 5.5 · Medium
Autosheet in Excel GPT-6 Astra · Low
Autosheet in Sheets Opus 5.5 · Medium
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
Claude Code + Sheets MCP Opus 5.5 · Medium
Autosheet in Excel GPT-6.1 Sol · Medium
Claude Code + Autosheet MCP Opus 5.5 · Medium
ChatGPT + Autosheet MCP GPT-6 · Medium
ChatGPT in Excel GPT-6 Astra · Medium
Claude in Excel Haiku 5.5 · High
Claude in Sheets Haiku 5.5 · High
Autosheet in Excel GPT-6 Luna · High
ChatGPT + Drive MCP GPT-6 · Medium
ChatGPT in Excel GPT-6 Luna · High
Failed 5
Autosheet in Sheets Haiku 5.5 · High
Why it failed: The Data sheet was modified: 22 cells were added across Data!D1:E11 and the chart was placed on the Data sheet.
Copilot in Excel Auto
Why it failed: The highest bar (Delta) appears at the bottom and the lowest bar (Zeta) appears at the top instead of having the highest bar at the top.
Gemini in Sheets Auto
Why it failed: The helper table was arranged with products in alphabetical order across rows rather than sorted from highest revenue to lowest revenue.
ChatGPT in Sheets GPT-6 Astra · Medium
Why it failed: No native column or bar chart was created.
ChatGPT in Sheets GPT-6 Luna · High
Why it failed: No chart was created.