Class SheetsChart

A PageElement representing a linked chart embedded from Google Sheets.

Methods

Method	Return type	Brief description
`alignOnPage(alignmentPosition)`	`SheetsChart`	Aligns the element to the specified alignment position on the page.
`asImage()`	`Image`	Returns the chart as an image or `null` if the chart is not an embedded image.
`bringForward()`	`SheetsChart`	Brings the page element forward on the page by one element.
`bringToFront()`	`SheetsChart`	Brings the page element to the front of the page.
`duplicate()`	`PageElement`	Duplicates the page element.
`getChartId()`	`Integer`	Gets the ID of the specific chart in the Google Sheets spreadsheet that is embedded.
`getConnectionSites()`	`ConnectionSite[]`	Returns the list of `ConnectionSite`s on the page element, or an empty list if the page element does not have any connection sites.
`getDescription()`	`String`	Returns the page element's description.
`getEmbedType()`	`SheetsChartEmbedType`	Returns the embed type of the Sheets chart.
`getHeight()`	`Number`	Gets the element's height in points, which is the height of the element's bounding box when the element has no rotation.
`getInherentHeight()`	`Number`	Returns the element's inherent height in points.
`getInherentWidth()`	`Number`	Returns the element's inherent width in points.
`getLeft()`	`Number`	Returns the element's horizontal position in points, measured from the upper-left corner of the page when the element has no rotation.
`getLink()`	`Link`	Returns the `Link` or `null` if there is no link.
`getObjectId()`	`String`	Returns the unique ID for this object.
`getPageElementType()`	`PageElementType`	Returns the page element's type, represented as a `PageElementType` enum.
`getParentGroup()`	`Group`	Returns the group this page element belongs to, or `null` if the element is not in a group.
`getParentPage()`	`Page`	Returns the page this page element is on.
`getRotation()`	`Number`	Returns the element's clockwise rotation angle around its center in degrees, where zero degrees means no rotation.
`getSpreadsheetId()`	`String`	Gets the ID of the Google Sheets spreadsheet that contains the source chart.
`getTitle()`	`String`	Returns the page element's title.
`getTop()`	`Number`	Gets the element's vertical position in points, measured from the upper-left corner of the page when the element has no rotation.
`getTransform()`	`AffineTransform`	Returns the page element's transform.
`getWidth()`	`Number`	Returns the element's width in points, which is the width of the element's bounding box when the element has no rotation.
`preconcatenateTransform(transform)`	`SheetsChart`	Preconcatenates the provided transform to the existing transform of the page element.
`refresh()`	`void`	Refreshes the chart by replacing it with the latest version of the chart from Google Sheets.
`remove()`	`void`	Removes the page element.
`removeLink()`	`void`	Removes a `Link`.
`scaleHeight(ratio)`	`SheetsChart`	Scales the element's height by the specified ratio.
`scaleWidth(ratio)`	`SheetsChart`	Scales the element's width by the specified ratio.
`select()`	`void`	Selects only the `PageElement` in the active presentation and removes any previous selection.
`select(replace)`	`void`	Selects the `PageElement` in the active presentation.
`sendBackward()`	`SheetsChart`	Sends the page element backward on the page by one element.
`sendToBack()`	`SheetsChart`	Sends the page element to the back of the page.
`setDescription(description)`	`SheetsChart`	Sets the page element's alt text description.
`setHeight(height)`	`SheetsChart`	Sets the element's height in points, which is the height of the element's bounding box when the element has no rotation.
`setLeft(left)`	`SheetsChart`	Sets the element's horizontal position in points, measured from the upper-left corner of the page when the element has no rotation.
`setLinkSlide(slideIndex)`	`Link`	Sets a `Link` to the given `Slide` using the zero-based index of the slide.
`setLinkSlide(slide)`	`Link`	Sets a `Link` to the given `Slide`, the link is set by the given slide ID.
`setLinkSlide(slidePosition)`	`Link`	Sets a `Link` to the given `Slide` using the relative position of the slide.
`setLinkUrl(url)`	`Link`	Sets a `Link` to the given non-empty URL string.
`setRotation(angle)`	`SheetsChart`	Sets the element's clockwise rotation angle around its center in degrees.
`setTitle(title)`	`SheetsChart`	Sets the page element's alt text title.
`setTop(top)`	`SheetsChart`	Sets the element's vertical position in points, measured from the upper-left corner of the page when the element has no rotation.
`setTransform(transform)`	`SheetsChart`	Sets the transform of the page element with the provided transform.
`setWidth(width)`	`SheetsChart`	Sets the element's width in points, which is the width of the element's bounding box when the element has no rotation.

