Google Apps Script

Class ContainerInfo

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

 
chart = chart.modify().setPosition(5, 5, 0, 0).build();
 sheet.updateChart(chart);
 

Methods

MethodReturn typeBrief description
getAnchorColumn()IntegerThe chart's left side will be anchored in this column.
getAnchorRow()IntegerThe chart's top side will be anchored in this row.
getOffsetX()IntegerThe chart's upper left hand corner will be offset from the anchor column by this many pixels.
getOffsetY()IntegerChart's upper left hand corner will be offset from the anchor row by this many pixels.

Detailed documentation

getAnchorColumn()

The chart's left side will be anchored in this column.

Return

Integer — 1-indexed column (i.e. column C will be 3)


getAnchorRow()

The chart's top side will be anchored in this row.

Return

Integer — 1-indexed row (i.e. row 5 will return 5)


getOffsetX()

The chart's upper left hand corner will be 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()

Chart's upper left hand corner will be 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

Authentication required

You need to be signed in with Google+ to do that.

Signing you in...

Google Developers needs your permission to do that.