Sample output · 1 of 3
A sheet in, a question about it, and a report that answers it: the charts the person asked for, drawn from the numbers the sheet holds, with a caption under each one and the rows behind every bar in a workbook.
The first task in a new project also sets up its computer (about 3 min).
Ask a question of your sheet, get a chart report
Try this prompt
Use the Chart Report skill on our orders sheet: how did the lamp sales go across the regions and the months? Give me the total per region, the average order per region, the two biggest regions and the month-over-month change, as a PDF I can send and a workbook with the numbers behind every bar.
Two files for one sheet and one question: report.pdf, the document — a cover that carries the question, a page for every chart with its caption, and a table of the figures the charts are built from — and data.xlsx, the sheet as it was read, plus one row for every plotted point. Plus a page image of the cover and a QA report.
| Field | Required | Hint |
|---|---|---|
| path | Yes | The sheet to report on, at most 200 characters, as a path inside the input folder |
| bytes | Yes | The size of that file in bytes, a whole number; the build refuses a file whose size is not the one stated |
| sheet | No | Which sheet of a workbook to report on, at most 31 characters; a workbook with more than one sheet is refused |
| question | Yes | The question the report answers, at most 500 characters; it is printed on the cover |
| title | Yes | The title on the cover, at most 120 characters |
| subtitle | No | One line under the title, at most 200 characters |
| charts | Yes | Three to six charts: the aggregate (sum, mean, top-N, month-over-month), the column to group by, the number column, the type (bar, line, rank), the title, the caption and, for a top-N, the count |
You say
Use the Chart Report skill on our orders sheet: how did the lamp sales go across the regions and the months? Give me the total per region, the average order per region, the two biggest regions and the month-over-month change, as a PDF I can send and a workbook with the numbers behind every bar.
None
Node 20+; Python with openpyxl and pypdf; Chromium (playwright-core) for the .pdf and the preview; no network at run time
None
path (The sheet to report on, at most 200 characters, as a path inside the input folder), bytes (The size of that file in bytes, a whole number; the build refuses a file whose size is not the one stated), question (The question the report answers, at most 500 characters; it is printed on the cover), title (The title on the cover, at most 120 characters), charts (Three to six charts: the aggregate (sum, mean, top-N, month-over-month), the column to group by, the number column, the type (bar, line, rank), the title, the caption and, for a top-N, the count)
onlypro, claude-code, codex, cursor