R04.03.01.03 · 任务小类

表格图表

Spreadsheet charts

Create and format charts to an exact specification.

20 条本项目编写的提案 · 分类 v1.1 · 新增基准运行 0 次。下方验证方式与部分得分规则是设计，不是执行结果。

典型应用: Excel · Numbers · Google Sheets
小类 GUI 需求标签: G2 · GUI 必要

任务提案 · 20

展开查看完整原文与建议检查方式；两种界面均保留提案英文原文。

R04.03.01.03-T01 Chart monthly revenue 2024 vs 2025 as a branded clustered column

原始指令

In fixtures/monthly_rev.xlsx sheet 'Data' (A1:C13), insert a clustered column chart on sheet 'Chart': 2024 series #1F4E79, 2025 series #F28C28, title 'Monthly Revenue 2024 vs 2025', axis titles 'Month' and 'Revenue ($k)', legend at bottom, gap width 80%. Save.

平台: mac · macOS win · Windows
应用: Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: G2 · GUI 必要
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: click · 指向与点击 type · 文字与表单
工作产物: WP03 · 视觉排版
条件: 未声明
提案难度: 2 / 5

建议验证方式

Parse chart XML: barChart barDir=col grouping=clustered, 2 series referencing Data!B2:B13/C2:C13, srgbClr fills exact, title/axis titles exact, legendPos b, gapWidth 80. Chart must carry Excel-authored c16 extension ids (absent in openpyxl output). VBA, COM and AppleScript automation disabled, no Python in the VM.

建议部分得分

30% correct type and series refs; 25% colors; 30% titles and legend; 15% gap width.

R04.03.01.03-T02 Plot three cities' weekly temperatures as a Numbers line chart

原始指令

Open fixtures/climate.numbers in Numbers. From table 'Weekly' create a 2D line chart of Oslo, Lisbon and Cairo (52 weeks), y-axis from −10 to 40 °C with major steps of 10, x-axis labels every 4th week, legend at top, chart title 'Weekly mean temperature 2025'. Save.

平台: mac · macOS
应用: Numbers
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: G3 · 仅 GUI
GUI 需求 · 普通权限: G2 · GUI 必要
交互原语: click · 指向与点击 type · 文字与表单
工作产物: WP03 · 视觉排版
条件: 未声明
提案难度: 2 / 5

建议验证方式

Grader exports the sheet to PDF and .xlsx via its own AppleScript: 3 line series with correct data ranges, axis min/max/steps, title; rendered chart compared to reference PNG (SSIM ≥0.90). osascript/JXA is blocked for the agent; the file must be saved by Numbers (IWA metadata).

建议部分得分

30% chart with 3 correct series; 30% axis scale; 20% label interval and legend; 20% title + render match.

R04.03.01.03-T03 Build a revenue-and-margin combo chart with a secondary axis

原始指令

fixtures/quarterly_pl.xlsx 'Summary' A1:C9 holds Quarter, Revenue, Margin %. Create a combo chart: Revenue as clustered columns on the primary axis, Margin % as a line with markers on a secondary axis fixed 0%–40%, data labels on the line only (0.0%), no gridlines on the secondary axis. Save.

平台: mac · macOS win · Windows
应用: Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: G2 · GUI 必要
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: click · 指向与点击 type · 文字与表单
工作产物: WP03 · 视觉排版
条件: 未声明
提案难度: 3 / 5

建议验证方式

Chart XML: one barChart + one lineChart, line on secondary valAx with min 0 max 0.4, dLbls only on the line series with numFmt 0.0%, no majorGridlines on secondary axis; series refs exact; c16 ids present (Excel-authored). VBA, COM and AppleScript automation disabled, no Python in the VM.

建议部分得分

30% combo structure; 30% secondary axis with bounds; 25% labels on line only; 15% gridline setting.

R04.03.01.03-T04 Create an EBITDA bridge waterfall with total bars set correctly

原始指令

fixtures/ebitda_bridge.xlsx 'Bridge' lists FY24 EBITDA, 6 drivers (positive and negative) and FY25 EBITDA. Insert an Excel waterfall chart where FY24 and FY25 are set as totals, increases are #2E7D32, decreases #C62828, totals #546E7A, connector lines on, data labels in $m with one decimal. Save.

