Make a pie chart of revenue by year
ChartsHardLLM judge scoringLatest run
Passed by 1 of 12 products on their best model: Copilot in Excel.
Prompt
Create a pie chart of revenue by year.
Starting spreadsheet
Data| A | B | |
|---|---|---|
| 1 | Year | Revenue |
| 2 | 2020 | 50000 |
| 3 | 2020 | 70000 |
| 4 | 2021 | 60000 |
| 5 | 2021 | 75000 |
| 6 | 2022 | 65000 |
| 7 | 2022 | 77000 |
| 8 | 2023 | 72000 |
| 9 | 2023 | 86000 |
| 10 | 2024 | 81000 |
| 11 | 2024 | 90000 |
| 12 | 2025 | 92000 |
| 13 | 2025 | 97000 |
Expected result
Pass criteria
All must be met, checked by an LLM judge.- A pie chart with one slice per year, sized by revenue
- Each year is identified
- Each year's revenue amount is shown
- A clear title and readable labels
Passed 2
Autosheet in Excel Haiku 5.5 · High
Copilot in Excel Auto
Failed 20
Autosheet in Excel Opus 5.5 · Medium
Why it failed: The chart displays only percentage labels (13%, 15%, 17%, etc.) and does not display the actual aggregated revenue amounts on the chart.
Autosheet in Excel GPT-6 Astra · Low
Why it failed: Only percentages are shown on the slices; actual revenue dollar values are missing.
Autosheet in Sheets Opus 5.5 · Medium
Why it failed: Labels show percentages rather than aggregated revenue amounts.
Autosheet in Excel Sonnet 5.5 · Medium
Why it failed: No distinct pie slices are rendered because all aggregated revenue values evaluated to $0.
Claude in Excel Opus 5.5 · High
Why it failed: The slices show only their percentages, not each year's revenue, which a pie of revenue by year should show.
Claude in Sheets Opus 5.5 · Medium
Why it failed: Only percentage values are visible on the slices; actual revenue figures are missing.
Claude Code + Sheets MCP Opus 5.5 · Medium
Why it failed: Aggregated revenue amounts are not shown on or alongside the slices.
Autosheet in Excel GPT-6.1 Sol · Medium
Why it failed: The chart shows percentages (e.g., '13%', '15%') rather than actual revenue amounts (e.g., '$120,000', '120000').
Claude Code + Autosheet MCP Opus 5.5 · Medium
Why it failed: Labels display only percentage shares rather than the actual aggregated revenue values.
ChatGPT + Autosheet MCP GPT-6 · Medium
Why it failed: Data labels show percentages only; actual aggregated revenue amounts are omitted.
Autosheet in Sheets Haiku 5.5 · High
Why it failed: No revenue amounts or data labels are visible on the chart.
ChatGPT in Excel GPT-6 Astra · Medium
Why it failed: The slices show only their percentages, not each year's revenue, which a pie of revenue by year should show.
Claude in Excel Haiku 5.5 · High
Why it failed: Labels display only percentage shares rather than actual revenue amounts.
Claude in Sheets Haiku 5.5 · High
Why it failed: The chart displays only percentages on the slices; the actual aggregated revenue amounts are not visible on the chart.
Autosheet in Excel GPT-6 Luna · High
Why it failed: Slices are identical in size (~16-17% each) rather than reflecting revenue values.
ChatGPT + Drive MCP GPT-6 · Medium
Why it failed: Actual aggregated revenue values are not shown on the chart.
ChatGPT in Excel GPT-6 Luna · High
Why it failed: Slices are identical in size rather than proportional to aggregated revenue.
Gemini in Sheets Auto
Why it failed: Revenue amounts are not displayed on the chart slices or in the legend.
ChatGPT in Sheets GPT-6 Astra · Medium
Why it failed: No pie chart was created in the workbook.
ChatGPT in Sheets GPT-6 Luna · High
Why it failed: No pie chart was created in the workbook.