Class ContainerInfo

Access the chart's position within a sheet. Can be updated using the EmbeddedChart.modify() function.

const sheet = SpreadsheetApp.getActiveSheet();
const chart = sheet.getCharts()[0];
const modifiedChart = chart.modify().setPosition(5, 5, 0, 0).build();
sheet.updateChart(modifiedChart);

Methods

Method	Return type	Brief description
`getAnchorColumn()`	`Integer`	The chart's left side is anchored in this column.
`getAnchorRow()`	`Integer`	The chart's top side is anchored in this row.
`getOffsetX()`	`Integer`	The chart's upper left hand corner is offset from the anchor column by this many pixels.
`getOffsetY()`	`Integer`	The chart's upper left hand corner is offset from the anchor row by this many pixels.

Detailed documentation

`getAnchorColumn()`

The chart's left side is anchored in this column.

Return

Integer — 1-indexed column (that is, column C is 3)

`getAnchorRow()`

The chart's top side is anchored in this row.

Return

Integer — 1-indexed row (that is, row 5 returns 5)

`getOffsetX()`

The chart's upper left hand corner is offset from the anchor column by this many pixels.

Return

Integer — the horizontal offset in pixels for the upper left hand corner of the chart

`getOffsetY()`

The chart's upper left hand corner is offset from the anchor row by this many pixels.

Return

Integer — the vertical offset in pixels for the upper left hand corner of the chart