wehub-resource-sync
8cb1f9f479
Publish SDK (PyPI) / publish (push) Has been cancelled
Publish SDK (npm) / publish (@aionui/officecli-sdk) (push) Has been cancelled
SDK smoke / smoke (windows-latest) (push) Has been cancelled
Publish SDK (npm) / publish (@officecli/officecli-sdk) (push) Has been cancelled
Publish SDK (npm) / publish (@officecli/sdk) (push) Has been cancelled
Publish SDK (npm) / publish (officecli-sdk) (push) Has been cancelled
SDK smoke / smoke (macos-latest) (push) Has been cancelled
SDK smoke / smoke (ubuntu-latest) (push) Has been cancelled
Skill parity / diff (push) Has been cancelled
56 lines
2.4 KiB
Markdown
56 lines
2.4 KiB
Markdown
# 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.
|
|
|
|
```bash
|
|
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/`](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
|
|
|
|
```bash
|
|
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]'
|
|
```
|