Combine revenue bars with a rate line
ChartsMediumLLM judge scoringLatest run
Passed by 8 of 12 products on their best model. Failed: Claude in Excel, ChatGPT in Excel, Gemini in Sheets and ChatGPT in Sheets.
Prompt
Create a chart with Revenue as bars and conversion rate as a line
Data
Starting sheet · rows 1–21 of 25| A | B | C | |
|---|---|---|---|
| 1 | Date | Revenue | Conversion Rate |
| 2 | 2025-02-01 | 28000 | 0.018 |
| 3 | 2025-02-02 | 29450 | 0.0214 |
| 4 | 2025-02-03 | 30900 | 0.0248 |
| 5 | 2025-02-04 | 32350 | 0.0282 |
| 6 | 2025-02-05 | 32400 | 0.0316 |
| 7 | 2025-02-06 | 33850 | 0.02 |
| 8 | 2025-02-07 | 35300 | 0.0234 |
| 9 | 2025-02-08 | 36750 | 0.0268 |
| 10 | 2025-02-09 | 36800 | 0.0302 |
| 11 | 2025-02-10 | 38250 | 0.0336 |
| 12 | 2025-02-11 | 39700 | 0.022 |
| 13 | 2025-02-12 | 41150 | 0.0254 |
| 14 | 2025-02-13 | 41200 | 0.0288 |
| 15 | 2025-02-14 | 42650 | 0.0322 |
| 16 | 2025-02-15 | 44100 | 0.0356 |
| 17 | 2025-02-16 | 45550 | 0.024 |
| 18 | 2025-02-17 | 45600 | 0.0274 |
| 19 | 2025-02-18 | 47050 | 0.0308 |
| 20 | 2025-02-19 | 48500 | 0.0342 |
| 21 | 2025-02-20 | 49950 | 0.0376 |
Chart
Starting sheet| A | |
|---|---|
| 1 |
Expected result
Pass criteria
All must be met, checked by an LLM judge.- A combo chart: revenue as bars, conversion rate as a line
- Two y-axes
- The rate axis reads about 3%, not 0.3%
- Dates in order, a title and a legend
Passed 15
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
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
Autosheet in Sheets Haiku 5.5 · High
Autosheet in Excel GPT-6 Luna · High
Copilot in Excel Auto
ChatGPT + Drive MCP GPT-6 · Medium
ChatGPT in Excel GPT-6 Luna · High
Failed 7
Claude in Excel Opus 5.5 · High
Why it failed: The conversion-rate axis has a broken number format, 0\.0%: rates of 1.8% to 3.8% read as 0.2% to 0.4%.
ChatGPT in Excel GPT-6 Astra · Medium
Why it failed: The conversion-rate axis has a broken number format, 0\.0%: rates of 1.8% to 3.8% read as 0.2% to 0.4%.
Claude in Excel Haiku 5.5 · High
Why it failed: Secondary axis shows values around 0.03% instead of 3%.
Claude in Sheets Haiku 5.5 · High
Why it failed: Title is present, but the legend swatches lack series text labels.
Gemini in Sheets Auto
Why it failed: Conversion rate axis uses decimal values instead of percentage formatting.
ChatGPT in Sheets GPT-6 Astra · Medium
Why it failed: No combo chart was created.
ChatGPT in Sheets GPT-6 Luna · High
Why it failed: No combo chart was created.