chart_update
Reconfigure an existing chart without moving it: change chart type, series, titles, axis scale, and labels. Get the chart ID from chart list first.
Instructions
Reconfigure an existing chart in place, keeping its position. Anything left out keeps its current value; an empty string clears a text field (title, axis title, number format). Get the chart_id from chart__list first.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| title | No | Empty string clears it. | |
| numFmt | No | Excel number-format code for the value axis and labels, e.g. "#,##0.00" or "0%". Empty falls back to the source cells' own format. | |
| series | No | One entry per data series. Each valueRef is an A1 range of the values to plot. | |
| chartId | Yes | From chart__list. | |
| stacked | No | Stack the series. Ignored by pie and scatter. | |
| sheetIdx | Yes | ||
| chartType | No | ||
| legendPos | No | ||
| catAxisTitle | No | ||
| valAxisScale | No | Replaces the whole value-axis scale — fields left out become automatic, which is how a fixed bound is cleared. | |
| valAxisTitle | No | ||
| categoriesRef | No | Re-point the category labels (A1 range). | |
| showDataLabels | No | Print each point's value next to it. | |
| showPercentLabels | No | Add the percentage to labels (pie-like charts). |