All AutosheetBench tasks

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 and starting spreadsheet

Task files

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
ABC
1DateProfitRevenue
22025-03-01-458018000
32025-03-02-368019660
42025-03-03-278021320
52025-03-04-302022980
62025-03-05-212024640
72025-03-06-122025000
82025-03-07-146026660
92025-03-08-56028320
102025-03-0934029980
112025-03-1010031640
122025-03-11100032000
132025-03-12190033660
142025-03-13166035320
152025-03-14256036980
162025-03-15346038640
172025-03-16322039000
182025-03-17412040660
192025-03-18502042320
202025-03-19478043980
212025-03-20568045640

Chart

Starting sheet
A
1

Expected result

How each AI configuration did

12 of 22 passRun files
Excel and Sheets · All types · All models · All outputs

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

Passed27s · 8¢

Autosheet in Sheets Opus 5.5 · Medium

Passed59s · 23¢

Autosheet in Excel Sonnet 5.5 · Medium

Passed12s · 3¢

Claude in Excel Opus 5.5 · High

Passed34s · 19¢

Autosheet in Excel Haiku 5.5 · High

Passed25s · 0.5¢

Claude in Sheets Opus 5.5 · Medium

Passed38s · 12¢

Claude Code + Sheets MCP Opus 5.5 · Medium

Passed1m 19s · N/A

ChatGPT + Autosheet MCP GPT-6 · Medium

Passed1m 35s · N/A

ChatGPT in Excel GPT-6 Astra · Medium

Passed1m 38s · 95¢

Claude in Excel Haiku 5.5 · High

Passed25s · 0.7¢

Claude in Sheets Haiku 5.5 · High

Passed53s · 2¢

Gemini in Sheets Auto

Passed1m 22s · N/A

Failed 10

Autosheet in Excel GPT-6 Astra · Low

Failed41s · 33¢

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

Failed34s · 10¢

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

Failed50s · N/A

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

Failed1m 54s · 1¢

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

Failed1m 44s · 1¢

Why it failed: The zero levels are not aligned across the primary and secondary axes.

Copilot in Excel Auto

Failed52s · N/A

Why it failed: Zero levels do not align horizontally across both y-axes.

ChatGPT + Drive MCP GPT-6 · Medium

Failed42s · N/A

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

Failed1m 35s · 3¢

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

Failed47s · 55¢

Why it failed: No chart was created in the workbook.

ChatGPT in Sheets GPT-6 Luna · High

Failed52s · 0.6¢

Why it failed: No combo chart was created.