Label only the latest point of a line
ChartsHardLLM judge scoringLatest run
Passed by 7 of 12 products on their best model. Failed: Copilot in Excel, Claude Code + Sheets MCP, Claude Code + Autosheet MCP, ChatGPT + Drive MCP and ChatGPT in Sheets.
Prompt
Create a line chart of revenue over time and display a label only on the most recent point.
Data
Starting sheet · rows 1–21 of 61| A | B | |
|---|---|---|
| 1 | Date | Revenue |
| 2 | 2025-01-01 | 11715 |
| 3 | 2025-01-02 | 11990 |
| 4 | 2025-01-03 | 12265 |
| 5 | 2025-01-04 | 12540 |
| 6 | 2025-01-05 | 12815 |
| 7 | 2025-01-06 | 13090 |
| 8 | 2025-01-07 | 13365 |
| 9 | 2025-01-08 | 12975 |
| 10 | 2025-01-09 | 13250 |
| 11 | 2025-01-10 | 13525 |
| 12 | 2025-01-11 | 13800 |
| 13 | 2025-01-12 | 14075 |
| 14 | 2025-01-13 | 14350 |
| 15 | 2025-01-14 | 14625 |
| 16 | 2025-01-15 | 14235 |
| 17 | 2025-01-16 | 14510 |
| 18 | 2025-01-17 | 14785 |
| 19 | 2025-01-18 | 15060 |
| 20 | 2025-01-19 | 15335 |
| 21 | 2025-01-20 | 15610 |
Chart
Starting sheet| A | |
|---|---|
| 1 |
Expected result
Pass criteria
All must be met, checked by an LLM judge.- A line chart of revenue over time
- Only the latest point has a label
- No other series shown
- Dates in order and a clear title
Passed 14
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
Autosheet in Excel GPT-6.1 Sol · Medium
ChatGPT + Autosheet MCP GPT-6 · Medium
Autosheet in Sheets Haiku 5.5 · High
ChatGPT in Excel GPT-6 Astra · Medium
Claude in Excel Haiku 5.5 · High
Autosheet in Excel GPT-6 Luna · High
Gemini in Sheets Auto
Failed 8
Claude Code + Sheets MCP Opus 5.5 · Medium
Why it failed: The most recent point has a marker dot but no visible data label showing the value.
Claude Code + Autosheet MCP Opus 5.5 · Medium
Why it failed: No data label is visible on the most recent point; only a marker dot is rendered without any text or value label.
Claude in Sheets Haiku 5.5 · High
Why it failed: There is no data label visible on the most recent point (only a point marker).
Copilot in Excel Auto
Why it failed: Data labels are visible for every point along the line rather than exclusively on the final point.
ChatGPT + Drive MCP GPT-6 · Medium
Why it failed: There is no data label displayed on the most recent data point on the chart.
ChatGPT in Excel GPT-6 Luna · High
Why it failed: No label is displayed on the last value; the plot area is completely blank.
ChatGPT in Sheets GPT-6 Astra · Medium
Why it failed: No line chart was created.
ChatGPT in Sheets GPT-6 Luna · High
Why it failed: No line chart was created.