平台: mac · macOS win · Windows
应用: Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: G2 · GUI 必要
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: click · 指向与点击 hover · 悬停与上下文
工作产物: WP03 · 视觉排版
条件: 未声明
提案难度: 3 / 5

建议验证方式

chartex part (cx:chart) layoutId='waterfall' with subtotals idx for the first and last points, data point colors per sign, connector lines enabled, label numFmt. openpyxl cannot write chartex; VBA, COM and AppleScript automation disabled, no Python in the VM.

建议部分得分

30% waterfall chart from right range; 30% totals set; 25% colors by sign; 15% labels/connectors.

R04.03.01.03-T05 Fit a trendline on a log-scale scatter and show equation and R²

原始指令

fixtures/assay_curve.xlsx has Concentration (ng/mL) and Signal. Create an XY scatter (markers only) with a logarithmic x-axis base 10 from 0.1 to 1000, y-axis 0 to 2.5, a logarithmic trendline with equation and R² displayed, and axis titles with units. Save.

平台: mac · macOS win · Windows
应用: Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: G2 · GUI 必要
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: click · 指向与点击 type · 文字与表单
工作产物: WP03 · 视觉排版
条件: 未声明
提案难度: 3 / 5

建议验证方式

Chart XML: scatterChart style marker, x valAx logBase 10 min 0.1 max 1000, y min 0 max 2.5, trendline trendlineType='log' dispEq=1 dispRSqr=1; axis titles contain units; Excel-authored c16 ids required. VBA, COM and AppleScript automation disabled, no Python in the VM.

建议部分得分

25% scatter with correct ranges; 30% log axis and bounds; 30% trendline type + eq + R²; 15% axis titles.

R04.03.01.03-T06 Label a bubble chart's points with customer names from cells

原始指令

In fixtures/account_matrix.xlsx create a bubble chart from 'Accounts' (x = Revenue, y = Growth %, size = Seats) and label every bubble with the customer name from column A using data labels 'Value From Cells' (no X/Y values in labels). Scale bubble size to 60%. Save.

平台: mac · macOS win · Windows
应用: Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: G2 · GUI 必要
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: click · 指向与点击 hover · 悬停与上下文
工作产物: WP03 · 视觉排版
条件: 未声明
提案难度: 3 / 5

建议验证方式

bubbleChart with xVal/yVal/bubbleSize refs exact; bubbleScale 60; dLbls use c15:datalabelsRange referencing Accounts!A2:A26 with showDataLabelsRange=1 and showVal/showCatName off. openpyxl cannot author datalabelsRange. VBA, COM and AppleScript automation disabled, no Python in the VM.

建议部分得分

35% bubble chart refs; 40% value-from-cells labels; 15% other label parts off; 10% bubble scale.

R04.03.01.03-T07 Turn a task list into a Gantt chart with stacked bars

原始指令

fixtures/rollout_plan.xlsx 'Tasks' has Task, Start, Duration (days) for 18 tasks. Build a Gantt chart: stacked bar with Start as an invisible series, Duration filled #4472C4, tasks top-to-bottom in list order, date axis from 2026-01-05 to 2026-06-29 with major unit 14 days. Save.

平台: mac · macOS win · Windows
应用: Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: G2 · GUI 必要
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: click · 指向与点击 type · 文字与表单
工作产物: WP03 · 视觉排版
条件: 未声明
提案难度: 3 / 5

建议验证方式

barChart barDir=bar grouping=stacked; series 1 noFill; series 2 fill #4472C4; category axis orientation maxMin; value axis min/max equal the date serials and majorUnit 14; rendered PNG compared to reference (SSIM ≥0.9). VBA, COM and AppleScript automation disabled, no Python in the VM; file must be saved by Excel (app.xml).

建议部分得分

30% stacked bar with invisible start; 25% order reversed; 30% date bounds and unit; 15% fill color.

R04.03.01.03-T08 Add asymmetric custom error bars from confidence-interval columns

原始指令

fixtures/trial_means.xlsx 'Results' has Arm, Mean, CI_low, CI_high for 5 arms. Create a column chart of Mean with custom Y error bars whose plus/minus values come from helper columns you compute (CI_high−Mean, Mean−CI_low), end caps on, error bar line 1.5 pt black. Save.

平台: mac · macOS win · Windows
应用: Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: G2 · GUI 必要
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: click · 指向与点击 type · 文字与表单
工作产物: WP03 · 视觉排版
条件: 未声明
提案难度: 3 / 5