Detailed documentation

`alignOnPage(alignmentPosition)`

Aligns the element to the specified alignment position on the page.

Parameters

Name	Type	Description
`alignmentPosition`	`AlignmentPosition`	The position to align this page element to on the page.

Return

SheetsChart — This page element, for chaining.

`asImage()`

Returns the chart as an image or null if the chart is not an embedded image.

Return

Image — This chart as an image, or null if the chart is not an embedded image.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`bringForward()`

Brings the page element forward on the page by one element.

The page element must not be in a group.

Return

SheetsChart — This page element, for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`bringToFront()`

Brings the page element to the front of the page.

The page element must not be in a group.

Return

SheetsChart — This page element, for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`duplicate()`

Duplicates the page element.

The duplicate page element is placed on the same page at the same position as the original.

Return

PageElement — The new duplicate of this page element.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`getChartId()`

Gets the ID of the specific chart in the Google Sheets spreadsheet that is embedded.

Return

Integer — The ID of the embedded chart.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`getConnectionSites()`

Returns the list of ConnectionSites on the page element, or an empty list if the page element does not have any connection sites.

Return

ConnectionSite[] — The connection sites list, which may be empty if this element has no connection sites.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`getDescription()`

Returns the page element's description. The description is combined with the title to display and read alt text.

Return

String — The page element's description.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`getEmbedType()`

Returns the embed type of the Sheets chart.

Return

SheetsChartEmbedType — The embed type of this chart.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`getHeight()`

Gets the element's height in points, which is the height of the element's bounding box when the element has no rotation.

Return

Number — The page element's inherent height in points, or null if the page element does not have a height.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`getInherentHeight()`

Returns the element's inherent height in points.

The page element's transform is relative to its inherent size. Use the inherent size in conjunction with the element's transform to determine the element's final visual appearance.

Return

Number — The page element's inherent height in points, or null if the page element does not have a height.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`getInherentWidth()`

Returns the element's inherent width in points.

The page element's transform is relative to its inherent size. Use the inherent size in conjunction with the element's transform to determine the element's final visual appearance.

Return

Number — The page element's inherent width in points, or null if the page element does not have a width.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`getLeft()`

Returns the element's horizontal position in points, measured from the upper-left corner of the page when the element has no rotation.

Return

Number — This element's horizonal position in points, from the upper-left corner of the page.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`getLink()`

Returns the Link or null if there is no link.

var link = shape.getLink();
if (link != null) {
  Logger.log('Shape has a link of type: ' + link.getLinkType());
}

Return

Link

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`getObjectId()`

Returns the unique ID for this object. Object IDs used by pages and page elements share the same namespace.

Return

String — The unique ID for this object.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`getPageElementType()`

Returns the page element's type, represented as a PageElementType enum.

Return

PageElementType — The page element's type.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`getParentGroup()`

Returns the group this page element belongs to, or null if the element is not in a group.

Return

Group — The group this page element belongs to, or null.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`getParentPage()`

Returns the page this page element is on.

Return

Page — The page this element resides on.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`getRotation()`

Returns the element's clockwise rotation angle around its center in degrees, where zero degrees means no rotation.

Return

Number — The rotation angle in degrees between 0 (inclusive) and 360 (exclusive).

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`getSpreadsheetId()`

Gets the ID of the Google Sheets spreadsheet that contains the source chart.

Return

String — The ID of the spreadsheet that contains the source chart.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`getTitle()`

