Class ContainerInfo

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.