Class ContainerInfo

  • ContainerInfo allows you to access and update an embedded chart's position within a Google Sheet.

  • You can get the chart's anchor column and row, which determine its main positioning.

  • OffsetX and OffsetY properties provide pixel-level control over the chart's placement relative to the anchor point.

  • Use the modify() and setPosition() functions along with updateChart() to change the chart's position programmatically.
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

MethodReturn typeBrief description
getAnchorColumn()IntegerThe chart's left side is anchored in this column.
getAnchorRow()IntegerThe chart's top side is anchored in this row.
getOffsetX()IntegerThe chart's upper left hand corner is offset from the anchor column by this many pixels.
getOffsetY()IntegerThe 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.