Returns the page element's title. The title is combined with the description to display and read alt text.

Return

String — The page element's title.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`getTop()`

Gets the element's vertical position in points, measured from the upper-left corner of the page when the element has no rotation.

Return

Number — This element's vertical position in points, from the upper-left corner of the page.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`getTransform()`

Returns the page element's transform.

The visual appearance of the page element is determined by its absolute transform. To compute the absolute transform, preconcatenate a page element's transform with the transforms of all of its parent groups. If the page element is not in a group, its absolute transform is the same as the value in this field.

Return

AffineTransform — The page element's transform.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`getWidth()`

Returns the element's width in points, which is the width of the element's bounding box when the element has no rotation.

Return

Number — The page element's inherent width in points, or null if the page element does not have a width.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`preconcatenateTransform(transform)`

Preconcatenates the provided transform to the existing transform of the page element.

newTransform = argument * existingTransform

For example, to move a page elements 36 points to the left:

element.preconcatenateTransform(SlidesApp.newAffineTransformBuilder()
    .setTranslateX(-36.0)
    .build());

You can also replace the page element's transform with setTransform(transform).

Parameters

Name	Type	Description
`transform`	`AffineTransform`	The transform to preconcatenate onto this page element's transform.

Return

SheetsChart — This page element, for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`refresh()`

Refreshes the chart by replacing it with the latest version of the chart from Google Sheets. If the chart is already up to date, does not make any change to the chart in the presentation.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/spreadsheets.readonly

`remove()`

Removes the page element.

If after a remove operation, a Group contains only one or no page elements, the group itself is also removed.

If a placeholder PageElement is removed on a master or layout, any empty inheriting placeholders are also removed.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`removeLink()`

Removes a Link.

shape.removeLink();

`scaleHeight(ratio)`

Scales the element's height by the specified ratio. The element's height is the height of its bounding box when the element has no rotation.

Parameters

Name	Type	Description
`ratio`	`Number`	The ratio to scale this page element's height by.

Return

SheetsChart — This page element, for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`scaleWidth(ratio)`

Scales the element's width by the specified ratio. The element's width is the width of its bounding box when the element has no rotation.

Parameters

Name	Type	Description
`ratio`	`Number`	The ratio to scale this page element's width by.

Return

SheetsChart — This page element, for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`select()`

Selects only the PageElement in the active presentation and removes any previous selection. This is same as calling select(replace) with true.

A script can only access the selection of the user who is running the script, and only if the script is bound to the presentation.

This sets the parent Page of the PageElement as the current page selection.

var slide = SlidesApp.getActivePresentation().getSlides()[0];
var pageElement = slide.getPageElements()[0];
// Only select this page element and replace any previous selection.
pageElement.select();

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`select(replace)`

Selects the PageElement in the active presentation.

A script can only access the selection of the user who is running the script, and only if the script is bound to the presentation.

Pass true to this method to select only the PageElement and remove any previous selection. This also sets the parent Page of the PageElement as the current page selection.

Pass false to select multiple PageElement objects. The PageElement objects must be in the same Page.

The following conditions must be met while selecting a page element using a false parameter:

The parent Page of the PageElement object must be the current page selection.
There should not be multiple Page objects selected.

To make sure that’s the case the preferred approach is to select the parent Page first using Page.selectAsCurrentPage() and then select the page elements in that page.

var slide = SlidesApp.getActivePresentation().getSlides()[0];
// First select the slide page, as the current page selection.
slide.selectAsCurrentPage();
// Then select all the page elements in the selected slide page.
var pageElements = slide.getPageElements();
for (var i = 0; i < pageElements.length; i++) {
  pageElements[i].select(false);
}

Parameters

Name	Type	Description
`replace`	`Boolean`	If `true`, the selection replaces any previous selection; otherwise the selection is added to any previous selection.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`sendBackward()`

Sends the page element backward on the page by one element.

The page element must not be in a group.

Return

SheetsChart — This page element, for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`sendToBack()`

Sends the page element to the back of the page.

The page element must not be in a group.

Return

