Chart traffic sources, then make it a pie
ChartsMediumLLM judge scoringLatest run
Passed by 9 of 12 products on their best model. Failed: ChatGPT in Excel, Copilot in Excel and ChatGPT in Sheets.
Prompt
Create a bar chart showing where our traffic is coming from
Can you make it a pie chart instead? The bar chart is hard to read with this many sources
Starting spreadsheet
Sheet1| A | B | C | D | |
|---|---|---|---|---|
| 1 | Source | Sessions | Bounce Rate | Avg Duration |
| 2 | Google Organic | 18420 | 42% | 3:24 |
| 3 | Direct | 11850 | 38% | 4:01 |
| 4 | 7340 | 61% | 1:52 | |
| 5 | 5210 | 29% | 5:17 | |
| 6 | Bing | 3880 | 47% | 2:45 |
| 7 | 2640 | 33% | 4:38 | |
| 8 | Twitter/X | 1920 | 68% | 1:14 |
| 9 | 1380 | 72% | 0:58 | |
| 10 | 890 | 55% | 2:09 | |
| 11 | 450 | 64% | 1:31 |
Expected result
Pass criteria
All must be met, checked by an LLM judge.- First a bar chart of sessions by source
- Then the same chart as a pie
- The pie keeps the same data
- A readable pie: filled slices in distinct colors, each source named, and any percentages right
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
Autosheet in Sheets Haiku 5.5 · High
Claude in Excel Haiku 5.5 · High
Claude in Sheets Haiku 5.5 · High
ChatGPT + Drive MCP GPT-6 · Medium
ChatGPT in Excel GPT-6 Luna · High
Gemini in Sheets Auto
Failed 5
ChatGPT in Excel GPT-6 Astra · Medium
Why it failed: Every slice has no fill and no outline, so the pie is invisible and the legend shows no colors. The labels' number format, 0\.0%, also reads Google Organic's 34% share as 3.4%.
Autosheet in Excel GPT-6 Luna · High
Why it failed: The pie has no legend and no labels: nothing says which slice is which source.
Copilot in Excel Auto
Why it failed: Every slice is the same blue, so the legend can't tell the sources apart.
ChatGPT in Sheets GPT-6 Astra · Medium
Why it failed: No pie chart was created after turn 2.
ChatGPT in Sheets GPT-6 Luna · High
Why it failed: No chart was created.