建议验证方式

errBars errValType='cust' with plus/minus numRef pointing to helper ranges whose values equal key; noEndCap=0; line width 19050 EMU, black; Excel-authored c16 ids present. VBA, COM and AppleScript automation disabled, no Python in the VM.

建议部分得分

25% helper columns correct; 45% custom error bars wired to them; 30% caps and styling.

R04.03.01.03-T09 Make an interactive Numbers chart with a year slider

原始指令

In fixtures/fleet.numbers, build an interactive column chart from table 'Fuel by Year' so each year 2019–2025 is a data set selected with a slider; categories are the 6 vehicle classes, y-axis fixed 0–120,000 L across data sets, value labels on. Save.

平台: mac · macOS
应用: Numbers
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: G3 · 仅 GUI
GUI 需求 · 普通权限: G2 · GUI 必要
交互原语: click · 指向与点击 drag · 拖放
工作产物: WP03 · 视觉排版
条件: 未声明
提案难度: 3 / 5

建议验证方式

Grader-side AppleScript export to PDF for each slider position is not possible, so grader opens the file in Numbers via its own UI-automation script, steps the slider and captures 7 renders; each compared to reference (SSIM ≥0.9); chart type checked in exported .xlsx. osascript is blocked for the agent; the file must be saved by Numbers.

建议部分得分

30% interactive chart type; 30% data sets per year; 25% fixed axis; 15% labels.

R04.03.01.03-T10 Chart the last 12 months with a self-extending named range

原始指令

fixtures/kpi_feed.xlsx 'Feed' grows by one row per month. Define names using INDEX/COUNTA (no OFFSET volatile functions) that cover the latest 12 rows, and build a line chart whose series and categories use those names, so new rows shift the window. Save.

平台: mac · macOS win · Windows
应用: Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: G2 · GUI 必要
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: type · 文字与表单 click · 指向与点击
工作产物: WP03 · 视觉排版
条件: 未声明
提案难度: 4 / 5

建议验证方式

Defined names use INDEX/COUNTA, no OFFSET; chart series refer to the names; grader appends 3 rows via openpyxl, re-renders via Excel COM and checks the plotted category labels are the latest 12 months each time. VBA, COM and AppleScript automation disabled, no Python in the VM; file must be saved by Excel (app.xml).

建议部分得分

30% names correct and non-volatile; 30% chart bound to names; 40% window shifts correctly after appends.

R04.03.01.03-T11 Recreate a published chart exactly from a reference image

原始指令

input/target_chart.png is a chart from last year's board pack; the data is in fixtures/board_data.xlsx. Recreate it in Excel: chart type, series order, colors, axis bounds and units, number formats, label placement, legend, gridlines and title text. Place it on 'Board' at B2, size 16×9 cm.

平台: mac · macOS win · Windows
应用: Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: G2 · GUI 必要
GUI 需求 · 普通权限: G2 · GUI 必要
交互原语: click · 指向与点击 vis · 视觉判断 geom · 精确几何
工作产物: WP03 · 视觉排版
条件: 未声明
提案难度: 5 / 5

建议验证方式

Spec diff against a hidden reference chart XML (type, series, colors ΔE2000 ≤3, axes, formats, label positions) plus Excel COM render of 'Board' compared to the target (SSIM ≥0.92); anchor and extent within 0.1 cm. VBA, COM and AppleScript automation disabled, no Python in the VM; file must be saved by Excel (app.xml).

建议部分得分

30% type and series; 25% axes and formats; 20% colors and labels; 25% render SSIM and size.

R04.03.01.03-T12 Compare carrier delivery times with a box-and-whisker chart

原始指令

fixtures/deliveries.xlsx 'Times' has Carrier and DeliveryHours (6,000 rows). Insert an Excel Box & Whisker chart grouped by carrier with outlier points shown, mean markers and mean line off, inner points off, quartile calculation set to exclusive median, y-axis 0–120 h. Save.

平台: mac · macOS win · Windows
应用: Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: G2 · GUI 必要
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: click · 指向与点击
工作产物: WP03 · 视觉排版
条件: 未声明
提案难度: 4 / 5

建议验证方式

chartex layoutId='boxWhisker' with statistics quartileMethod='exclusive', visibility meanMarker=0 meanLine=0 nonoutliers=0 outliers=1; axis bounds; data refs exact. chartex cannot be authored with openpyxl; VBA, COM and AppleScript automation disabled, no Python in the VM.