SheetsChart — This page element, for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`setDescription(description)`

Sets the page element's alt text description.

The method is not supported for Group elements.

// Set the first page element's alt text description to "new alt text description".
var pageElement = SlidesApp.getActivePresentation().getSlides()[0].getPageElements()[0];
pageElement.setDescription('new alt text description');
Logger.log(pageElement.getDescription());

Parameters

Name	Type	Description
`description`	`String`	The string to set the alt text description to.

Return

SheetsChart — This page element.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`setHeight(height)`

Sets the element's height in points, which is the height of the element's bounding box when the element has no rotation.

Parameters

Name	Type	Description
`height`	`Number`	The new height of this page element to set, in points.

Return

SheetsChart — This page element, for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`setLeft(left)`

Sets the element's horizontal position in points, measured from the upper-left corner of the page when the element has no rotation.

Parameters

Name	Type	Description
`left`	`Number`	The new horizontal position to set, in points.

Return

SheetsChart — This page element, for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`setLinkSlide(slideIndex)`

Sets a Link to the given Slide using the zero-based index of the slide.

// Set a link to the first slide of the presentation.
shape.setLinkSlide(0);

Parameters

Name	Type	Description
`slideIndex`	`Integer`	The zero-based index to the slide.

Return

Link — the Link that was set

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`setLinkSlide(slide)`

Sets a Link to the given Slide, the link is set by the given slide ID.

// Set a link to the first slide of the presentation.
var slide = presentation.getSlides()[0];
shape.setLinkSlide(slide);

Parameters

Name	Type	Description
`slide`	`Slide`	The `Slide` to be linked.

Return

Link — the Link that was set

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`setLinkSlide(slidePosition)`

Sets a Link to the given Slide using the relative position of the slide.

// Set a link to the first slide of the presentation.
shape.setLinkSlide(SlideApp.SlidePosition.FIRST_SLIDE);

Parameters

Name	Type	Description
`slidePosition`	`SlidePosition`	The relative `SlidePosition`.

Return

Link — the Link that was set

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`setLinkUrl(url)`

Sets a Link to the given non-empty URL string.

// Set a link to the URL.
shape.setLinkUrl("https://slides.google.com");

Parameters

Name	Type	Description
`url`	`String`	The URL string.

Return

Link — the Link that was set

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`setRotation(angle)`

Sets the element's clockwise rotation angle around its center in degrees.

Parameters

Name	Type	Description
`angle`	`Number`	The new clockwise rotation angle to set, in degrees.

Return

SheetsChart — This page element, for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`setTitle(title)`

Sets the page element's alt text title.

The method is not supported for Group elements.

// Set the first page element's alt text title to "new alt text title".
var pageElement = SlidesApp.getActivePresentation().getSlides()[0].getPageElements()[0];
pageElement.setTitle('new alt text title');
Logger.log(pageElement.getTitle());

Parameters

Name	Type	Description
`title`	`String`	The string to set the alt text title to.

Return

SheetsChart — This page element.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`setTop(top)`

Sets the element's vertical position in points, measured from the upper-left corner of the page when the element has no rotation.

Parameters

Name	Type	Description
`top`	`Number`	The new vertical position to set, in points.

Return

SheetsChart — This page element, for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`setTransform(transform)`

Sets the transform of the page element with the provided transform.

Updating the transform of a group changes the absolute transform of the page elements in that group, which can change their visual appearance.

Updating the transform of a page element that is in a group only changes the transform of that page element; it doesn't affect the transforms of the group or other page elements in the group.

For details on how transforms impact visual appearance of page elements, see getTransform().

Parameters

Name	Type	Description
`transform`	`AffineTransform`	The transform that is set for this page element.

Return

SheetsChart — This element, for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations

`setWidth(width)`

Sets the element's width in points, which is the width of the element's bounding box when the element has no rotation.

Parameters

Name	Type	Description
`width`	`Number`	The new width of this page element to set, in points.

Return

SheetsChart — This page element, for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/presentations.currentonly
https://www.googleapis.com/auth/presentations