Reverse the order of a chart's bars
ChartsMediumLLM judge scoringLatest run
Passed by 9 of 12 products on their best model. Failed: ChatGPT + Drive MCP, Gemini in Sheets and ChatGPT in Sheets.
Prompt
Reverse the order of the bars.
Starting spreadsheet
Sheet1| A | B | C | D | E | F | G | H | I | J | K | L | M | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Year | Revenue | Profit | ||||||||||
| 2 | 2021 | 1250000 | 180000 | ||||||||||
| 3 | 2022 | 1430000 | 215000 | ||||||||||
| 4 | 2023 | 1590000 | 248000 | ||||||||||
| 5 | 2024 | 1710000 | 286000 | ||||||||||
| 6 | 2025 | 1880000 | 324000 | ||||||||||
| 7 | |||||||||||||
| 8 | |||||||||||||
| 9 | |||||||||||||
| 10 | |||||||||||||
| 11 | |||||||||||||
| 12 | |||||||||||||
| 13 | |||||||||||||
| 14 | |||||||||||||
| 15 | |||||||||||||
| 16 | |||||||||||||
| 17 |
Expected result
Pass criteria
All must be met, checked by an LLM judge.- The chart is edited in place, colors kept
- The bars now run from 2025 to 2021
Passed 16
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
Copilot in Excel Auto
Failed 6
Autosheet in Sheets Haiku 5.5 · High
Why it failed: The category axis was not reversed; the years still run 2021 to 2025 instead of 2025 to 2021.
ChatGPT + Drive MCP GPT-6 · Medium
Why it failed: Category axis order was not reversed to 2025-2021.
ChatGPT in Excel GPT-6 Luna · High
Why it failed: The chart axis was not modified in place; source data was reordered instead.
Gemini in Sheets Auto
Why it failed: The source data in B1:D6 was modified instead of updating the chart settings while leaving underlying data untouched.
ChatGPT in Sheets GPT-6 Astra · Medium
Why it failed: The chart object was not properly updated in place to reverse category order; instead, the agent modified the underlying worksheet data across 12 cells in B2:D6.
ChatGPT in Sheets GPT-6 Luna · High
Why it failed: The underlying table data was modified instead of updating the chart object.