wehub-resource-sync
8cb1f9f479
2.4 KiB
charts — Master chart showcase
Generates charts.xlsx: eight chart types across four data sheets, built with
the high-level officecli add --type chart command (one add per chart). Each
chart references its sheet data by cell range (dataRange) — or, where the source
cells aren't contiguous, inline series/categories.
Three files (the usual four-set, minus a hand-written .xlsx — it's generated):
- charts.sh — CLI script (
officecli add --type chart …). - charts.py — SDK twin (same commands over one resident).
- charts.xlsx — generated output.
cd examples/excel
bash charts.sh # or: python3 charts.py
For per-type deep dives (every option of a single chart kind) see the
charts/ subdirectory (charts-column.sh, charts-combo.sh,
charts-stock.sh, …).
The eight charts
| # | Sheet | Type | Key props |
|---|---|---|---|
| 1 | Sheet1 | Combo | combotypes=column,column,column,column,line + secondaryaxis=5 (YoY-growth line on a right-hand axis) |
| 2 | Sheet1 | 3D column | chartType=column3d + view3d=15,20,30 |
| 3 | Analysis | Scatter | chartType=scatter + trendline=linear (equation + R² shown) |
| 4 | Sheet1 | 3D pie (exploded) | chartType=pie3d + explosion=10 + view3d=30,70,30 + dataLabels=percent |
| 5 | Analysis | Bubble | raw-set — see note below |
| 6 | StockData | Stock OHLC | chartType=stock + hilowlines=true + updownbars=100:FF0000:00B050 (red up / green down) |
| 7 | Assessment | Filled radar | chartType=radar + radarStyle=filled |
| 8 | Sheet1 | Multi-ring doughnut | chartType=doughnut + two inline series (two rings) |
Common props on every chart: title, colors (comma-separated palette),
legend=b, and x/y/width/height (position and size in cell units).
Why Chart 5 (bubble) stays on raw-set
A bubble point needs three coordinates — x, y and size. The high-level
add --type chart --prop chartType=bubble reads a multi-column dataRange as
several y-series sharing column A as x; it cannot map three columns to a single
x / y / size series (a multi-point bubble). Until that mapping exists, the
faithful single-series bubble is authored with raw-set. Every other chart here
uses the high-level command.
Inspect
officecli validate charts.xlsx
officecli view charts.xlsx outline
officecli query charts.xlsx chart # list all chart parts
officecli get charts.xlsx '/Sheet1/chart[1]'