Align zero on a dual-axis combo chart
ChartsHardLLM judge scoringLatest run
Passed by 8 of 12 products on their best model. Failed: Copilot in Excel, Claude Code + Autosheet MCP, ChatGPT + Drive MCP and ChatGPT in Sheets.
Prompt
Create a combo chart with revenue as bars and profit as a line on two axes. Ensure zero aligns properly on both axes.
Data
Starting sheet| A | B | C | |
|---|---|---|---|
| 1 | Date | Profit | Revenue |
| 2 | 2025-03-01 | -4580 | 18000 |
| 3 | 2025-03-02 | -3680 | 19660 |
| 4 | 2025-03-03 | -2780 | 21320 |
| 5 | 2025-03-04 | -3020 | 22980 |
| 6 | 2025-03-05 | -2120 | 24640 |
| 7 | 2025-03-06 | -1220 | 25000 |
| 8 | 2025-03-07 | -1460 | 26660 |
| 9 | 2025-03-08 | -560 | 28320 |
| 10 | 2025-03-09 | 340 | 29980 |
| 11 | 2025-03-10 | 100 | 31640 |
| 12 | 2025-03-11 | 1000 | 32000 |
| 13 | 2025-03-12 | 1900 | 33660 |
| 14 | 2025-03-13 | 1660 | 35320 |
| 15 | 2025-03-14 | 2560 | 36980 |
| 16 | 2025-03-15 | 3460 | 38640 |
| 17 | 2025-03-16 | 3220 | 39000 |
| 18 | 2025-03-17 | 4120 | 40660 |
| 19 | 2025-03-18 | 5020 | 42320 |
| 20 | 2025-03-19 | 4780 | 43980 |
| 21 | 2025-03-20 | 5680 | 45640 |
Chart
Starting sheet| A | |
|---|---|
| 1 |
Expected result
Pass criteria
All must be met, checked by an LLM judge.- A combo chart: revenue as bars, profit as a line
- Two y-axes with their zeros aligned
- The axes include the negative values
- Dates in order, a title and a legend
Passed 12
Autosheet in Excel Opus 5.5 · Medium
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
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
Gemini in Sheets Auto
Failed 10
Autosheet in Excel GPT-6 Astra · Low
Why it failed: Zero levels are not aligned; zero is at the bottom on the left axis and in the middle on the right axis.
Autosheet in Excel GPT-6.1 Sol · Medium
Why it failed: Zero on the primary axis is at the bottom, whereas zero on the secondary axis is near the midpoint.
Claude Code + Autosheet MCP Opus 5.5 · Medium
Why it failed: Zero levels are misaligned between the left (-25k to 50k) and right (-5k to 7.5k) axes.
Autosheet in Sheets Haiku 5.5 · High
Why it failed: Only the left y-axis is rendered; no secondary y-axis is visible on the right.
Autosheet in Excel GPT-6 Luna · High
Why it failed: The zero levels are not aligned across the primary and secondary axes.
Copilot in Excel Auto
Why it failed: Zero levels do not align horizontally across both y-axes.
ChatGPT + Drive MCP GPT-6 · Medium
Why it failed: Zero levels are not aligned: on the primary axis zero is positioned at 28.6% of the vertical axis span (-20k to 50k), whereas on the secondary axis zero is at 40% of the vertical axis span…
ChatGPT in Excel GPT-6 Luna · High
Why it failed: Date labels are placed along the zero axis line instead of below the chart, colliding with the profit line.
ChatGPT in Sheets GPT-6 Astra · Medium
Why it failed: No chart was created in the workbook.
ChatGPT in Sheets GPT-6 Luna · High
Why it failed: No combo chart was created.