建议部分得分

35% box chart by carrier; 35% visibility options; 15% quartile method; 15% axis bounds.

R04.03.01.03-T13 Lay out six regional line charts as aligned small multiples

原始指令

fixtures/regional_sales.xlsx: on sheet 'Dashboard' build 6 line charts (one per region) with identical formatting, y-axis fixed 0–500, no legends, titles = region names. Arrange them in a 3×2 grid starting at B2, each exactly 8×5 cm, 0.5 cm gaps, edges aligned.

平台: mac · macOS win · Windows
应用: Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: G2 · GUI 必要
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: geom · 精确几何 drag · 拖放 click · 指向与点击
工作产物: WP03 · 视觉排版
条件: 未声明
提案难度: 4 / 5

建议验证方式

Drawing XML anchors: 6 charts, ext 8×5 cm (±0.05), grid positions and gaps within 0.05 cm; each chart's series refs the correct region; axis min/max 0/500; legend absent; titles exact. Excel-authored c16 ids required. VBA, COM and AppleScript automation disabled, no Python in the VM.

建议部分得分

30% 6 charts with right data; 20% identical axes/format; 35% size and grid alignment; 15% titles/no legends.

R04.03.01.03-T14 Add trend and win/loss sparklines to a KPI table

原始指令

In fixtures/kpi_table.xlsx 'KPIs', add line sparklines in H2:H15 from B:G (monthly values) with high and low points marked red/green, and win/loss sparklines in I2:I15 from the variance columns J:O, with negative points #C00000 and an axis. Save.

平台: mac · macOS win · Windows
应用: Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: G2 · GUI 必要
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: click · 指向与点击 drag · 拖放
工作产物: WP03 · 视觉排版
条件: 未声明
提案难度: 3 / 5

建议验证方式

x14:sparklineGroups: one line group H2:H15 → B:G with high/low markers and colors, one stem (win/loss) group I2:I15 → J:O with negative color and displayXAxis=1; exact ranges per row. openpyxl does not write sparklines; VBA, COM and AppleScript automation disabled, no Python in the VM.

建议部分得分

40% line sparklines with correct ranges; 20% high/low markers; 40% win/loss group with colors and axis.

R04.03.01.03-T15 Repair eight broken charts after a workbook restructure

原始指令

fixtures/monthly_pack.xlsx had rows inserted and a sheet renamed; 8 charts on 'Pack' now plot wrong ranges, two have swapped axes, three carry stale hard-typed titles. Fix each chart per input/chart_spec.md (ranges, series names linked to cells, axes, titles linked to cells) without recreating them.

平台: mac · macOS win · Windows
应用: Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: G2 · GUI 必要
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: click · 指向与点击 hover · 悬停与上下文 vis · 视觉判断
工作产物: WP03 · 视觉排版
条件: hidden · 隐藏 / 过期状态
提案难度: 5 / 5

建议验证方式

Per-chart XML diff vs spec: series refs, tx strRef titles, axis assignment; chart object ids unchanged (fixed, not recreated); render of each chart vs reference SSIM ≥0.9. Excel-authored edits required (c16 ids preserved). VBA, COM and AppleScript automation disabled, no Python in the VM.

建议部分得分

48% series refs; 28% titles; 24% axis assignment; each pro-rata over the 8 charts.

R04.03.01.03-T16 Build a Pareto chart with cumulative line and 80% reference

原始指令

From fixtures/defects.xlsx 'Log' (defect codes), build on 'Pareto' a combo chart: defect counts sorted descending as columns, cumulative % as a line on a secondary axis 0–100%, and a dashed horizontal 80% reference line as an extra series. Add a text label 'Vital few' above the bars that make up 80%. Save.

平台: mac · macOS win · Windows
应用: Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: G2 · GUI 必要
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: click · 指向与点击 geom · 精确几何 type · 文字与表单
工作产物: WP03 · 视觉排版
条件: 未声明
提案难度: 5 / 5

建议验证方式

Helper table counts and cumulative % equal key; chart: bar + 2 line series, cumulative on secondary axis 0–1, reference series constant 0.8 with prstDash dash; text box positioned over the vital-few category span (render bbox check). VBA, COM and AppleScript automation disabled, no Python in the VM; file must be saved by Excel (app.xml).

