Class ContainerInfo
Stay organized with collections
Save and categorize content based on your preferences.
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.
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-08-12 UTC.
[null,null,["Last updated 2025-08-12 UTC."],[[["\u003cp\u003e\u003ccode\u003eContainerInfo\u003c/code\u003e allows you to access and update an embedded chart's position within a Google Sheet.\u003c/p\u003e\n"],["\u003cp\u003eYou can get the chart's anchor column and row, which determine its main positioning.\u003c/p\u003e\n"],["\u003cp\u003e\u003ccode\u003eOffsetX\u003c/code\u003e and \u003ccode\u003eOffsetY\u003c/code\u003e properties provide pixel-level control over the chart's placement relative to the anchor point.\u003c/p\u003e\n"],["\u003cp\u003eUse the \u003ccode\u003emodify()\u003c/code\u003e and \u003ccode\u003esetPosition()\u003c/code\u003e functions along with \u003ccode\u003eupdateChart()\u003c/code\u003e to change the chart's position programmatically.\u003c/p\u003e\n"]]],[],null,["# Class ContainerInfo\n\nContainerInfo\n\nAccess the chart's position within a sheet. Can be updated using the [EmbeddedChart.modify()](/apps-script/reference/spreadsheet/embedded-chart#modify()) function.\n\n```javascript\nconst sheet = SpreadsheetApp.getActiveSheet();\nconst chart = sheet.getCharts()[0];\nconst modifiedChart = chart.modify().setPosition(5, 5, 0, 0).build();\nsheet.updateChart(modifiedChart);\n``` \n\n### Methods\n\n| Method | Return type | Brief description |\n|-----------------------------------------|-------------|------------------------------------------------------------------------------------------|\n| [getAnchorColumn()](#getAnchorColumn()) | `Integer` | The chart's left side is anchored in this column. |\n| [getAnchorRow()](#getAnchorRow()) | `Integer` | The chart's top side is anchored in this row. |\n| [getOffsetX()](#getOffsetX()) | `Integer` | The chart's upper left hand corner is offset from the anchor column by this many pixels. |\n| [getOffsetY()](#getOffsetY()) | `Integer` | The chart's upper left hand corner is offset from the anchor row by this many pixels. |\n\nDetailed documentation\n----------------------\n\n### `get``Anchor``Column()`\n\nThe chart's left side is anchored in this column.\n\n#### Return\n\n\n`Integer` --- 1-indexed column (that is, column C is 3).\n\n*** ** * ** ***\n\n### `get``Anchor``Row()`\n\nThe chart's top side is anchored in this row.\n\n#### Return\n\n\n`Integer` --- 1-indexed row (that is, row 5 returns 5).\n\n*** ** * ** ***\n\n### `get``Offset``X()`\n\nThe chart's upper left hand corner is offset from the anchor column by this many pixels.\n\n#### Return\n\n\n`Integer` --- The horizontal offset in pixels for the upper left hand corner of the chart.\n\n*** ** * ** ***\n\n### `get``Offset``Y()`\n\nThe chart's upper left hand corner is offset from the anchor row by this many pixels.\n\n#### Return\n\n\n`Integer` --- The vertical offset in pixels for the upper left hand corner of the chart."]]