建议部分得分

25% helper table; 30% combo with secondary axis; 25% dashed 0.8 reference line; 20% label placement.

R04.03.01.03-T17 Show a budget hierarchy as a treemap with banner labels

原始指令

fixtures/opex_budget.xlsx 'Budget' has Division, Department, Amount. Insert an Excel treemap with Division as level 1 and Department as level 2, banner parent labels, fill colors per division from input/division_colors.txt, data labels showing category name and value ($k). Save.

平台: mac · macOS win · Windows
应用: Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: G2 · GUI 必要
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: click · 指向与点击
工作产物: WP03 · 视觉排版
条件: 未声明
提案难度: 3 / 5

建议验证方式

chartex layoutId='treemap' with parentLabelLayout='banner', 2-level strDim, value refs exact; per-division data point fills match the color file; labels show name and value. VBA, COM and AppleScript automation disabled, no Python in the VM; openpyxl cannot write chartex.

建议部分得分

35% treemap with two levels; 20% banner labels; 30% division colors; 15% label content.

R04.03.01.03-T18 Control pair of T03: create the combo chart via the Sheets API

原始指令

Control pair of T03. The same quarterly data is in Google Sheet 'Quarterly PL'. Using the Sheets API (credentials provided), add a combo chart with Revenue columns, Margin % line on the right axis fixed 0–0.4, and data labels on the line only.

平台: web · 任意系统（网页）
应用: Google Sheets · Sheets API
交互表面: api · API / SDK
GUI 需求 · 任务设定: AP · API 足够
GUI 需求 · 普通权限: AP · API 足够
交互原语: code · 代码与命令
工作产物: WP03 · 视觉排版
条件: 未声明
提案难度: 2 / 5

建议验证方式

spreadsheets.get: one chart with basicChart COMBO, series types COLUMN and LINE, line on RIGHT_AXIS with viewWindow 0–0.4, dataLabel on the line only. Compared with T03 to measure GUI vs API success.

建议部分得分

35% combo chart; 35% right axis with bounds; 30% labels on line only.

R04.03.01.03-T19 Build a candlestick stock chart with a volume panel in Calc

原始指令

In fixtures/ticker_daily.ods (synthetic prices: Date, Open, High, Low, Close, Volume), create a LibreOffice Calc stock chart of type 'Volume–Open–Low–High–Close' for the last 60 trading days, rising candles white and falling black, date axis with weekly major ticks. Save.

平台: mac · macOS win · Windows lin · Linux
应用: LibreOffice Calc
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: G2 · GUI 必要
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: click · 指向与点击 type · 文字与表单
工作产物: WP03 · 视觉排版
条件: 未声明
提案难度: 4 / 5

建议验证方式

Chart object in content.xml: stock chart with volume (chart:stock-with-volume), 5 ranges covering exactly the last 60 rows, candle colors, date axis interval 7 days; render vs reference SSIM ≥0.9. Macros/UNO disabled for the agent.

建议部分得分

30% chart type; 30% correct 60-row ranges; 20% candle colors; 20% axis ticks.

R04.03.01.03-T20 Save a brand chart template and apply it to twelve charts

原始指令

Format the first chart in fixtures/annual_review.xlsx to input/brand_charts.pdf (Arial 10 pt, palette of 6 hex colors in order, light grey #D9D9D9 gridlines, no chart border), save it as output/brand.crtx, then apply that template to the other 11 charts without changing their data or chart types.

平台: mac · macOS win · Windows
应用: Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: G2 · GUI 必要
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: click · 指向与点击 nav · 平移 / 缩放 / 滚动
工作产物: WP03 · 视觉排版
条件: long · 长流程
提案难度: 5 / 5

建议验证方式

output/brand.crtx exists and its chart XML carries the spec; all 12 charts' XML: latin typeface Arial 1000, series fills follow the palette order, gridline color D9D9D9, no chart-area border; series refs and chart types unchanged vs input. VBA, COM and AppleScript automation disabled, no Python in the VM; file must be saved by Excel (app.xml).

建议部分得分

25% template file correct; 50% charts conform (pro-rata over 12); 25% data/types unchanged.

已有研究映射

以下沿用研究目录中的基准与小类映射，不是逐题标注、执行记录或产品背书。

表格图表

任务提案 · 20

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

已有研究映射

同工作流族的小类